topic Re: How to Split column in QlikView

How to Split column

Wed, 26 Mar 2014 06:28:03 GMT

I have a column which stores the email info, can anyone suggest me how do i split into username, @, email address example...

abc@gmail.com, should be splitted as abc, @ , gmail.com into 3 different columns...

Wed, 26 Mar 2014 06:32:30 GMT

Use the SubField function

=Subfield('abc@gmail.com','@',1) gives you the first field 'abc'

=subfield('abc@gmail.com','@',2) gives you 'gmail.com'

tresB — Wed, 26 Mar 2014 06:32:36 GMT

Try something like:

Load

SubField(Address, '@' , 1) as Name,

SubField(Address, '@', 2) as MailProvider,

'@' as At

rbecher — Wed, 26 Mar 2014 06:33:10 GMT

Hi Savitha,

you can use subfield():

LOAD

subfield(email,'@',1) as user,

if(index(email,'@')>0, '@') as at,

subfield(email,'@',2) as domain

...

- Ralf

its_anandrjs — Wed, 26 Mar 2014 06:34:06 GMT

Use subfield function like

SubField('abc@gmail.com','@',1) as UserName

SubField('abc@gmail.com','@',2) as DName

'@' as Atrate

Hope this helps

Thanks & Regards

Wed, 26 Mar 2014 07:06:47 GMT

thanks but i need only the distinct values

rbecher — Wed, 26 Mar 2014 07:21:36 GMT

LOAD DISTINCT... ?