Regular Expressions 101

Pro

Group x(?P<x>\w*?)

\w*?a Unicode word character, repeated any number of times

Group y(?P<y>\d*)

\d*a Unicode decimal digit, repeated any number of times

$end of line

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<x>\w*?)(?P<y>\d*)$

New

df
           Ref
0         CU12
1         SE00
2      RLA1234
3      12345
3       RLA456
4         LU00
5  RLA1234MA12
6  RLA1234MA13
7         CU00
8         LU00

Substitution

df
           Ref
0         CU12
1         SE00
2      RLA1234
3      12345
3       RLA456
4         LU00
5  RLA1234MA12
6  RLA1234MA13
7         CU00
8         LU00