topic Re: Code for replace in Application Development and Automation Discussions

Code for replace

Former Member — Fri, 11 May 2007 18:31:41 GMT

Hi ,

I am trying to replace a character of the field from the itab.

itab-f1 = 'HOPT & SCHULER GMBH & CO KG'.

My code is like this:

loop at itab.

tmp = itab-f1.

IF lf_tmp CS '&'.

REPLACE '&' WITH '&' INTO lf_tmp.

ENDIF.

itab-f1 = tmp.

endloop.

I am able to change only the first '&' by doing this.

HOPT & SCHULER GMBH & CO K

How can I do both the '&'?

anyone help me out ASAP

Re: Code for replace

ferry_lianto — Fri, 11 May 2007 18:32:32 GMT

Hi,

Please use TRANSLATE statement.

Regards,

Ferry Lianto

Re: Code for replace

Former Member — Fri, 11 May 2007 18:34:06 GMT

Hi ramana,

Do you have the

REPLACE all occurances of '&' in v_str into v_target.

Regards

Ravi

Re: Code for replace

Former Member — Fri, 11 May 2007 19:05:37 GMT

I get error ...unable to interpret occurances

And can you give me the syntax..for translate in my case

Re: Code for replace

ferry_lianto — Fri, 11 May 2007 19:08:21 GMT

Hi,

Let's say you want to replace '&' with '1'.


loop at itab.
  tmp = itab-f1.

  TRANSLATE tmp using '&1'.

  itab-f1 = tmp.
endloop.

Regards,

Ferry Lianto

Re: Code for replace

Former Member — Fri, 11 May 2007 19:21:28 GMT

Hi Ramana,

Try using the following code.

LOOP AT itab.

  REPLACE ALL OCCURRENCES OF '&' IN itab-f1 WITH '<text string>'.

  MODIFY itab TRANSPORTING f1.

ENDLOOP.

where <text string> = String that should replace &

Let me know if this helps.

Re: Code for replace

Former Member — Fri, 11 May 2007 19:23:22 GMT

it was a spelling mistake..

its occurences and not occurances.

Regards,

Ravi

Re: Code for replace

Former Member — Fri, 11 May 2007 20:14:14 GMT

I tried all these spellings in 4.6c

OCCURRENCES

OCCURENCES

OCCURANCES

all show an error

Re: Code for replace

Former Member — Fri, 11 May 2007 20:17:32 GMT

Hi,

replace all occurences addition is not available in 4.6c..

You have to use TRANSLATE as mentioned by Ferry.

Thanks,

Naren

Re: Code for replace

suresh_datti — Fri, 11 May 2007 20:19:22 GMT

that option for REPLACE probably doesn't exist in 46c.. I use it on my 47..

~Suresh

Re: Code for replace

Former Member — Fri, 11 May 2007 20:20:06 GMT

TRANSLATE tmp using '&1'.

this also didnot work for me.

I guess this is because ...I have given it like this..

translate lf_tmp using '&&'.

I am translating & with '&'

Message was edited by:

ramana peddu

Re: Code for replace

Former Member — Fri, 11 May 2007 20:22:08 GMT

Hi,

It is working...

Check this sample code with your string..

DATA: v_string TYPE string.

v_string = 'HOPT & SCHULER GMBH & CO KG'.

TRANSLATE v_string USING '&1'.

Thanks,

Naren

WRITE: / v_string.

Re: Code for replace

Former Member — Fri, 11 May 2007 20:23:33 GMT

Hi,

Do you want to replace & with '&'

Before replacing

HOPT & SCHULER GMBH & CO KG

After replacing

HOPT '&' SCHULER GMBH '&' CO KG

Do you want this..

Thanks,

Naren

Re: Code for replace

Former Member — Fri, 11 May 2007 20:28:22 GMT

Hi,

Okay..You can use the Function module WRB_UTIL_STRING_REPLACE

Try this code

DATA: v_string TYPE string.

v_string = 'HOPT & SCHULER GMBH & CO KG'.

CALL FUNCTION 'WRB_UTIL_STRING_REPLACE'

EXPORTING

pi_search_string = '&'

pi_replace_string = '''&'''

CHANGING

pc_string = v_string

EXCEPTIONS

search_string_too_long = 1

missing_search_string = 2

OTHERS = 3.

IF sy-subrc = 0.

WRITE: / v_string.

ENDIF.

Thanks,

Naren

Re: Code for replace

Former Member — Fri, 11 May 2007 20:47:55 GMT

I did it like this ...

CALL FUNCTION 'WRB_UTIL_STRING_REPLACE'

EXPORTING

pi_search_string = '&'

pi_replace_string = 'amp;'

changing

pc_string = lf_tmp

EXCEPTIONS

SEARCH_STRING_TOO_LONG = 1

MISSING_SEARCH_STRING = 2

OTHERS = 3

IF sy-subrc <> 0.

MESSAGE ID SY-MSGID TYPE SY-MSGTY NUMBER SY-MSGNO
WITH SY-MSGV1 SY-MSGV2 SY-MSGV3 SY-MSGV4.

ENDIF.

It went into a dump.

Thank you Naren I got it

Message was edited by:

ramana peddu

Re: Code for replace

Former Member — Fri, 11 May 2007 20:52:37 GMT

Hi,

The data type should be string..For all the parameters..ALso you should give '''&''' in the replace string parameter...Instead of '&'

Try this..



DATA: V_STRING TYPE STRING.
V_STRING = IF_TMP.
CALL FUNCTION 'WRB_UTIL_STRING_REPLACE'
EXPORTING
pi_search_string = '&'
pi_replace_string = '''&'''
changing
pc_string = v_string
EXCEPTIONS
SEARCH_STRING_TOO_LONG = 1
MISSING_SEARCH_STRING = 2
OTHERS = 3.

if_tmp = string.

Thanks,

Naren

Re: Code for replace

Former Member — Fri, 11 May 2007 21:06:55 GMT

Hi,

Please make sure to reward points for helpful answers...

Thanks,

Naren

Re: Code for replace

ferry_lianto — Sat, 12 May 2007 14:51:03 GMT

Hi,

Please try this.


data: v_str1(1) type c value '&',
      v_str2(3) type c value '''&''',
      v_len type i.

loop at itab.
   lf_tmp = itab-f1.

   if lf_tmp cs v_str1.
     v_len = strlen( lf_tmp ).

     do v_len times. 
       replace v_str1 with v_str2 into lf_tmp.
     enddo   

   endif.

   itab-f1 = lf_tmp.
  modify itab.
endloop.

Regards,

Ferry Lianto

Re: Code for replace

Former Member — Mon, 14 May 2007 11:19:10 GMT

Sorry Naren , I forgot to reward points ...see I have done it