topic Re: string parse in QlikView

string parse

Fri, 27 Jun 2014 09:06:11 GMT

Hi,

How can I replace un unwanted comma in a string?

Applied rules:%BusinessUnitKey="Life Science", Business Area="Uthyrning, 10", RegionCode="40", RegionCode="30"

Need to loose the comma in "Uthyrning, 10", and only that, so I can flatten the table with SubString(txt,',') as txt

regards

thomas

Gysbert_Wassenaar — Fri, 27 Jun 2014 09:11:29 GMT

Perhaps you can replace ", with "; and the split on ; instead of ,

subfield( replace(txt, '",','";'),';')

Fri, 27 Jun 2014 09:13:46 GMT

Not sure what exactly you need,

Try SubField(Business Area,',',1) to split by delimiter

Try Replace(Business Area,',','') to remove comma

Regards,

Prabhu

tresB — Fri, 27 Jun 2014 09:14:58 GMT

I guess you meant SubField(), if so see if this works:

SubField( YourField, '",') // separator is ", (double quates followed by a comma)

And if you want to remove the commas after it gets separated, you can use PurgeChar() on it.

Fri, 27 Jun 2014 09:16:03 GMT

Well gysbert, that won't change much - then I'll have the same problem with ';'

Anonymous — Fri, 27 Jun 2014 09:22:19 GMT

You may try below,

Business Area='Uthyrning'&Chr(44)&' 10'