Extract domain from email address using regex

Follow

Jacob Cluff

• September 25, 2015 23:16

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

0

• Official comment

  

  Joel Stewart

  • September 25, 2015 23:45

  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.

  Comment actions Permalink

Please sign in to leave a comment.