Hi All,
Can anyone advice me how to remove header and trailer from the Sequential file. The thing is, the source file has two header and two trailer. How to remove those two headers and trailers in Datastage???
Thanks in Advance,
Meem
Removing Header/Trailer from Seq File
Moderators: chulett, rschirm, roy
You can achieve this through the sed.
Write a shell script. Run the shell script as the before job subroutine. The script may be like this
sed '1,1d'< inseqfile > outseqfile -- This can remove the first line from a file
sed '$d' < inseqfile > outseqfile -- This is to remove the last line from the file..
You can arrange the above script to achieve the same what you want.
You can try with Head and Tail stage also.
Write a shell script. Run the shell script as the before job subroutine. The script may be like this
sed '1,1d'< inseqfile > outseqfile -- This can remove the first line from a file
sed '$d' < inseqfile > outseqfile -- This is to remove the last line from the file..
You can arrange the above script to achieve the same what you want.
You can try with Head and Tail stage also.
-
- Participant
- Posts: 612
- Joined: Thu May 03, 2007 4:59 am
- Location: Melbourne
If you have MKS Toolkit installed (Which Ships and installs with version 7.5x2) you can try the below described:
To remove header (2) and footer (2) from your file try this command in your filter option of sequential file satge:
To remove header (2) and footer (2) from your file try this command in your filter option of sequential file satge:
Code: Select all
sed 'N;$!P;$!D;$d' -e '1d' -e '2d'
Joshy George
<a href="http://www.linkedin.com/in/joshygeorge1" ><img src="http://www.linkedin.com/img/webpromo/bt ... _80x15.gif" width="80" height="15" border="0"></a>
<a href="http://www.linkedin.com/in/joshygeorge1" ><img src="http://www.linkedin.com/img/webpromo/bt ... _80x15.gif" width="80" height="15" border="0"></a>
Craig - yep, that is the way to do it if the formats of the header/trailer are different and you don't need the data in those rows. The header row is usually column names and will have the same number of column separators as the data, but if you have non-string columns then the text column names will trigger the header row(s) to be rejected.
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact: