Shell Programming and Scripting

Hi ,
My UNIX system is SUN Solaris.
I am trying to do a simple thing as described below.
I have a PIPE delimited file that has header and trailer. So the file is something like below:

Test1.txt looks like something below:
I want to perform the things below in this file:



So the output should be Test2.txt -sorted by field 2 and 3 and add the header from step2.



I would appreciate any advice and help.


Thanks

How about

Code:

{ head -1 ; head -n-1 | sort -t"|" -k2,3; } < Test1.txt

If happy, redirect result to a file.

With sed instead of GNU head

Code:

{
read header; printf "%s\n" "$header"
sed '$d' | sort -t\| -k2,3
} < Test1.txt > Test2.txt

Code:

{ head -1 ; head -n-1 | sort -t"|" -k2,3; } < Test1.txt

Thanks for the reply. But the code is not working. Getting the error below:

head: Invalid "-n -1" option
usage: head [-n #] [-#] [filename...]

Thanks

---------- Post updated at 03:52 PM ---------- Previous update was at 03:50 PM ----------

Code:

{
read header; printf "%s\n" "$header"
sed '$d' | sort -t\| -k2,3
} < Test1.txt > Test2.txt

Thanks a bunch. The code above working fine for me.

I wanted to check if there is a way to output without header as well.

Thanks again.

Try:

Code:

sed '1d;$d' Test1.txt | sort -t\| -k2,3 > Test2.txt

Code:

tail -n +2 Test1.txt | sort -t\| -k2,3