unix sort according to a header line

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 ...

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,...

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...

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 ...

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 ...

6. Shell Programming and Scripting

Simple sort with header

Hi, Please help with this problem. Somehow does not work for me. 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 ...

7. 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...

8. UNIX for Dummies Questions & Answers

Sort and uniq lines of a file while keeping a header line

So, I have a file that has some duplicate lines. The file has a header line that I would like to keep at the top. I could do this by extracting the header from the file, 'sort -u' the remaining lines, and recombine them. But they are quite big, so if there is a way to do it with a single...

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...

10. Shell Programming and Scripting

How to sort standard input without first line < Header >

LEARN ABOUT OSF1

look

look(1) 						      General Commands Manual							   look(1)

NAME

       look - Finds lines in a sorted list

SYNOPSIS

       look [-df] [-tcharacter] string [file]

       The look command prints all lines in a sorted file that begin with string.

OPTIONS

       Uses  dictionary  order; only letters, digits, tabs, and spaces are used in comparisons.  Searches without regard to case; treats uppercase
       and lowercase as equivalent.  Ignores character and characters following it in the search string.  If  you  specify  look  -tC  ABCDE,  the
       string  ABCDE  would  become  (in  effect)  AB, with CDE being ignored.	This option is primarily for shell scripts, in which more than one
       string is being processed.

DESCRIPTION

       If no file is specified, look searches in the system word list /usr/share/dict/words, with the options -df assumed by default.

       The look command uses binary search.

       The -d and -f options affect comparisons as in sort.

NOTES

       In order to use the -f option, you must first sort file with the sort -f command; otherwise, look displays only lowercase items.

       If you do not specify -f, but specify a file (such as /usr/share/dict/words) that has been sorted with sort -f, look may  not  produce  any
       output.

EXAMPLES

       To search a sorted file called sortfile for all lines that begin with the string as, enter: look as sortfile To search the system word list
       for all words beginning with smi, enter: look smi

	      This might result in: smile smirk smith smithereens Smithfield Smithson smithy smitten

FILES

       System word list.

SEE ALSO

       Commands:  grep(1), sort(1), spell(1)

																	   look(1)

Shell Programming and Scripting