topic Re: Separate email domain and extension in QlikView

Separate email domain and extension

Fri, 12 Jul 2013 10:24:57 GMT

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

Re: Separate email domain and extension

sivarajs — Fri, 12 Jul 2013 10:51:59 GMT

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

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

Re: Separate email domain and extension

Fri, 12 Jul 2013 11:01:19 GMT

An other way to get the email domain is:

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

Re: Separate email domain and extension

Fri, 12 Jul 2013 11:03:25 GMT

Thanks to you both for the help!