reading of the fixed width file with Header and tail
Posted: Thu Apr 03, 2008 1:13 am
I am having one requirement regarding reading of the fixed width file with Header, Tail and data information.
The file looks like :::
90 20071001 3
91 AED EMIRATS ARABES ARS 0.84563700 1.18254000 1 AE
91 AED EMIRATS ARABES AUD 0.33151200 3.01649000 1 AE
91 AED EMIRATS ARABES BDT 18.76790000 0.05328200 1 AE
91 AED EMIRATS ARABES BOB 2.15611000 0.46379800 1 AE
99 20071031 3
Where the first & last line consits of three columns (Header & tail data )
Block type definition : 90
Application date for company : 20071001
Type of currency ::: 3
And data consists of 9 columns .
The header information is not used in target side.
In my output file consists only columns from data rows.
Can anyone please tell me how to read such files.
thnks
venkat
The file looks like :::
90 20071001 3
91 AED EMIRATS ARABES ARS 0.84563700 1.18254000 1 AE
91 AED EMIRATS ARABES AUD 0.33151200 3.01649000 1 AE
91 AED EMIRATS ARABES BDT 18.76790000 0.05328200 1 AE
91 AED EMIRATS ARABES BOB 2.15611000 0.46379800 1 AE
99 20071031 3
Where the first & last line consits of three columns (Header & tail data )
Block type definition : 90
Application date for company : 20071001
Type of currency ::: 3
And data consists of 9 columns .
The header information is not used in target side.
In my output file consists only columns from data rows.
Can anyone please tell me how to read such files.
thnks
venkat