Extract domain from email address using regex

2 followers
0
Avatar

What's the correct syntax for pulling out the domain from an email address?

Jacob Cluff

Official comment

  • Avatar
    Joel Stewart

    Here's one way to extract the email from a column titled "Email":
    SUBSTR(#Email;INDEX(#Email;"@")+1)

    In summary, it looks for the "@" character and then takes all the characters in the string after that.

    0

1 comment

Please sign in to leave a comment.