I have to extract a sequential file which has the following structure:
Header
Detail1
Detail2
Trailer
This structure repeats itself in the file. The first 6 characters in a line indicates the type - Header/Detail/Trailer.
However Detail line can be 1 or many between a header and trailer.
I want to extract them all, transform the detail row and load them all into a single file obviously in the exact order. Any clue on how this can be done?
I referred to the post
Code: Select all
http://www.dsxchange.com/viewtopic.php?t=103989&postdays=0&p
Appreciate any help on this
Thanks