topic Re: How to remove '#'-sign from string in Application Development and Automation Discussions

How to remove '#'-sign from string

Olaf_B — Tue, 28 Nov 2006 07:57:59 GMT

Hi,

using file upload into internal table i've got '#' signs. In the main body of the table they are separators and are always on specific places.

In the header of the table they are at different places (and they are varying).

Exampleline:

0024 Company XYZ #Summary report November 2006

I've tried REPLACE, but the '#'-sign is not recognized

I've tried TRANSLATE, but it doesn't work

So the '#' sign is NOT equal with the one from your keyboard. It's a control character within files.

Any clues?

Regards

Olaf

Re: How to remove '#'-sign from string

Former Member — Tue, 28 Nov 2006 08:17:14 GMT

hi Olaf,

Check this out

Regards,

Santosh

Re: How to remove '#'-sign from string

Former Member — Tue, 28 Nov 2006 08:17:20 GMT

Hi,

try reading the file in Text mode.

Re: How to remove '#'-sign from string

Former Member — Tue, 28 Nov 2006 08:26:18 GMT

Hi Olaf

I guess the "#" is tab character.

Please use the below method and check if it works:

data: tab(1) type c value cl_abap_char_utilities=>horizontal_tab,
        str type string.

open dataset <dsn> for input in text mode encoding default.
if sy-subrc eq 0.
  do.
    read dataset <dsn> into str.
    if sy-subrc ne 0.
       exit.
    else.
       split str at tab into <wa>-fld1 <wa>-fld2....
       append <wa> to <itab>.
    endf.
  enddo.
  close dataset <dsn>.
endif.

Hope this helps.

Kind Regards

Eswar