topic Re: replacing ',' with space in Application Development and Automation Discussions

replacing ',' with space

former_member575017 — Wed, 05 Nov 2008 09:17:09 GMT

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

Re: replacing ',' with space

Former Member — Wed, 05 Nov 2008 09:20:02 GMT

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.

Re: replacing ',' with space

JozsefSzikszai — Wed, 05 Nov 2008 09:20:57 GMT

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

Re: replacing ',' with space

Former Member — Wed, 05 Nov 2008 09:21:08 GMT

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

Re: replacing ',' with space

Former Member — Wed, 05 Nov 2008 09:37:19 GMT


> 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

Re: replacing ',' with space

Former Member — Wed, 05 Nov 2008 10:52:44 GMT

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.

Re: replacing ',' with space

former_member575017 — Wed, 05 Nov 2008 11:18:10 GMT

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

Re: replacing ',' with space

Former Member — Wed, 05 Nov 2008 11:23:23 GMT

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.

Re: replacing ',' with space

Former Member — Wed, 05 Nov 2008 11:30:58 GMT

close the thread as answered if you got the solution.

Regards

Karthik D