Regex tester
Pattern
Input
<Row>
<Cell><Data ss:Type="String">INC000012486615</Data></Cell>
<Cell><Data ss:Type="String">abcd-efg-hij4-en:ddcs</Data></Cell>
<Cell><Data ss:Type="String">fs-hubraum-apps:kayw-de</Data></Cell>
<Cell><Data ss:Type="String">mn-def-seb01:sfyc-en</Data></Cell>
<Cell><Data ss:Type="String">00055s4dEN</Data></Cell>
<Cell><Data ss:Type="String"></Data></Cell>
<Cell><Data ss:Type="String">General Information</Data></Cell>
<Cell ss:StyleID="ce2"><Data  ss:Type="DateTime">2017-06-28T16:24:35</Data>
</Cell><Cell><Data ss:Type="String">Public</Data></Cell>
<Cell><Data ss:Type="String">Hi John,
Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur. Excepteur sint occaecat cupidatat non proident, sunt in culpa qui officia deserunt mollit anim id est laborum.
Thanks,
Snow</Data></Cell>  
</Row>
Options
Replacement
Click the context tab to see replacements.
10 matches found in about 3 milliseconds.
IndexPositionMatched String$1$2
036INC000012486615INC0000124866155
15 captures
  1. I
  2. N
  3. C
  4. 0
  5. 0
  6. 0
  7. 0
  8. 1
  9. 2
  10. 4
  11. 8
  12. 6
  13. 6
  14. 1
  15. 5
196abcd-efg-hij4-en:ddcsabcd-efg-hij4-en:ddcss
21 captures
  1. a
  2. b
  3. c
  4. d
  5. -
  6. e
  7. f
  8. g
  9. -
  10. h
  11. i
  12. j
  13. 4
  14. -
  15. e
  16. n
  17. :
  18. d
  19. d
  20. c
  21. s
2162fs-hubraum-apps:kayw-defs-hubraum-apps:kayw-dee
23 captures
  1. f
  2. s
  3. -
  4. h
  5. u
  6. b
  7. r
  8. a
  9. u
  10. m
  11. -
  12. a
  13. p
  14. p
  15. s
  16. :
  17. k
  18. a
  19. y
  20. w
  21. -
  22. d
  23. e
3230mn-def-seb01:sfyc-enmn-def-seb01:sfyc-enn
20 captures
  1. m
  2. n
  3. -
  4. d
  5. e
  6. f
  7. -
  8. s
  9. e
  10. b
  11. 0
  12. 1
  13. :
  14. s
  15. f
  16. y
  17. c
  18. -
  19. e
  20. n
429500055s4dEN00055s4dENN
10 captures
  1. 0
  2. 0
  3. 0
  4. 5
  5. 5
  6. s
  7. 4
  8. d
  9. E
  10. N
5350empty stringempty stringempty string
6395General InformationGeneral Informationn
19 captures
  1. G
  2. e
  3. n
  4. e
  5. r
  6. a
  7. l
  8. whitespace
  9. I
  10. n
  11. f
  12. o
  13. r
  14. m
  15. a
  16. t
  17. i
  18. o
  19. n
74792017-06-28T16:24:352017-06-28T16:24:355
19 captures
  1. 2
  2. 0
  3. 1
  4. 7
  5. -
  6. 0
  7. 6
  8. -
  9. 2
  10. 8
  11. T
  12. 1
  13. 6
  14. :
  15. 2
  16. 4
  17. :
  18. 3
  19. 5
8543PublicPublicc
6 captures
  1. P
  2. u
  3. b
  4. l
  5. i
  6. c
9594Hi John,
Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur. Excepteur sint occaecat cupidatat non proident, sunt in culpa qui officia deserunt mollit anim id est laborum.
Thanks,
Snow		Hi John,
Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur. Excepteur sint occaecat cupidatat non proident, sunt in culpa qui officia deserunt mollit anim id est laborum.
Thanks,
Snow		w
470 captures
  1. H
  2. i
  3. whitespace
  4. J
  5. o
  6. h
  7. n
  8. ,
  9. whitespace
  10. whitespace
  11. L
  12. o
  13. r
  14. e
  15. m
  16. whitespace
  17. i
  18. p
  19. s
  20. u
  21. m
  22. whitespace
  23. d
  24. o
  25. l
  26. o
  27. r
  28. whitespace
  29. s
  30. i
  31. t
  32. whitespace
  33. a
  34. m
  35. e
  36. t
  37. ,
  38. whitespace
  39. c
  40. o
  41. n
  42. s
  43. e
  44. c
  45. t
  46. e
  47. t
  48. u
  49. r
  50. whitespace
  51. a
  52. d
  53. i
  54. p
  55. i
  56. s
  57. c
  58. i
  59. n
  60. g
  61. whitespace
  62. e
  63. l
  64. i
  65. t
  66. ,
  67. whitespace
  68. s
  69. e
  70. d
  71. whitespace
  72. d
  73. o
  74. whitespace
  75. e
  76. i
  77. u
  78. s
  79. m
  80. o
  81. d
  82. whitespace
  83. t
  84. e
  85. m
  86. p
  87. o
  88. r
  89. whitespace
  90. i
  91. n
  92. c
  93. i
  94. d
  95. i
  96. d
  97. u
  98. n
  99. t
  100. whitespace
  101. u
  102. t
  103. whitespace
  104. l
  105. a
  106. b
  107. o
  108. r
  109. e
  110. whitespace
  111. e
  112. t
  113. whitespace
  114. d
  115. o
  116. l
  117. o
  118. r
  119. e
  120. whitespace
  121. m
  122. a
  123. g
  124. n
  125. a
  126. whitespace
  127. a
  128. l
  129. i
  130. q
  131. u
  132. a
  133. .
  134. whitespace
  135. U
  136. t
  137. whitespace
  138. e
  139. n
  140. i
  141. m
  142. whitespace
  143. a
  144. d
  145. whitespace
  146. m
  147. i
  148. n
  149. i
  150. m
  151. whitespace
  152. v
  153. e
  154. n
  155. i
  156. a
  157. m
  158. ,
  159. whitespace
  160. q
  161. u
  162. i
  163. s
  164. whitespace
  165. n
  166. o
  167. s
  168. t
  169. r
  170. u
  171. d
  172. whitespace
  173. e
  174. x
  175. e
  176. r
  177. c
  178. i
  179. t
  180. a
  181. t
  182. i
  183. o
  184. n
  185. whitespace
  186. u
  187. l
  188. l
  189. a
  190. m
  191. c
  192. o
  193. whitespace
  194. l
  195. a
  196. b
  197. o
  198. r
  199. i
  200. s
270 more not shown 
<Row>
​<Cell><Data ss:Type="String">INC000012486615</Data></Cell>
​<Cell><Data ss:Type="String">abcd-efg-hij4-en:ddcs</Data></Cell>
​<Cell><Data ss:Type="String">fs-hubraum-apps:kayw-de</Data></Cell>
​<Cell><Data ss:Type="String">mn-def-seb01:sfyc-en</Data></Cell>
​<Cell><Data ss:Type="String">00055s4dEN</Data></Cell>
​<Cell><Data ss:Type="String"></Data></Cell>
​<Cell><Data ss:Type="String">General Information</Data></Cell>
​<Cell ss:StyleID="ce2"><Data  ss:Type="DateTime">2017-06-28T16:24:35</Data>
​</Cell><Cell><Data ss:Type="String">Public</Data></Cell>
​<Cell><Data ss:Type="String">Hi John,
​Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur. Excepteur sint occaecat cupidatat non proident, sunt in culpa qui officia deserunt mollit anim id est laborum.
​Thanks,
​Snow</Data></Cell>  
​</Row>
​
  1. <Row>
    <Cell><Data ss:Type="String">
  2. INC000012486615
  3. 5
  4. </Data></Cell>
    <Cell><Data ss:Type="String">
  5. abcd-efg-hij4-en:ddcs
  6. s
  7. </Data></Cell>
    <Cell><Data ss:Type="String">
  8. fs-hubraum-apps:kayw-de
  9. e
  10. </Data></Cell>
    <Cell><Data ss:Type="String">
  11. mn-def-seb01:sfyc-en
  12. n
  13. </Data></Cell>
    <Cell><Data ss:Type="String">
  14. 00055s4dEN
  15. N
  16. </Data></Cell>
    <Cell><Data ss:Type="String">
  17. empty string
  18. </Data></Cell>
    <Cell><Data ss:Type="String">
  19. General Information
  20. n
  21. </Data></Cell>
    <Cell ss:StyleID="ce2"><Data ss:Type="DateTime">
  22. 2017-06-28T16:24:35
  23. 5
  24. </Data>
    </Cell><Cell><Data ss:Type="String">
  25. Public
  26. c
  27. </Data></Cell>
    <Cell><Data ss:Type="String">
  28. Hi John,
    Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur. Excepteur sint occaecat cupidatat non proident, sunt in culpa qui officia deserunt mollit anim id est laborum.
    Thanks,
    Snow
  29. w
  30. </Data></Cell>
    </Row>
Info
Info Regex Storm © 2010 - 2024 Will Boyd
Part of the Coder's Block portfolio
Contact
Contact Twitter: @lonekorean
Email: will@coders-spam-misdirect-block.com
Pages
Pages
Home Tester Reference About