Page 1 of 1

Convertion in a string

Posted: Mon Aug 03, 2009 8:04 am
by new_ds_man
Hi All,

I have a requirement to convert all the special characters in a I/P string.
Any occurance of "#" OR "+" OR "-" in the input string needs to be converted to " " (space).

Example string: ABCD###EF++++GHIJKL--------MNO

Needed output: ABCD EF GHIJKL MNO

Help Appreciated,

Thanks in Advance.

Posted: Mon Aug 03, 2009 8:10 am
by ArndW
The function would be

Code: Select all

Convert('#+-','   ',In.StringColumn)

Posted: Mon Aug 03, 2009 8:47 am
by new_ds_man
Thanks ArndW, That works!!!