how to ignore first row in CSV file

[manikandan_shanmugam3]

Hi All,

Scenario: CSV to ABAP Proxy

we are getting CSV file,in which first row is header text and rest are records,please let me know how to ignore first row and read only records.

Regards,

Mani

[former_member181985 · Accepted solution]

Hi,

Pretty simple. in FCC, Use document offset and ignore how many lines you want to ignore from start. In your case it should be 1

Converting Text Format in the Sender File/FTP Adapter to XML - Advanced Adapter Engine - SAP Library

- Praveen

[pvishnuvardan_reddy]

Hi Manikandan,

If you are using FCC as message protocol, then there is a option Documentoffset where you can mention the no of lines which you need to ignore.

If your message protocol is not FCC, then you would be using Message transform bean, then you can use its parameter skipDocumentFirstRows option to ignore the no of lines.

Regards

Vishnu

[Former Member]

Hi Manikandan,

Using Document offset as 1 should solve your problem.

Please check below link for further reference :

How to remove heading from File Content Conversion | SCN

Thanks,

Satanik