topic Re: # problem while reading dataset from application server. in Application Development and Automation Discussions

# problem while reading dataset from application server.

Former Member — Fri, 31 Aug 2007 05:03:59 GMT

hi all,

I uplodaed a text file which is tab delimeted, to the application server using transaction code cg3z directly. now that file is stored with # in place of tab(space) in application server.

my broblem is that when i am reading that file using READ DATASET its comming with that # symbol also.

how i split that dataset .

or if there is any other solution ,like openning file into another mode,

help me.

thank uou

Re: # problem while reading dataset from application server.

Former Member — Fri, 31 Aug 2007 05:06:10 GMT

Hi Pawan,

The # symbols is a horizontal tab, You use CL_CHAR_ABAP_UTILITIES=>HORIZONTAL_TAB instead of # symbol to split the dataset.

Thanks,

Vinay

Re: # problem while reading dataset from application server.

varma_narayana — Fri, 31 Aug 2007 05:11:11 GMT

Hi Pawan..

you can access the Tab character using CL_CHAR_ABAP_UTILITIES=>HORIZONTAL_TAB

Do like this After READ DATASET.

DATA : V_RECORD(100).

DO.

READ DATASET P_FILE INTO V_RECORD.

IF SY-SUBRC <> 0.

EXIT.

ENDIF.

SPLIT V_RECORD INTO FIELD1 FIELD2 SEPARATED BY CL_CHAR_ABAP_UTILITIES=>HORIZONTAL_TAB.

<<<<further operations here>>>>

ENDDO.

reward if Helpful.

Re: # problem while reading dataset from application server.

Former Member — Fri, 31 Aug 2007 05:16:34 GMT

u need to use opendataset in binary mode with encoding default..............

Using the LEGACY TEXT MODE ensures that the data is stored and read in the old non-Unicode format. In this mode, it is also possible to read or write non-character-type structures. However, be aware that data loss and conversion errors can occur in Unicode systems if there are characters in the structure that cannot be represented in the non-Unicode codepage.

reward points if helpful.............

Message was edited by:

raam

Re: # problem while reading dataset from application server.

Former Member — Fri, 31 Aug 2007 05:29:18 GMT

Hello Pawan Kumar,

I also got same problem. it Just simple. Open data set in binary mode. This problem is due to new line which is reflected with # symbol.

Reward If Helpful.

Regards

Sasidhar Reddy Matli.