string parse

[#1]

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]

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

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

[#3]

Not sure what exactly you need,

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

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

Regards,

Prabhu

[tresesco · Accepted solution]

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.

[#5]

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

[Anonymous]

You may try below,

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