Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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.
Perhaps you can replace ", with "; and the split on ; instead of ,
subfield( replace(txt, '",','";'),';')
Not sure what exactly you need,
Try SubField(Business Area,',',1) to split by delimiter
Try Replace(Business Area,',','') to remove comma
Regards,
Prabhu
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.
Well gysbert, that won't change much - then I'll have the same problem with ';'
You may try below,
Business Area='Uthyrning'&Chr(44)&' 10'