Reading from sequential file
Posted: Wed Aug 13, 2008 11:56 pm
HI,
We have input file as follows:
, we have to read the records from 5 column name (col1,col2,col3,col4,col5).
Can anybody suggest how to read the file.
WE have tried with fixed width column option , but all columns doesn't have same length,so it not working.
Also tried COlumn Importer stage ,but we are not getting desired results..
that for col2 , some part of col3 is getting attached to col2.
Thanks in Advance!
We have input file as follows:
Code: Select all
XXX XXXXXXX YYY YY YYYYY AAAAAA AAAA WWW_WWW_WWW WW DESCRIPTION
XXX XXXXXXX YYY YY YYYYY AAAAAA AAAA WWW_WWW_WWW WW DESCRIPTION
XXX XXXXXXX YYY YY YYYYY AAAAAA AAAA WWW_WWW_WWW WW DESCRIPTION
XXX XXXXXXX YYY YY YYYYY AAAAAA AAAA WWW_WWW_WWW WW DESCRIPTION
XXX XXXXXXX YYY YY YYYYY AAAAAA AAAA WWW_WWW_WWW WW DESCRIPTION
XXX XXXXXXX YYY YY YYYYY AAAAAA AAAA WWW_WWW_WWW WW DESCRIPTION
XXX XXXXXXX YYY YY YYYYY AAAAAA AAAA WWW_WWW_WWW WW DESCRIPTION
XXX XXXXXXX YYY YY YYYYY AAAAAA AAAA WWW_WWW_WWW WW DESCRIPTION
XXX XXXXXXX YYY YY YYYYY AAAAAA AAAA WWW_WWW_WWW WW DESCRIPTION
Can anybody suggest how to read the file.
WE have tried with fixed width column option , but all columns doesn't have same length,so it not working.
Also tried COlumn Importer stage ,but we are not getting desired results..
that for col2 , some part of col3 is getting attached to col2.
Thanks in Advance!