regex101: Python Match Workspace

Pro

Positive Lookahead(?=[^Q\d]*(?=\d))

Negated Character Class[^Q\d]*

*matches any number of characters outside the set below:

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

\da Unicode decimal digit

Positive Lookahead(?=\d)

\da Unicode decimal digit

Non-Capturing Group(?:(?<!Q)|(?<=[A-Z]{2}Q)|\D*\d+\.\d{2})

1st Alternative(?<!Q)

Negative Lookbehind(?<!Q)

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

2nd Alternative(?<=[A-Z]{2}Q)

Positive Lookbehind(?<=[A-Z]{2}Q)

Character Class[A-Z]{2}

{2}matches exactly 2 characters from the set below:

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

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

3rd Alternative\D*\d+\.\d{2}

\D*any character that is not a Unicode decimal digit, repeated any number of times

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

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

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

Negated Character Class[^Q\d]*

*matches any number of characters outside the set below:

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

\da Unicode decimal digit

Group 1([1-9]\d*\.\d{2})

Character Class[1-9]

1-9one character from 1 (49₁₀) to 9 (57₁₀)

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

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

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

Negative Lookahead(?!END\b)

ENDthe literal text END (case sensitive)

\ba Unicode word boundary

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]*(?=\d))(?:(?<!Q)|(?<=[A-Z]{2}Q)|\D*\d+\.\d{2})[^Q\d]*([1-9]\d*\.\d{2})(?!END\b)

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

Extraction

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