Regex to pick the alias from email address

Question

I need to identify all email addresses in a given cell enclosed in any special character, written in any number of multiple lines.

This is something that I built.

"(!\s<,;-)[a-zA-Z0-9]*@"

Is there any improvement?

Answer 1

Use

([a-zA-Z0-9]\w*)@

See regex proof

EXPLANATION

--------------------------------------------------------------------------------
  (                        group and capture to \1:
--------------------------------------------------------------------------------
    [a-zA-Z0-9]              any character of: 'a' to 'z', 'A' to
                             'Z', '0' to '9'
--------------------------------------------------------------------------------
    \w*                      word characters (a-z, A-Z, 0-9, _) (0 or
                             more times (matching the most amount
                             possible))
--------------------------------------------------------------------------------
  )                        end of \1
--------------------------------------------------------------------------------
  @                        '@'

Answer 2

The pattern (!\s<,;-)[a-zA-Z0-9]*@ starts with capturing !\s<,;- literally. If you want to match 1 of the listed characters, you can use a character class [!\s<,;-] instead.

If you want to match xyz123 in [email protected] you can use:

[a-zA-Z0-9]+(?=@)

The pattern matches

• [a-zA-Z0-9]+ Match 1+ occurrences of any of the listed ranges
• (?=@) Assert (not match) an @ directly to the right of the current position

See a regex demo.