CSV file column heading

[Former Member]

Hi Experts,

This is File to IDOC scenario. The source file is a csv file with header and item records.

The file comes with column headings and now problem is how to remove the column headings using my content conversion.

Any help would be appericiated

Regards,

Vijay

[former_member206604 · Accepted solution]

Hi Vijay,

You can use the file adapter parameter Document Offset = 1. This will remove the first line from the file.

Simillar to that you can ignore any number or lines in the begining of the file.

Refer this link

http://help.sap.com/saphelp_nw04/helpdata/en/2c/181077dd7d6b4ea6a8029b20bf7e55/content.htm

Thanks,

Prakash

[Former Member · Accepted solution]

Hi Prakash,

Yes you are right but now my problem is the file will not have the header all the time. Actually the source files are generated from different legacy systems so some may have column headings and some may not have.. but the structure remains the same.

Regards,

Vijay

Message was edited by: Vijay Kuruvila

Message was edited by: Vijay Kuruvila

[former_member206604 · Accepted solution]

Hi,

I have also faced simillar problems.. please refer this post this might solve your problem.

Thanks,

Prakash