regex101: PCRE (Legacy) Substitution Workspace

Pro

(?-i)applies the following effective flags to the remainder of the pattern: g

i modifier: -insensitive. Case-sensitive match

Non-Capturing Group(?:^(?:Mc)?[A-Z]+(?:[ -][A-Z]+)*|\G(?!^)[A-Z][a-z]+(?:-[A-Z][a-z]+)*|\d{2}\.\d{2}\.\d{4})

1st Alternative^(?:Mc)?[A-Z]+(?:[ -][A-Z]+)*

^start of string

Non-Capturing Group(?:Mc)?

?repeats the group contents below at most once:

Mcthe literal text Mc (case sensitive)

Character Class[A-Z]+

+matches at least one character from the set below:

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

Non-Capturing Group(?:[ -][A-Z]+)*

*repeats the group contents below any number of times:

Character Class[ -]

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

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

Character Class[A-Z]+

+matches at least one character from the set below:

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

2nd Alternative\G(?!^)[A-Z][a-z]+(?:-[A-Z][a-z]+)*

\Gstart of current search

Negative Lookahead(?!^)

^start of string

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)

Non-Capturing Group(?:-[A-Z][a-z]+)*

*repeats the group contents below any number of times:

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

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)

3rd Alternative\d{2}\.\d{2}\.\d{4}

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

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

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

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

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

\Kresets the starting point of the reported match. Any previously consumed characters are no longer included in the final match

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

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

\h*any horizontal whitespace character, repeated any number of times

Global pattern flags

g modifier: global. Finds all matches instead of stopping after the first

25 tokens

Regular Expression

(?-i)(?:^(?:Mc)?[A-Z]+(?:[ -][A-Z]+)*|\G(?!^)[A-Z][a-z]+(?:-[A-Z][a-z]+)*|\d{2}\.\d{2}\.\d{4})\K -?\h*

New

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

Substitution

¬

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