Regular Expressions 101

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

Non-Capturing Group(?: DE: (.*))

DE: the literal text DE: (case sensitive)

Group 1(.*)

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

Non-Capturing Group(?: ID: (.*)){0,1}

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

ID: the literal text ID: (case sensitive)

Group 2(.*)

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

Non-Capturing Group(?: MOTIF: (.*))

MOTIF: the literal text MOTIF: (case sensitive)

Group 3(.*)

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

Non-Capturing Group(?: REF: (.*)){0,1}

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

REF: the literal text REF: (case sensitive)

Group 4(.*)

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

Global pattern flags

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

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

Detailed match information will be displayed here automatically.

Search reference

Regular Expression

.*(?: DE: (.*))(?: ID: (.*)){0,1}(?: MOTIF: (.*))(?: REF: (.*)){0,1}

New

PRELEVEMENT EUROPEEN 2001427553 DE: MUTUELLE DE L'INDUSTRIE DU PETROLE ID: FR69MIP108863 MOTIF: Prelevement 42CXK 024 de MIP du 01/
VIR RECU    0485970259S DE: CPAM VAR MOTIF: 180930001235180930001235 REF: 18093000123

Substitution

Tiers:\t$1 \rid:\t$2 \rmotif:\t$3\r\r