I have a txt file as an input to my transform and the format of the text file is:
HEAD ABS 04172011
12345 salestax IL 12.50
23456 VATtax IL 12.50
FOOT 2 25
My objective is to convert this txt file into XML for further processing.
I created a transform (fixed width to XML) and created a dictionary for this file. I am able to fetch the data from first row(Head) and last row (foot) as I defined the RecordLayout with type = HEAD and FOOT respectively. The data in middle rows start with different values.
What is the type I need to use for the LOOP->RecordLayout structure to fetch the middle rows dynamically? Is there any other alternative in iSM to achieve this?
Windows 2008 Server
I think you have to have a record type for every row for fixed width input files. You will need to define it somehow for the data records.
iWay Service Manager (6.0.1 - patch.62627)
DMC Version 7 Release 7
|Powered by Social Strata|