topic Re: Reg: REPLACE statement in Application Development and Automation Discussions

Reg: REPLACE statement

Former Member — Tue, 09 Jun 2009 13:27:06 GMT

Hi all,

I am using the below shown statement:

lv_data = ' "YellLive","Acc1st,"January",2009,"Account","Summary_",sch'.

REPLACE ALL OCCURRENCES OF '","' in lv_data with ','.

REPLACE ALL OCCURRENCES OF '",' in lv_data with ','.

REPLACE ALL OCCURRENCES OF ',"' in lv_data with ','.

Basically i want to remove the (") from the variable LV_DATA

Above statements are working fine in ECC 6.0, but not in 4.6C (as, 'ALL OCCURRENCES OF' is not allowed here).

I have to use the same logic in 4.6C

Can someone suggest some solution, but even i dont want to Iterate the Variable LV_DATA and SEARCH, as it will cause Performance problem (as this logic is to be used on the bulk of data in loop).

Thanks and regards,

Pankaj.

Re: Reg: REPLACE statement

Former Member — Tue, 09 Jun 2009 13:34:45 GMT

Hi,

Try with Translate lv_data using '" '.

Regards,

Suresh.

Re: Reg: REPLACE statement

Former Member — Tue, 09 Jun 2009 13:35:57 GMT

use a FM SSM_REPLACE_CHAR_BY_SPACE

Function module              SSM_REPLACE_CHAR_BY_SPACE
 Import parameters               Value
  INPUT_STRING                    "YELLLIVE","ACC1ST,"JANUARY",2009,"ACCOUNT","SUMMARY_",SCH'
  CHAR                            "

  Export parameters               Value
  OUTPUT_STRING                    YELLLIVE , ACC1ST, JANUARY ,2009, ACCOUNT , SUMMARY_ ,SCH'

Re: Reg: REPLACE statement

andreas_mann3 — Tue, 09 Jun 2009 13:37:26 GMT

you must program a loop for yout data in 4.6C, because addition "ALL OCCURRENCES "

doesn't exist.

or copy and modify a fm like PREPARE_STRING

Re: Reg: REPLACE statement

Former Member — Tue, 09 Jun 2009 13:54:09 GMT

Yes, I can use TRANSLATE stm. or the mentioned FM 'SSM_REPLACE_CHAR_BY_SPACE', but I want to remove the spaces also (i want to remove " with blank value and not with SPACE) and that too without using SPLIT statement.

Is there any possible solution?

Thanks and in advance.

Pankaj.