regex101: PCRE (Legacy) Substitution Workspace

Pro

Group 1(([A-Z]+[ -]){1,})

Group 2([A-Z]+[ -]){1,}

{1,}repeats the group contents below at least once:

Character Class[A-Z]+

+matches at least one character from the set below:

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

Character Class[ -]

the literal (32₁₀ / 40₈ / 20₁₆)

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

Group 3(([A-Z][a-z]+[ \-]){1,})

Group 4([A-Z][a-z]+[ \-]){1,}

{1,}repeats the group contents below at least once:

Character Class[A-Z]

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

Character Class[a-z]+

+matches at least one character from the set below:

a-zone character from a (97₁₀) to z (122₁₀) (case sensitive)

Character Class[ \-]

the literal (32₁₀ / 40₈ / 20₁₆)

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

the literal (32₁₀ / 40₈ / 20₁₆)

Group 5([0-9]{2}.[0-9]{2}.[0-9]{4})

Character Class[0-9]{2}

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

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

.any character (except for line terminators)

Character Class[0-9]{2}

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

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

.any character (except for line terminators)

Character Class[0-9]{4}

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

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

- the literal text -

Group 6([A|B|C])

Character Class[A|B|C]

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

|the literal | (124₁₀ / 174₈ / 7C₁₆)

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

Cthe literal C (67₁₀ / 103₈ / 43₁₆) (case sensitive)

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

(([A-Z]+[ -]){1,})(([A-Z][a-z]+[ \-]){1,})\- ([0-9]{2}.[0-9]{2}.[0-9]{4}) - ([A|B|C])

New

ABBEY Chantelle - 08.11.1995 - A
ANAND Toni-Grace - 04.09.1999 - A
ADCOCK ALVEY James - 12.04.1992 - C
ADLINGTON-JONES Robin Jacob Sebastian - 15.02.1999 - B
AFZAL Kiera - 25.04.2000 - B
AHMED Nisar Abu Ben Adhem - 16.08.2002 - C
AIRE-DEANE Christopher-James - 06.01.1997 - B
AL-MISRI Yaqoob - 23.07.2004 - C
ASTER Lily-May - 01.04.2010 - B
McQUEEN Stephen - 02.02.2001 - A

Extraction

ABBEY Chantelle - 08.11.1995 - A
ANAND Toni-Grace - 04.09.1999 - A
ADCOCK ALVEY James - 12.04.1992 - C
ADLINGTON-JONES Robin Jacob Sebastian - 15.02.1999 - B
AFZAL Kiera - 25.04.2000 - B
AHMED Nisar Abu Ben Adhem - 16.08.2002 - C
AIRE-DEANE Christopher-James - 06.01.1997 - B
AL-MISRI Yaqoob - 23.07.2004 - C
ASTER Lily-May - 01.04.2010 - B
McQUEEN Stephen - 02.02.2001 - A