Regular Expressions 101

\ba Unicode word boundary

Group 1([A-Z]+)

Character Class[A-Z]+

+matches at least one character from the set below:

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

0the literal 0 (48₁₀ / 60₈ / 30₁₆)

Positive Lookahead(?=[1-9]\d{2}\b)

Character Class[1-9]

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

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

\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

Detailed match information will be displayed here automatically.

Search reference

Regular Expression

\b([A-Z]+)0(?=[1-9]\d{2}\b)

New

SK0498 should return SK498 (total digits = 4 = omit the single leading zero)

AA007 should still return AA007 (because the leading zeros are double, and total digits is only 3)

UA2138 returns UA2138 (no leading zeros involved)

BA023 should return BA023 (keep the zero because total number of digits is only 3), however BA0234 should return BA234 (total digits is 4 with a single leading zero that should be omitted).

Substitution

$1