topic Re: Problem with REPLACE ALL OCCURANCES OF in Application Development and Automation Discussions

Problem with REPLACE ALL OCCURANCES OF

Former Member — Tue, 27 Sep 2011 01:39:49 GMT

Hi All,

I wanted to replace '#' in my string.

So I have written "REPLACE ALL OCCURRENCES OF '#' IN

c_data WITH ' ".

For some of the records, # is getting replaced but for some of the records # is not getting replaced.

Could you please help me on this.

Edited by: 001krishna on Sep 27, 2011 3:40 AM

Re: Problem with REPLACE ALL OCCURANCES OF

former_member585060 — Tue, 27 Sep 2011 03:04:46 GMT

Hi,

Try with TRANSLATE statement. Just click on F1 on the translate statement.

TRANSLATE c_data USING '#'''.  " are you replacing # with single quote(')?

Thanks & Regards

Bala Krishna

Re: Problem with REPLACE ALL OCCURANCES OF

former_member907073 — Tue, 27 Sep 2011 04:26:05 GMT

Hi,

Try Using REPLACE ALL OCCURRENCES OF REGEX '#*' IN c_data WITH '' '

REPLACE ALL OCCURRENCES OF Substring '#*' IN c_data WITH '' '.

This shud help.

Regds,

Edited by: abheesawant on Sep 27, 2011 6:26 AM

Re: Problem with REPLACE ALL OCCURANCES OF

Clemenss — Tue, 27 Sep 2011 04:41:01 GMT

Hi krishna,

please note that SAP will show # for every character that can not be printed, i.e. control characters as tabs and line feeds are displayed as #.

Check in debugger, switch to hex display to see what you try to replace. You may replace CL_ABAP_CHAR_UTILITIES=>horizontal_tab or other attributes of CL_ABAP_CHAR_UTILITIES.

Regards

Clemens

Re: Problem with REPLACE ALL OCCURANCES OF

JackGraus — Tue, 27 Sep 2011 04:43:13 GMT

Hi Kishna, the REPLACE command will only replace 'real' characters with ASCII code '23'. Next to these 'real' charecters there might be some non diplayable characters in c_data whose ASCII code is not displayable. These will also be displyed as #. You can check it in the debugger by changing to hex mode. What is the ASCII code of the # characters that are not getting replaced ?

Regards Jack