How to read fixed width files(Header,Trailer and detail rec)
Posted: Thu Feb 19, 2009 6:10 am
Hi,
I am new to profiling..
My source system is FIXEDWIDTH file. This file structure is ,
00123420090218
01234446venkgfftyhh123bbh 123 T02
01234447cenkgfftyhh123bbh 123 T02
01234448dbnkgfftyhh123bbh 123 T02
01234449aenkgfftyhh123bbh 123 T02
991234004
In which 1st line is header (start with 00, single record), lost line is trailer (start with 99 single record) and in between records are detail records(start with 01 multiple records).
My query is how to read this type of files and also how to define structure in QETXT.INI.
please suggest me.
I am new to profiling..
My source system is FIXEDWIDTH file. This file structure is ,
00123420090218
01234446venkgfftyhh123bbh 123 T02
01234447cenkgfftyhh123bbh 123 T02
01234448dbnkgfftyhh123bbh 123 T02
01234449aenkgfftyhh123bbh 123 T02
991234004
In which 1st line is header (start with 00, single record), lost line is trailer (start with 99 single record) and in between records are detail records(start with 01 multiple records).
My query is how to read this type of files and also how to define structure in QETXT.INI.
please suggest me.