topic Re: Replace Statement on Unicode system in Application Development and Automation Discussions

Replace Statement on Unicode system

Former Member — Thu, 15 Jun 2006 22:15:57 GMT

I am on Unicode system . I am reading a file from application server. i am doing like this

Data:char TYPE C,

test(2000).

READ DATASET DATASET INTO test.

IF SY-SUBRC <> 0. EXIT. ENDIF.

in test i am getting data like 'KK#hh#jkjkjkjk#jkjlk hjkjh hkjh 4354#

I try these both statment.

REPLACE all occurences of CHAR in test WITH space.

REPLACE CHAR WITH ' ' INTO test.

But it’s just replacing the '#' in last occurrence "KK#hh#jkjkjkjk#jkjlk hjkjh hkjh 4354#"

Why its not replacing all with space?

Cheers

Usman

Re: Replace Statement on Unicode system

abdul_hakim — Thu, 15 Jun 2006 22:20:01 GMT

try the below example.

data rule(2) type c value '# '.

translate test using rule.

Cheers,

Abdul Hakim

Re: Replace Statement on Unicode system

Former Member — Thu, 15 Jun 2006 22:22:14 GMT

Hi Usman,

Use SPLIT Statement instead of replace this defintely works as it worked for me...

i.e, Split at '#'.

Reward if it helps.

Regards,

Santosh

Re: Replace Statement on Unicode system

RichHeilman — Thu, 15 Jun 2006 22:24:23 GMT

Are you trying to replace th # with space. If so, the # is not probably not a # but a tab. THe # is an internal representation of tab. You can do this.



REPLACE all occurences of 
       <b>cl_abap_char_utilities=>horizontal_tab</b> in test WITH space.

REgards,

Rich Heilman

Re: Replace Statement on Unicode system

Former Member — Thu, 15 Jun 2006 22:27:03 GMT

Thanks a lot Rich .

Its removing '#' but not giving spaces ? Why

Its also leaving '#' sign at the end of string

e,g

'KK#hh#jkjkjkjk#jkjlk hjkjh hkjh 4354#

after code

'KKhhjkjkjkjkjkjlk hjkjh hkjh 4354#

Cheers

Usman

Message was edited by: Usman Akram

Re: Replace Statement on Unicode system

RichHeilman — Thu, 15 Jun 2006 23:08:32 GMT

Not sure why it is not leaving space. That is strange. The last # must not be a tab, but a CR_LF.

After the REPLACE statement, do it again, this time with.

 cl_abap_char_utilities=>cr_lf

Hopefully it will get rid of the # at the end. If not, then do another REPLACE with the '#' sign.

Regards,

Rich Heilman

Re: Replace Statement on Unicode system

RichHeilman — Thu, 15 Jun 2006 23:16:53 GMT

Wow, that is weird. I'm seeing the same with it not leaving the space. Anyway. Here is a work around.



report zrich_0006.

data: d1 type localfile value '/usr/sap/nsp/test.txt'.
data: str type string.

open dataset d1 for input in text mode encoding default.

do.

  read dataset d1 into str.
  if sy-subrc <> 0 .
    exit.
  endif.
<b>  replace all occurrences of
              cl_abap_char_utilities=>horizontal_tab
                          in str with '%'.</b>
<b>  translate str using '% '.</b>

  write:/ str.

enddo.

close dataset d1.

REgards,

Rich Heilman

Re: Replace Statement on Unicode system

Former Member — Fri, 16 Jun 2006 14:38:19 GMT

Yes, I dont why its not creating spaces but this work

replace all occurrences of

cl_abap_char_utilities=>horizontal_tab

in str with '%'.

translate str using '% '.

Cheers

Usman