regex101: Python Match Workspace

Pro

1st Alternative\b[A-Z ]*Q[A-Z ]*(?<![A-Z][A-Z]Q)\d+\.\d+

\ba Unicode word boundary

Character Class[A-Z ]*

*matches any number of characters from the set below:

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

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

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

Character Class[A-Z ]*

*matches any number of characters from the set below:

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

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

Negative Lookbehind(?<![A-Z][A-Z]Q)

Character Class[A-Z]

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

Character Class[A-Z]

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

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

\d+a Unicode decimal digit, repeated at least once

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

\d+a Unicode decimal digit, repeated at least once

2nd Alternative(\d+\.\d{2})(?!END)

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

\d+a Unicode decimal digit, repeated at least once

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

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

Negative Lookahead(?!END)

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

\b[A-Z ]*Q[A-Z ]*(?<![A-Z][A-Z]Q)\d+\.\d+|(\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