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!