regex101: PCRE (Legacy) Match Workspace

Pro

Negative Lookbehind(?<![Q\d])

Character Class[Q\d]

Qthe literal Q (81₁₀ / 121₈ / 51₁₆) (case sensitive)

\da digit

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

M?optionally matches the literal M (77₁₀ / 115₈ / 4D₁₆) (case sensitive)

Group 1(\d+\.\d{2})

\d+a digit, repeated at least once

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

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

Positive Lookahead(?=.*\d+\.\d{2}END)

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

\d+a digit, repeated at least once

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

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

ENDthe literal text END (case sensitive)

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

(?<![Q\d]) ?M?(\d+\.\d{2})(?=.*\d+\.\d{2}END)

New

ABC WS YMQ234.03WS TOY234.03USD468.06END
FUR BB LAB Q10.00 199.00USD209.00END
YAS DG TYY Q AWSMSN11.32 2503.08LD VET Q JKLOLE11.32 2503.08USD5028.80END
PPP VP LAP Q10.00 M342.41EE SFD Q10.00 282.24USD644.65END

Substitution

ABC WS YMQ234.03WS TOY234.03USD468.06END
FUR BB LAB Q10.00 199.00USD209.00END
YAS DG TYY Q AWSMSN11.32 2503.08LD VET Q JKLOLE11.32 2503.08USD5028.80END
PPP VP LAP Q10.00 M342.41EE SFD Q10.00 282.24USD644.65END