Regular Expressions 101

Pro

^start of line

Group 1(.*?)

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

Negative Lookbehind(?<!\d)

\da digit

\d{5}a digit, repeated exactly 5 times

Negative Lookahead(?!\d)

\da digit

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

^(.*?)(?<!\d)\d{5}(?!\d)

New

;SUPER U CHARLY SUR MARNE;;;rte de Pavant CHARLY SUR MARNE Picardie 02310;Charly-sur-Marne;;;02310;;;;;;;;;;;;;;

;SUPER U CHARLY SUR MARNE;;;rte de Pavant CHARLY SUR MARNE Picardie 02310;Charly-sur-Marne;;;02310;;;;;;;;;;;;;;