regex101: Python Substitution Workspace

Non-Capturing Group(?:^ *-? +)?

?repeats the group contents below at most once:

^start of line

*the literal (32₁₀ / 40₈ / 20₁₆) , repeated any number of times

-?optionally matches the literal - (45₁₀ / 55₈ / 2D₁₆)

+the literal (32₁₀ / 40₈ / 20₁₆) , repeated at least once

Group 1((\d+ +cases?)|(Product\w+)|(\d{4})|(\$[\d,.]+)|(Warehouse +\w+)|(-[^-\n]+(?:-|$)))

1st Alternative(\d+ +cases?)

Group 2(\d+ +cases?)

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

+the literal (32₁₀ / 40₈ / 20₁₆) , repeated at least once

casethe literal text case (case sensitive)

s?optionally matches the literal s (115₁₀ / 163₈ / 73₁₆) (case sensitive)

2nd Alternative(Product\w+)

Group 3(Product\w+)

Productthe literal text Product (case sensitive)

\w+a Unicode word character, repeated at least once

3rd Alternative(\d{4})

Group 4(\d{4})

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

4th Alternative(\$[\d,.]+)

Group 5(\$[\d,.]+)

\$the literal $ (36₁₀ / 44₈ / 24₁₆)

Character Class[\d,.]+

+matches at least one character from the set below:

\da Unicode decimal digit

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

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

5th Alternative(Warehouse +\w+)

Group 6(Warehouse +\w+)

Warehousethe literal text Warehouse (case sensitive)

+the literal (32₁₀ / 40₈ / 20₁₆) , repeated at least once

\w+a Unicode word character, repeated at least once

6th Alternative(-[^-\n]+(?:-|$))

Group 7(-[^-\n]+(?:-|$))

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

Negated Character Class[^-\n]+

+matches at least one character outside the set below:

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

\na line-feed (newline) character (ASCII 10)

Non-Capturing Group(?:-|$)

1st Alternative-

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

2nd Alternative$

$end of line

Non-Capturing Group(?: +(?:of|at|in) +| +)?

?repeats the group contents below at most once:

1st Alternative +(?:of|at|in) +

+the literal (32₁₀ / 40₈ / 20₁₆) , repeated at least once

Non-Capturing Group(?:of|at|in)

1st Alternativeof

ofthe literal text of (case sensitive)

2nd Alternativeat

atthe literal text at (case sensitive)

3rd Alternativein

inthe literal text in (case sensitive)

+the literal (32₁₀ / 40₈ / 20₁₆) , repeated at least once

2nd Alternative +

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

(?:^ *-? +)?((\d+ +cases?)|(Product\w+)|(\d{4})|(\$[\d,.]+)|(Warehouse +\w+)|(-[^-\n]+(?:-|$)))(?: +(?:of|at|in) +| +)?

New

    - 1 case of ProductA 2020 at $123,456.00 in Warehouse A
    - 2 cases of ProductB 2025 at $123,456.00 in Warehouse B - optional remark

Extraction

    - 1 case of ProductA 2020 at $123,456.00 in Warehouse A
    - 2 cases of ProductB 2025 at $123,456.00 in Warehouse B - optional remark