Simple sort with header


 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting Simple sort with header
# 1  
Old 05-26-2010
Simple sort with header

Hi,
Please help with this problem. Somehow does not work for me.

Code:
test.txt
 CHR          SNP         BP   A1      C_A      C_U   A2        CHISQ            P           OR
  19   rs10401969   19268718    C      222      890    T      0.03462       0.8524       0.9857
   1   rs10873889   76734548    G      934     3811    A       0.5325       0.4656       0.9691
   1   rs11589059  214196749    C      271     1084    T      0.01928       0.8896       0.9902

I want to sort on Col CHISQ ($8) keeping the header intact.
I used this code from another thread
Code:
gawk 'NR==1; {if(NR > 1) {print $0 | "sort -t '\t' -nk 8,8"}}' test.txt

However it does not work for me. Smilie
Thanks
# 2  
Old 05-26-2010
Code:
{
 IFS= read -r line
 printf "%s\n" "$line"
 sort -t '\t' -nk 8,8 
} < test.txt

This User Gave Thanks to cfajohnson For This Post:
# 3  
Old 05-26-2010
If your file isn't tab delimited then:

Code:
$
$
$ cat f2
 CHR          SNP         BP   A1      C_A      C_U   A2        CHISQ            P           OR
  19   rs10401969   19268718    C      222      890    T      0.03462       0.8524       0.9857
   1   rs10873889   76734548    G      934     3811    A       0.5325       0.4656       0.9691
   1   rs11589059  214196749    C      271     1084    T      0.01928       0.8896       0.9902
$
$
$ gawk 'NR==1; {if(NR > 1) {print $0 | "sort -nk 8,8"}}' f2
 CHR          SNP         BP   A1      C_A      C_U   A2        CHISQ            P           OR
   1   rs11589059  214196749    C      271     1084    T      0.01928       0.8896       0.9902
  19   rs10401969   19268718    C      222      890    T      0.03462       0.8524       0.9857
   1   rs10873889   76734548    G      934     3811    A       0.5325       0.4656       0.9691
$
$

tyler_durden
This User Gave Thanks to durden_tyler For This Post:
# 4  
Old 05-26-2010
Try without -t option in sort
Code:
gawk 'NR==1; {if(NR > 1) {print $0 | "sort -nk 8,8"}}' test.txt

This User Gave Thanks to anbu23 For This Post:
# 5  
Old 05-26-2010
Thank you all.
That worked fine!
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Sort without Header and Trailer

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: field_data1|field_data2|and some more data --Header ... (5 Replies)
Discussion started by: Saanvi1
5 Replies

2. Shell Programming and Scripting

Sort and Split file with header and custom name

Hi, I am using SUN SOLARIS (SunOS sun4v sparc SUNW, T5240). I have a huge data file with header and trailer. This file gets used into an ETL process. ETL skips the header record (which is the first record of the file) and loads the rest of the record. The file can be delimited (comma,... (5 Replies)
Discussion started by: Saanvi1
5 Replies

3. UNIX for Dummies Questions & Answers

Sort a las file keep the header as it is

I have several las files with a header and each file start Version and text and before the data starts end up with ~Ascii, then the numbers starts: ------------------------------------------------------------------------- ~Version .....text.... ~Ascii 2 abc 230 1 name 1 abc 400 1... (17 Replies)
Discussion started by: tk2000
17 Replies

4. UNIX for Dummies Questions & Answers

Sort a las file keep the header as it is

I have several las files with a header and each file start Version and text and before the data starts end up with ~Ascii, then the numbers starts: ------------------------------------------------------------------------- Code: ~Version .....text.... ~Ascii 2 abc 230 1 name 1 abc ... (1 Reply)
Discussion started by: tk2000
1 Replies

5. UNIX for Dummies Questions & Answers

Sort a tab file with header.

How to sort a tab delimited file first on col1 and then on col2. Also I need to keep the header intact. file.txt val1 val2 val3 val4 a b c d m n o p e f g h i j k l ... (3 Replies)
Discussion started by: mary271
3 Replies

6. Shell Programming and Scripting

sort a report file having header and footer

I am having report file with header and footer . The details in between header and footer are separated by a pipe charater. I want to sort the file by considering multiple columns in between header and footer. pls help (4 Replies)
Discussion started by: suryanarayana
4 Replies

7. Shell Programming and Scripting

unix sort according to a header line

Hi, I have a file with a header line, followed by some contents. How can I sort the file according to header lines? eg. /* abcd_005*/ a bc /* abcd_001*/ d e /* abcd_002*/ x y desired output: /*abcd_001*/ (0 Replies)
Discussion started by: neil.0412
0 Replies

8. Shell Programming and Scripting

bash ps; remove the header, sort and reinsert

Hi, I'm ssh'ing into a server using ruby and sending a one-liner to retrieve the output of the 'ps aux' command. So far, this is what I have: ps aux | sort -r -n -k3 | sed -e '1s/^/this is first\n/' | head -n10 With this I can insert a line at position 1, but I would rather extract the... (3 Replies)
Discussion started by: gekeha
3 Replies

9. UNIX for Dummies Questions & Answers

Add a header to a sort file instruction

Hello, I have a header which I have to add to a sorted file, however if I use cat header sortedfile > newfile, the operation takes 2 minutes as the sorted file is over 400mb. I have noticed that when I sort the 400mb unsorted file, this only takes 14 seconds to create the output. As... (2 Replies)
Discussion started by: clarcombe
2 Replies

10. Shell Programming and Scripting

How to sort standard input without first line < Header >

Do somebody have idea How to sort standard input without first line which in my case it's header Example: Cnt|VT |STAT|Date |Time |From |Alert Message |Instance | 125| | | 260308 |160026 |ZAMUAT2|ifpollq... (8 Replies)
Discussion started by: pp56825
8 Replies
Login or Register to Ask a Question