Regular Expressions 101

Pro

Group 1(((?P<firstString>(?P<word>^.*?),.*?) {2,3}(?P<secondString>\n^(?P=word)(?P<secondStringWithoutWord>.*))))

Group 2((?P<firstString>(?P<word>^.*?),.*?) {2,3}(?P<secondString>\n^(?P=word)(?P<secondStringWithoutWord>.*)))

Group firstString(?P<firstString>(?P<word>^.*?),.*?)

Group word(?P<word>^.*?)

^start of line

.*?any Unicode character (except for line terminators), repeated any number of times

,the literal , (44₁₀ / 54₈ / 2C₁₆)

.*?any Unicode character (except for line terminators), repeated any number of times

{2,3}the literal (32₁₀ / 40₈ / 20₁₆) , repeated between 2 and 3 times

Group secondString(?P<secondString>\n^(?P=word)(?P<secondStringWithoutWord>.*))

\na line-feed (newline) character (ASCII 10)

^start of line

(?P=word)the text saved by group word

Group secondStringWithoutWord(?P<secondStringWithoutWord>.*)

.*any Unicode character (except for line terminators), repeated any number of times

Global pattern flags

g modifier: global. Finds all matches instead of stopping after the first

m modifier: multiline. Causes ^ and $ to match the start and end of each line, not only the start and end of the string

Detailed match information will be displayed here automatically.

25 tokens

Regular Expression

(((?P<firstString>(?P<word>^.*?),.*?) {2,3}(?P<secondString>\n^(?P=word)(?P<secondStringWithoutWord>.*))))

New

ce3520, 3, 555420   
ce3520, 3, 555561   
vs5020, Manual, 554548  
vs5020, Ad, 1000382766  
vs5021, Manual, 554549  
vs5021, Ad, 1000382773  
vs5023, Manual, 554550  
vs5023, Ad, 1000382793

Extraction

ce3520, 3, 555420   
ce3520, 3, 555561   
vs5020, Manual, 554548  
vs5020, Ad, 1000382766  
vs5021, Manual, 554549  
vs5021, Ad, 1000382773  
vs5023, Manual, 554550  
vs5023, Ad, 1000382793