DSXchange

Posted: **Thu Aug 06, 2015 6:38 pm**

Hi ,

I have used sed command successfully in the Filter property of sequential file stage in the past
to get

 sed -e '1d' -e '$d'

--> all records without header and trailer

 sed  '1!d'

--> just the header record

sed  '$!d'

--> just the trailer record

But I want to get just the header and trailer using a same sed command
So far, I have tried

  1.sed '1!d;$!d' 
   2.sed -e '1!d' -e '$!d'

without any luck

Also, tried sed with -r flag as in sed -r and again no desired output.
Any pointers/help to achieve the same would be much appreciated

Thanks,
Raja

Posted: **Thu Aug 06, 2015 7:22 pm**

In the Filter property enter either

sed -n '1p;$p'

or

awk 'NR==1;END{print}'

Posted: **Fri Aug 07, 2015 11:50 am**

Thanks Kashyap,
Both of the commands worked like charm.Much appreciated

Get Header and Trailer record using a single sed command