DSXchange

Hi,

I have an input file which has following format
All detail records are width 80,but within each set there are different coulmn widths

e.g Det Record1 can have 4 coulmns, whereas DEt Record2 can have 8 columns

How do I read this file?

Regards
Wah

wahi80 wrote:

Code: Select all

Header1
Det Records1 (Width 80)
Trailer1
Header2
Det Records2 (Width 80)
Trailer2
Header3
Det Records3 (Width 80)
Trailer3

Read each line as one record into a column1 defined as varchar 200.

Use a tranformer to sort the rows out into various links. you can build the logic inside transfomer that says that if column1 = "Header1" then send next 2 records to link1.