regex101: PCRE (Legacy) Substitution Workspace

Explanation

Pro

Non-Capturing Group(?:(((?:[AB](?=0[2-9]|1[0-5]))))[0-9]{2}(?:(?=,\s*\2),|))*

*repeats the group contents below any number of times:

Group 1(((?:[AB](?=0[2-9]|1[0-5]))))

Group 2((?:[AB](?=0[2-9]|1[0-5])))

Non-Capturing Group(?:[AB](?=0[2-9]|1[0-5]))

Character Class[AB]

Athe literal A (65₁₀ / 101₈ / 41₁₆) (case insensitive)

Bthe literal B (66₁₀ / 102₈ / 42₁₆) (case insensitive)

Positive Lookahead(?=0[2-9]|1[0-5])

1st Alternative0[2-9]

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

Character Class[2-9]

2-9one character from 2 (50₁₀) to 9 (57₁₀)

2nd Alternative1[0-5]

1the literal 1 (49₁₀ / 61₈ / 31₁₆)

Character Class[0-5]

0-5one character from 0 (48₁₀) to 5 (53₁₀)

Character Class[0-9]{2}

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

0-9one character from 0 (48₁₀) to 9 (57₁₀)

Non-Capturing Group(?:(?=,\s*\2),|)

1st Alternative(?=,\s*\2),

Positive Lookahead(?=,\s*\2)

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

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

\2the text saved by group 2

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

2nd Alternative — matches an empty string

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

i modifier: insensitive. Matches without distinguishing uppercase and lowercase letters

x modifier: extended. Ignores unescaped whitespace and comments outside character classes

Quick Reference

25 tokens

Regular Expression

(?:(((?:[AB](?=0[2-9]|1[0-5]))))[0-9]{2}(?:(?=,\s*\2),|))*

I have a line XX,VV,A01,A02,A03,A11,A12,A13,A14,B11,B12,B13,ZZ,DD

I need a regular expression for

If I find A01,A02,A03 or A11,A12,A13,A14 in my line, I have to replace with "AA"
If I find B11,B12,B13 I have to replace with "BB"
I have tried using

if (Regex.IsMatch(Value, "^A0[2-9]")|| Regex.IsMatch(Value, "^A1[0-5]"))
It didnt work -- so basically if i have A02,A03, A04, A05, A06, A07 or A10,A11,A12....... A15 , I have to replace with "AA"

Extraction

I have a line XX,VV,A01,A02,A03,A11,A12,A13,A14,B11,B12,B13,ZZ,DD

I need a regular expression for

If I find A01,A02,A03 or A11,A12,A13,A14 in my line, I have to replace with "AA"
If I find B11,B12,B13 I have to replace with "BB"
I have tried using

if (Regex.IsMatch(Value, "^A0[2-9]")|| Regex.IsMatch(Value, "^A1[0-5]"))
It didnt work -- so basically if i have A02,A03, A04, A05, A06, A07 or A10,A11,A12....... A15 , I have to replace with "AA"