replacing ',' with space

[former_member575017]

Hi Experts,

I need to replace ',' with space in one field.

I am using following syntax but its not working help me

REPLACE ALL OCCURRENCES OF ',' IN itab-xyz WITH ' '.

REPLACE ALL OCCURRENCES OF ',' IN itab-xyz WITH SPACE.

Both are not working, so need ur help.

Thanks

Basu

[Former Member]

Hope you loop the itab to make this change .

Loop itab.

REPLACE ALL OCCURRENCES OF ',' IN itab-xyz WITH ' '.

---> You need to use modify itab to make the change permanent

endloop.

[JozsefSzikszai]

try using TRANSLATE:

TRANSLATE itab-xyz USING ', '. "pls. not there is a space after the coma

also check if itab-xyz has any value when the statement is reached

[Former Member]

data: output type string.

create an itab of type text.

split <string> at ',' into table <itab>.

loop at itab.

concatenate output <itab-field> into output separated by space.

endloop.

- Hemant

[Former Member]

>

> REPLACE ALL OCCURRENCES OF ',' IN itab-xyz  WITH ' '.
> REPLACE ALL OCCURRENCES OF ',' IN itab-xyz  WITH SPACE.
> 

You have to use IN TABLE itab instead of IN itab-xyz.

REPLACE ALL OCCURRENCES OF ',' IN TABLE itab WITH SPACE.

Regards

Karthik D

Edited by: Karthik D on Nov 5, 2008 3:07 PM

[Former Member]

Hi,

I have recently worked with the same syntax. It is working fine for me. Please check this out.

LOOP AT t_itab ASSIGNING <fs_t_itab>.

CHECK <fs_t_itab> IS ASSIGNED.

REPLACE ALL OCCURRENCES OF ',' IN <fs_t_itab>-fieldname WITH ''.

ENDLOOP.

[former_member575017]

Thanks all for your efforts.

I am using below code its working fine

while itab-xyz cs ','.

replace ',' with ' ' into itab-xyz.

endwhile.

Thanks

Basu

[Former Member]

close the thread as answered if you got the solution.

Regards

Karthik D

[Former Member]

Hello,

As far as my knowledge is concern, i don't think that the code has any nagation..

REPLACE ALL OCCURRENCES OF ',' IN itab-xyz WITH ' '.

REPLACE ALL OCCURRENCES OF ',' IN itab-xyz WITH SPACE.