topic Re: Problem with REPLACE statement in Application Development and Automation Discussions

Problem with REPLACE statement

Former Member — Mon, 16 Mar 2009 08:41:17 GMT

Hi Friends,

I have a field (CHAR TYPE) value as 200,000,000.00000

I want to replace the ',' with '.'

I tried with REPLACE statement. But it replaces only the first occurrence.

How to do this?

The expected output is 200.000.000.00000

Regards,

Viji

Re: Problem with REPLACE statement

I355602 — Mon, 16 Mar 2009 08:43:11 GMT

Hi,

Try with REPLACE ALL OCCURRENCE

Hope this helps you.

Regards,

Tarun

Re: Problem with REPLACE statement

Former Member — Mon, 16 Mar 2009 08:43:40 GMT

try

replace ALL OCCURRENCES OF.....

Thanks

Re: Problem with REPLACE statement

former_member222860 — Mon, 16 Mar 2009 08:44:03 GMT

u tried with

REPLACE ALL OCCURRENCES OF

Re: Problem with REPLACE statement

dev_parbutteea — Mon, 16 Mar 2009 08:44:10 GMT

Hi,

Do as below:

DATA : v_char TYPE char30 VALUE '200,000,000.00000'.

REPLACE ALL OCCURRENCES OF ',' in v_char WITH '.'.

WRITE : v_char.

Regards.

Re: Problem with REPLACE statement

Former Member — Mon, 16 Mar 2009 08:44:39 GMT

I am working in 4.6C

Re: Problem with REPLACE statement

Former Member — Mon, 16 Mar 2009 08:45:13 GMT

Hi,

please check this code

data : wa type CEPC_BUKRS,
         itab type table of CEPC_BUKRS.
 
loop at itab into wa.
  case wa-bukrs.
    when 'PTUS' or 'HQUS' or 'CTCA'.
         replace all occurences of '-' in wa with '.'.
         modify itab from wa index sy-tabix.
  endcase.
endloop.

Thanks and regards

Durga.K

Re: Problem with REPLACE statement

Former Member — Mon, 16 Mar 2009 08:45:50 GMT

Hi,

Write 'REPLACE ALL OCCURENCE' statement

Regards,

Jyothi CH.

Re: Problem with REPLACE statement

Former Member — Mon, 16 Mar 2009 08:46:33 GMT

I am working in 4.6C

Re: Problem with REPLACE statement

Former Member — Mon, 16 Mar 2009 08:46:56 GMT

I am working in 4.6C

Re: Problem with REPLACE statement

Former Member — Mon, 16 Mar 2009 08:47:11 GMT

you can try this,

REPLACE ALL OCCURRENCES OF ',' IN field1 WITH '.'

Regards,

Joan

Re: Problem with REPLACE statement

Former Member — Mon, 16 Mar 2009 08:47:14 GMT

Have you tried the REPLACE .....ALL OCCURRENCES OF option?

Which SAP version are you using?

Another option you have is Overlay < var> with '.................' only ','.

Mathews.

Re: Problem with REPLACE statement

Former Member — Mon, 16 Mar 2009 09:04:01 GMT

Hi There,

data: lv_num(20) type c ,

lv_num1(10) type c,

lv_num2(10) type c,

lv_num3(10) type c.

if lv_num ca ','.

split lv_num at ',' into lv_num1 lv_num2 lv_num3.

concatenate lv_num1 lv_num2 lv_num3 into lv_num seperated by '.'.

Edited by: BrightSide on Mar 16, 2009 9:04 AM

Re: Problem with REPLACE statement

I355602 — Mon, 16 Mar 2009 09:08:04 GMT

Hi,

Use code, its working:


DATA : v_str(20) TYPE c VALUE '200,000,000,000.000'.

DATA : v_c_str(20) TYPE c.

DATA itab TYPE TABLE OF string WITH HEADER LINE.

START-OF-SELECTION.

  SPLIT v_str AT ',' INTO TABLE itab.

  LOOP AT itab.
    IF v_c_str IS INITIAL.
      v_c_str = itab.
    ELSE.
      CONCATENATE v_c_str '.' itab INTO v_c_str.
    ENDIF.
  ENDLOOP.

END-OF-SELECTION.

  WRITE : v_c_str.

Hope this helps you.

Regards,

Tarun

Re: Problem with REPLACE statement

Former Member — Mon, 16 Mar 2009 09:31:26 GMT

Hi,

data: num(20) type c value '200,000,000.00000',

num1(10) type c,

num2(10) type c,

num3(10) type c.

split num at ',' into num1 num2 num3.

concatenate num1 '.' num2 '.' num3 into num.

Hope this might help you out.

Pooja

Re: Problem with REPLACE statement

Former Member — Mon, 16 Mar 2009 09:48:56 GMT


> I am working in 4.6C

So isn't replace all occurances of statement available to you?

then u can try like this

do.

use ur replace statement here then check sy subrc.

if sy-subrc ne 0.

exit.

endif.

enddo.

кu03B1ятu03B9к

Re: Problem with REPLACE statement

Former Member — Mon, 16 Mar 2009 10:09:58 GMT

hey

Defenitely working.

DATA lv_char(20) TYPE c .

DATA lv_num(10) TYPE c.

lv_char = '200,000,000.000'.

DO.

IF lv_char CA ','.

REPLACE ',' WITH '.' INTO lv_char.

else.

EXIT.

endif.

ENDDO.

write: lv_char.

regardz

Re: Problem with REPLACE statement

Former Member — Mon, 27 Jul 2009 09:30:37 GMT

Its solved using DO. REPLACE.ENDDO.