Get Header and Trailer record using a single sed command

[RAJARP]

Hi ,

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

Code: Select all

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

--> all records without header and trailer

Code: Select all

 sed  '1!d'

--> just the header record

Code: Select all

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

Code: Select all

  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

[rkashyap]

In the Filter property enter either

Code: Select all

sed -n '1p;$p'

or

Code: Select all

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

[RAJARP]

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