regex101: PCRE (Legacy) Substitution Workspace

Group 1([A-Z,0-9, ]*\d ){0,1}

{0,1}repeats the group contents below at most once:

Character Class[A-Z,0-9, ]*

*matches any number of characters from the set below:

A-Zone character from A (65₁₀) to Z (90₁₀) (case sensitive)

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

0-9one character from 0 (48₁₀) to 9 (57₁₀)

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

the literal (32₁₀ / 40₈ / 20₁₆)

\da digit

the literal (32₁₀ / 40₈ / 20₁₆)

Non-Capturing Group(?:(\d\d)(\d\d)\/){0,1}

{0,1}repeats the group contents below at most once:

Group 2(\d\d)

\da digit

Group 3(\d\d)

\da digit

\/the literal / (47₁₀ / 57₈ / 2F₁₆)

Group 4([a-z,A-Z,0-9, ,\-,',_,\.,\/ ,\*]*)

Character Class[a-z,A-Z,0-9, ,\-,',_,\.,\/ ,\*]*

*matches any number of characters from the set below:

a-zone character from a (97₁₀) to z (122₁₀) (case sensitive)

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

A-Zone character from A (65₁₀) to Z (90₁₀) (case sensitive)

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

0-9one character from 0 (48₁₀) to 9 (57₁₀)

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

the literal (32₁₀ / 40₈ / 20₁₆)

\-the literal - (45₁₀ / 55₈ / 2D₁₆)

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

'the literal ' (39₁₀ / 47₈ / 27₁₆)

_the literal _ (95₁₀ / 137₈ / 5F₁₆)

\.the literal . (46₁₀ / 56₈ / 2E₁₆)

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

\/the literal / (47₁₀ / 57₈ / 2F₁₆)

the literal (32₁₀ / 40₈ / 20₁₆)

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

\*the literal * (42₁₀ / 52₈ / 2A₁₆)

Positive Lookbehind(?<= )

the literal (32₁₀ / 40₈ / 20₁₆)

Non-Capturing Group(?:(?:(\-|\+)(\d*,\d\d)){0,1}|(.*))

1st Alternative(?:(\-|\+)(\d*,\d\d)){0,1}

Non-Capturing Group(?:(\-|\+)(\d*,\d\d)){0,1}

{0,1}repeats the group contents below at most once:

Group 5(\-|\+)

1st Alternative\-

\-the literal - (45₁₀ / 55₈ / 2D₁₆)

2nd Alternative\+

\+the literal + (43₁₀ / 53₈ / 2B₁₆)

Group 6(\d*,\d\d)

\d*a digit, repeated any number of times

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

\da digit

2nd Alternative(.*)

Group 7(.*)

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

the literal ↵ (10₁₀ / 12₈ / A₁₆)

Global pattern flags

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

Search reference

Regular Expression

([A-Z,0-9, ]*\d ){0,1}(?:(\d\d)(\d\d)\/){0,1}([a-z,A-Z,0-9, ,\-,',_,\.,\/ ,\*]*)(?<= )(?:(?:(\-|\+)(\d*,\d\d)){0,1}|(.*))

New

CARTE X1796 1209/FREE MOBILE 75 PARIS
CARTE 51002  ITUNES.COM/BILL LUXEMBURG
CARTE X1796 0209/SNCF INTERNET 75 PARIS CEDEX 09
CARTE X1796 1408/THE COLUMBIA STO 124 -156,76
CARTE X1796 1208/NICKLAUS NORTH G 124 -168,41
CARTE 51002  PAYPAL*DIGITALRIVE DRI* 35314369001
CARTE 51002  APPLE ONLINE EURO HOLLYHILL
PAYPAL*PAYPAL*PHIBUELEC 4029357733
PAYPAL*OSCARO COM 35314369001

Substitution

Nom rationnalisé: $4 $7\rMoyen de paiement: $1\rDate opération :$2/$3\r\r