How to ignore header in CSV (FCC)

[Former Member]

Hi,

I have a requirement in which XI has to ignore the Header when processing a CSV file like

Header1,Header2,Header3,Header4.....

Value1,Value2,Value3,Value4...

X1,X2,X3,X4...

Expected output is:

<RecordSet>

<Header1>Value1</Header1>

<Header2>Value2</Header2>

<Header3>Value3</Header3>

<Header4>Value4</Header4>

..

</RecordSet>

Regards,

AV

[Former Member · Accepted solution]

Specify Document Offset as 1

It will ignore column names/headings

For more help

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

[Former Member]

Thanks Mudgha and Mario,

Another Q: What if want to ignore trailor?

[Former Member]

Anirudh,

Ignore it in the mapping. Do not use the trailer records.

Regards,

Sudharshan N A

[Former Member]

Hi,

In FCC parameters Keep document offset as 1.so it will ignore the header level data.

Check some links on FCC.

/people/venkat.donela/blog/2005/03/02/introduction-to-simplefile-xi-filescenario-and-complete-walk-through-for-starterspart1

/people/venkat.donela/blog/2005/03/03/introduction-to-simple-file-xi-filescenario-and-complete-walk-through-for-starterspart2

/people/arpit.seth/blog/2005/06/02/file-receiver-with-content-conversion

/people/anish.abraham2/blog/2005/06/08/content-conversion-patternrandom-content-in-input-file

/people/shabarish.vijayakumar/blog/2005/08/17/nab-the-tab-file-adapter

/people/venkat.donela/blog/2005/03/02/introduction-to-simplefile-xi-filescenario-and-complete-walk-through-for-starterspart1

/people/venkat.donela/blog/2005/03/03/introduction-to-simple-file-xi-filescenario-and-complete-walk-through-for-starterspart2

/people/venkat.donela/blog/2005/06/08/how-to-send-a-flat-file-with-various-field-lengths-and-variable-substructures-to-xi-30

/people/anish.abraham2/blog/2005/06/08/content-conversion-patternrandom-content-in-input-file

/people/shabarish.vijayakumar/blog/2005/08/17/nab-the-tab-file-adapter

/people/jeyakumar.muthu2/blog/2005/11/29/file-content-conversion-for-unequal-number-of-columns

/people/shabarish.vijayakumar/blog/2006/02/27/content-conversion-the-key-field-problem

/people/michal.krawczyk2/blog/2004/12/15/how-to-send-a-flat-file-with-fixed-lengths-to-xi-30-using-a-central-file-adapter

/people/arpit.seth/blog/2005/06/02/file-receiver-with-content-conversion

http://help.sap.com/saphelp_nw04/helpdata/en/d2/bab440c97f3716e10000000a155106/content.htm

Regards,

Phani

Reward points if Helpful

[Former Member]

hi AV,

use parameter:

document-offset = 1 in sender communication channel

Regards Mario