How to replace required char with space in the string

[Former Member]

I am using following way to replace all commas in the fieldname with space, but it is not working correctly.

fieldname = 'a,b,c'.

REPLACE ALL OCCURRENCES OF ',' IN fieldname WITH space.

fieldname becomes 'abc' after using above way.

anyone can suggest how to do it, thanks.

[Former Member]

Check this

data:
  fieldname(20) type c.

fieldname = 'a,b,c'.
TRANSLATE fieldname USING ', '.

write: fieldname.

[varma_narayana]

Hi Yong..

Try using this statement:

TRANSLATE fieldname USING ', '. "Comma and SPACE

It will search for all the Occurrences of ',' and Replace it with the SPACE.

<b>Reward if helpful.</b>

[Former Member]

Thanks guys, it is working pretty well.