Regular Expressions 101

"the literal " (34₁₀ / 42₈ / 22₁₆)

Group 1(\s+)?

?repeats the group contents below at most once:

\s+any whitespace character, repeated at least once

Group 2([a-z\s]+?)

Character Class[a-z\s]+?

+?matches at least one character from the set below:

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

\sany whitespace character

Group 3(\s+)?

?repeats the group contents below at most once:

\s+any whitespace character, repeated at least once

"the literal " (34₁₀ / 42₈ / 22₁₆)

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

"(\s+)?([a-z\s]+?)(\s+)?"

New

"name","john","name of john"
"name","       john","name of john"
"       name  ","       john","name of john     "
"       name  ","       john","       name of john     "

Substitution

$2