topic Re: Split String in expression in QlikView

Split String in expression

Wed, 15 Aug 2012 19:31:13 GMT

Hello everyone.

I have string as under

=subfield('asc@asd@gdds@fdfr@mnd','@')

Resulting strings

asc

asd

gdds

fdfr

mnd

I would like to split string in expression. The length of the string could very with '@' as separator. I want to dynamically split this string based on '@'

Thank you in advance.

Re: Split String in expression

MayilVahanan — Wed, 15 Aug 2012 19:40:56 GMT

Try purgeChar('asc@asd@gdds@fdfr@mnd','@') gives 'ascasdgddsfdfrmnd'

Re: Split String in expression

Wed, 15 Aug 2012 20:11:20 GMT

Thanks,

I do not just want to take out @, it is split of a string and one row gets converted in to multiple rows.,

Just a wage example. If i put that expression in list box, it will give me 5 items to select.

Any idea please?

Re: Split String in expression

sivarajs — Thu, 16 Aug 2012 05:20:30 GMT

I guess you have already done. Lets try this in your script

subfield(Filedname,'@') as new_field

Re: Split String in expression

Thu, 16 Aug 2012 13:03:12 GMT

Thanks,

It works in script,

I wanted in expression on the fly. Is there way to achive it?

Thanks..

Re: Split String in expression

sivarajs — Fri, 17 Aug 2012 05:43:11 GMT

Can you explain how should your output looks like?

Re: Split String in expression

Anonymous — Fri, 17 Aug 2012 12:03:04 GMT

Not sure what could be the use of it, but it is possible to present it this way using ValueList().
Create a straight table with calculated dimension:
ValueList(1,2,3,4,5)
Expression is:
subfield('asc@asd@gdds@fdfr@mnd','@',ValueList(1,2,3,4,5))

Regards,
Michael