Ignoring File Header in Content Conversion

[sahana_ps]

Hi all,

I am working on a File to IDOC scenario,where the File Structure looks like below

Header

daf fg hgjnfh hwethjyr fhs dfsbhfd

Claim Header

3214 ghht 743665 hjgjyulk 64 fhjyk lkyhl jreyj hre

Claim Item

wqefs fd 245634 fsdg weqt

Trailer

31 53 gdfsh

when I use Content conversion or message transform bean in SFTP,i have to ignore the Header and trailer record while reading this fixed length file...how can this be achived?

[Former Member]

Hi Sahana,

Under Document Offset, specify the number of lines that are to be ignored at the beginning of the document. This enables you to skip comment lines or column names during processing. If you do not make an entry, the default value is zero lines.

So when you type Document Offset = 1, the first line of your input file will be ignored by the file adapter during FCC processing.

Regards,

Tulasiram.

[sahana_ps]

Hi ,

I am using SFTP channel and Message transform bean module to do content conversion in SFTP

[Former Member]

Hello,

Check Rene's reply:

U have to use below 2 parameters to ignore header line while reading text file.

xml.processFieldNames ------------ from File

xml.documentsSkipFirstRows-----   1

Thanks

Amit Srivastava

[Former Member]

Hello Sahana,

Please use the "Document Offset" parameter of FCC to remove the Header Line from your file.

Thanks,

Kalyan

[Former Member]

Hello,

Do u have any key field value?

If yes, then it can be done very easily and if not then u can do it partially.

I mean u can ignore first line which corresponds to header while doing FCC and read ur file and then at mapping level ignore trailer record.

Thanks

Amit Srivastava