Convertion in a string

new_ds_man · Post by **new_ds_man** » Mon Aug 03, 2009 8:04 am

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.

ArndW · Post by **ArndW** » Mon Aug 03, 2009 8:10 am

The function would be

Code: Select all

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

new_ds_man · Post by **new_ds_man** » Mon Aug 03, 2009 8:47 am

Thanks ArndW, That works!!!