Replace non alpha and numberic characters with space

[ImranBhatti]

Hi

Sorry if that is available on the web but I could not find.All the available functions are actually removing the non alpha and numeric characters from the string but I need to replace them with a space i.e

what available functions are doing
INPUT = "ABC.*/DF.123_/\ Y"
OUTPUT= "ABCDFY"


what I need:
INPUT = "ABC.*/DF.123_/\ Y"
OUTPUT= "ABC DF Y"

means also single spacing them.

Help would be greatly appreciated.

Best Regards
Imran Bhatti

[jindon]

Please Login or Register  to view this content.

[ImranBhatti]

That did the job jindon.
Thanks a lot for the quick and perfect solution.