Issue with reading the first line of CSV file

[former_member1277120]

Hello Experts,

CSV file from AL11 folder is opened and read using the below commands

OPEN DATASET filename FOR INPUT IN TEXT MODE ENCODING DEFAULT WITH SMART LINEFEED

Reading dataset is as below:

READ DATASET  filename INTO wa_tab_dataset.

While checking the first 3 characters of WA_TAB_DATASET it is ignoring the third character as shown below.

This happens only for the first line of the file. In the file we could not see any spaces as well.

Any inputs regarding this will be helpful.

Thanks and Regards,

Sanjay.

[matt]

What does the hexadecimal field show for these two scenarios?

[Sandra_Rossi]

Look at the "hexadecimal" part:

FF...

It's probably FFFE...

FFFE is the Byte-Order-Mark character for UTF-16 Little Endian (it could be also UTF-32LE but it's very rare).

Make sure with the architects that this format is as expected. It should also be documented in the requirement.

If it's confirmed, then you need to:

• open the dataset IN BINARY MODE
• read it into XSTRING variable (no loop needed, the whole file will be read at once)
• Convert XSTRING into STRING using a code page conversion class with code page '4103' or 'utf-16le' (depends on your ABAP version).

[former_member808116]

You try: Wa_tab_dataset+0(3).

[former_member1277120]

Hello Sandra,

As you said Hexadecimal part is FFFE for the first row and it is different for all the other rows.

I will check with the Architects. Thanks for your help.

Regards,

Sanjay.