Regular Expressions 101

^start of line

Group 1([^,@\n]+)

Negated Character Class[^,@\n]+

+matches at least one character outside the set below:

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

@the literal @ (64₁₀ / 100₈ / 40₁₆)

\na line-feed (newline) character (ASCII 10)

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

Group 2(.+)

.+any character (except for line terminators), repeated at least once

\R?optionally matches a newline sequence

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

^([^,@\n]+),(.+)\R?

New

John Smith,johnsmith1@gmail.com,johnsmith2@gmail.com,johnsmith3@gmail.com
Taylor Smith,taylorsmith@gmail.com
Jack Smith,jacksmith1@gmail.com,jacksmith@gmail.com

Regular Expression

Extraction