Separate email domain and extension

[#1]

Hi,

I'm interested in separating the email domain and extension. Any ideas on how this can be done in both set analysis (if possible) and on import into qv?

So for example, if I have a field value mattsies@gmail.com I want to create 2 fields: mattsies and gmail.

Any tips on how to do this would be greatly appreciated.

Best,

Matt

[sivarajs · Accepted solution]

SubField('mattsies@gmail.com','@',2) ---mattsies

subfield(SubField('mattsies@gmail.com','@',2),'.',1)--gmail

[#3]

An other way to get the email domain is:

=Left(Right(Email, Len(Email) - Index(Email, '@')), Index(Right(Email, Len(Email) - Index(Email, '@')), '.') - 1)

[#4]

Thanks to you both for the help!