Skip to Content
0
Nov 02, 2012 at 02:19 AM

Content Conversion - Batch File

26 Views

We have a scenario where the text flat files coming in contain control information along with repeating record sets

File Format

Control Header (occurs 1)

Recordset (occurs 1- unbounded)

Transaction Header (occurs 1)

Transaction Detail (occurs 1- unbounded)

Control Trailer (occurs 1)

I.e

CH

TXH

TXD

TXD

TXH

TXD

CT

The control trailer contains summary information about the contents of the file, like record set count, total line count, total $$ in file. This data will be used to validate the completeness of the file.

My issue is parsing the file using the sender file adapter. I have read many of the discussion forums and haven't found a solution for files that contain header and trailer along with repeating record sets

Thanks,

Andrew