Find and Replace in Impromtu

[ooch1]

I am trying to export a file to csv, but in one of the columns there are commas so it is throwing out all the columns.

Can some please let me know whether there is a funtion etc that will enable me to find and replace all these commas?
I have tried the lookup function but this only works for entire values???

OOch

 

[GJParker]

I'm using V7.3 and this has a Replace function

Syntax: replace (string_exp1, string_exp2, string_exp3)
Replaces all occurrences of string_exp2 in string_exp1 with string_exp3.

HTH

Gary Parker
MIS Data Analyst
Manchester, England