regex101: PCRE2 (PHP) Match Workspace

^start of line

Group 1(\d+\s?\b(?:[A-Z]|[A-Z]*\d[A-Z\d]*)?\b)

\d+a digit, repeated at least once

\s?optionally matches any whitespace character

\ban ASCII word boundary

Non-Capturing Group(?:[A-Z]|[A-Z]*\d[A-Z\d]*)?

?repeats the group contents below at most once:

1st Alternative[A-Z]

Character Class[A-Z]

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

2nd Alternative[A-Z]*\d[A-Z\d]*

Character Class[A-Z]*

*matches any number of characters from the set below:

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

\da digit

Character Class[A-Z\d]*

*matches any number of characters from the set below:

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

\da digit

\ban ASCII word boundary

\s*any whitespace character, repeated any number of times

Group 2([A-Z ]*\b)

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₁₆)

\ban ASCII 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

Search reference

Regular Expression

^(\d+\s?\b(?:[A-Z]|[A-Z]*\d[A-Z\d]*)?\b)\s*([A-Z ]*\b)

New

589011 T CANNELLE FLAVOR 8
538160 TP0597C ORANGE FLAVOR
557137 APL0397C STRAWBERRY FLAVOR
556137 APL0397C STRAWBERRY FLAVOR
545129 1APL0397C MANGO FLAVOR
984320 TRANS DECENAL
533160 TP0597C ORANGE FLAVOR
530373 A PINEAPPLE FLAVOR
059311 A STRAWBERRY FLAVOR
508142 T LEMON FLAVOR
547261 A BLACKBERRY FLAVOR
536564 2T BLUEBERRY STRAWBERRY
055406 A MILK FLAVOR
054945 A BLACKBERRY FLAVOR
983347 SUSTANE
902040 ACETIC ACID
988320 TRANS DECENAL 1 KGM 12164500 JC4 20.0000 KILO 263.98/KG 5,279.60
903040 ACETIC ACID 1 KGM 12164500 DJ4 100.0000 KILO 3.17/KG 317.00