regex101: Full Name (Advanced)

^start of line

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

Non-Capturing Group(?:[a-z]{2,}\.\s*)?

?repeats the group contents below at most once:

Character Class[a-z]{2,}

{2,}matches at least 2 characters from the set below:

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

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

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

Non-Capturing Group(?:[a-zñ]{2,}\s*[a-zñ ]*,\s*[a-zñ]+\s*[a-zñ ]*(?:[a-zñ]\.?\s*){0,3}|[a-zñ]+\s*[a-zñ ]*\s+(?:[a-zñ]\.?\s*){0,3}[a-zñ]{2,}\s*[a-zñ ]*)

1st Alternative[a-zñ]{2,}\s*[a-zñ ]*,\s*[a-zñ]+\s*[a-zñ ]*(?:[a-zñ]\.?\s*){0,3}

Character Class[a-zñ]{2,}

{2,}matches at least 2 characters from the set below:

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

ñthe literal ñ (241₁₀ / 361₈ / F1₁₆) (case insensitive)

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

Character Class[a-zñ ]*

*matches any number of characters from the set below:

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

ñthe literal ñ (241₁₀ / 361₈ / F1₁₆) (case insensitive)

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

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

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

Character Class[a-zñ]+

+matches at least one character from the set below:

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

ñthe literal ñ (241₁₀ / 361₈ / F1₁₆) (case insensitive)

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

Character Class[a-zñ ]*

*matches any number of characters from the set below:

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

ñthe literal ñ (241₁₀ / 361₈ / F1₁₆) (case insensitive)

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

Non-Capturing Group(?:[a-zñ]\.?\s*){0,3}

{0,3}repeats the group contents below between 0 and 3 times:

Character Class[a-zñ]

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

ñthe literal ñ (241₁₀ / 361₈ / F1₁₆) (case insensitive)

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

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

2nd Alternative[a-zñ]+\s*[a-zñ ]*\s+(?:[a-zñ]\.?\s*){0,3}[a-zñ]{2,}\s*[a-zñ ]*

Character Class[a-zñ]+

+matches at least one character from the set below:

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

ñthe literal ñ (241₁₀ / 361₈ / F1₁₆) (case insensitive)

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

Character Class[a-zñ ]*

*matches any number of characters from the set below:

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

ñthe literal ñ (241₁₀ / 361₈ / F1₁₆) (case insensitive)

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

\s+any whitespace character, repeated at least once

Non-Capturing Group(?:[a-zñ]\.?\s*){0,3}

{0,3}repeats the group contents below between 0 and 3 times:

Character Class[a-zñ]

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

ñthe literal ñ (241₁₀ / 361₈ / F1₁₆) (case insensitive)

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

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

Character Class[a-zñ]{2,}

{2,}matches at least 2 characters from the set below:

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

ñthe literal ñ (241₁₀ / 361₈ / F1₁₆) (case insensitive)

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

Character Class[a-zñ ]*

*matches any number of characters from the set below:

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

ñthe literal ñ (241₁₀ / 361₈ / F1₁₆) (case insensitive)

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

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

Non-Capturing Group(?:[a-zñ., ])*

*repeats the group contents below any number of times:

Character Class[a-zñ., ]

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

ñthe literal ñ (241₁₀ / 361₈ / F1₁₆) (case insensitive)

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

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

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

$end of line

Global pattern flags

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

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

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

^\s*(?:[a-z]{2,}\.\s*)?(?:[a-zñ]{2,}\s*[a-zñ ]*,\s*[a-zñ]+\s*[a-zñ ]*(?:[a-zñ]\.?\s*){0,3}|[a-zñ]+\s*[a-zñ ]*\s+(?:[a-zñ]\.?\s*){0,3}[a-zñ]{2,}\s*[a-zñ ]*)\s*(?:[a-zñ., ])*$

Test String
New

1
Christopher Quimpo
Christopher P. Quimpo
Engr. Christopher P. Quimpo
Z G. Gono
Qu, C
Engr. Q, C
Christopher Quimpo
1
Christopher
1
Q C
1

Substitution
Processing...

col.Add "$1"

Regular Expression

Test StringNew

SubstitutionProcessing...

Test String
New

Substitution
Processing...