regex101: Python Substitution Workspace

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

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

Substitution

\g<firstString>\g<secondStringWithoutWord>

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