Remove Header and Trailor records from a fixed width file
Posted: Mon Dec 03, 2007 11:14 pm
Hi All,
I have gone through the posts here for removal of header and trailor records from a file.
I found that these posts has a requirement where the header and trailor were of different format hence we can automatically reject the records while reading the file.
I have a fixed width file where in the header and trailor needs to be removed or ignored while reading the data from the file.
The record length of these two records are the same as the file.
For example of the record length each record is 261 then the record length of header and trailor is the same with spaces appended at the end of them.
I am aware that we can remove the header and trailor via a script but we are looking at implementing it in DS.
Any help on this? Thanks in advance.
I have gone through the posts here for removal of header and trailor records from a file.
I found that these posts has a requirement where the header and trailor were of different format hence we can automatically reject the records while reading the file.
I have a fixed width file where in the header and trailor needs to be removed or ignored while reading the data from the file.
The record length of these two records are the same as the file.
For example of the record length each record is 261 then the record length of header and trailor is the same with spaces appended at the end of them.
I am aware that we can remove the header and trailor via a script but we are looking at implementing it in DS.
Any help on this? Thanks in advance.