Using sort with awk script Post: 302150923

Sponsored Content

Top Forums Shell Programming and Scripting Using sort with awk script Post 302150923 by Trellot on Thursday 13th of December 2007 03:47:55 AM

12-13-2007

Registered User

Quote:

Originally Posted by Trellot

I have a file with four fields and an awk script that strips out one field displaying the remaining three. I have added headings for each of these fields such as Player - Year - RBIs then below it comes the data. What I am trying to do is sort the RBIs field in my script from most to least at the shell prompt using the sort command ...however, the headings are also getting sorted! How can I disclude (heh, not even a word, but sounds right) the three headings from my sort?

Trellot

For example, I have this:

BEGIN { printf("%8s%12s%9s\n", "Player", "Year", "RBIs")
printf("\n") }
{ printf("%8s%12s%10s\n", $1, $2, $4) }

then i type into the shell: awk -f "script" "file" | sort -k 3nr

but then my headings go to the bottom of the output. Can you sort specific lines within their respective field, thus leaving my headings alone?

hmm....

Last edited by Trellot; 12-13-2007 at 05:01 AM.. Reason: add question at end of post about line sorting

Trellot

View Public Profile for Trellot

Find all posts by Trellot

9 More Discussions You Might Find Interesting

1. Homework & Coursework Questions

awk sort help

1. The problem statement, all variables and given/known data: I dont know what I do wrong, I am trying to create shell programming database: I have this command first: && > $fname ... echo $Name:$Surname:$Agency:$Tel:$Ref: >> $fname then I have echo " Name Surname Agency Tel...

2. Shell Programming and Scripting

Sort in AWK

Hi, I usually use Access to sort data however for some reason its not working. Our systems guys and myself cannot figure it out so ive tried to use AWK to do the sorting. The file is made up of single lines in the format ...

3. UNIX for Advanced & Expert Users

Script to sort the files and append the extension .sort to the sorted version of the file

Hello all - I am to this forum and fairly new in learning unix and finding some difficulty in preparing a small shell script. I am trying to make script to sort all the files given by user as input (either the exact full name of the file or say the files matching the criteria like all files...

4. Shell Programming and Scripting

How do I sort two arrays using awk?

Hi How do I sort two arrays in a ascending order? I'm just doing this to teach myself a book my dad got me on unix. The arrays are A and B and both are including values taken from a file input by the user. How do I arrange the contents of both arrays so that they are both ordered from...

5. Shell Programming and Scripting

Awk script to sort and display total occurancies

Hi I am not a good awk programer but the below code serving my purpose Input process 12936 user-name 15u IPv4 7438309 0t0 TCP prdabc.cesi.com:42016->efh.ijk.com:50002 (ESTABLISHED) process 12942 user-name 13u IPv4 7764990 0t0 TCP abc.abc.com:9402->192.168.1.1:63919...

6. Shell Programming and Scripting

awk sort

input file abc1 abc23 abc12 abc15 output abc1 abc12 abc15 abc23

7. Homework & Coursework Questions

Shell script/awk to sort text

1. The problem statement, all variables and given/known data: I have a file with a fragment of a novel, which I have to clear from punctuation and sort all the words contained one per line and non duplicated, all this going to a file called "palabras". Here is fragment of the input file: ...

8. Shell Programming and Scripting

awk pipe to sort

In the below awk to add a sort by smallest to largest should it be added after the END? Thank you :). BEGIN { FS="*" } # Read search terms from file1 into 's' FNR==NR { s next } { # Check if $5 matches one of the search terms for(i in s) { if($5 ~ i) { ...

9. UNIX for Beginners Questions & Answers

Shell script to call and sort awk script and output

I'm trying to create a shell script that takes a awk script that I wrote and a filename as an argument. I was able to get that done but I'm having trouble figuring out how to keep the header of the output at the top but sort the rest of the rows alphabetically. This is what I have now but it is...

LEARN ABOUT OPENSOLARIS

ppmhist

ppmhist(1)                                                    General Commands Manual                                                   ppmhist(1)

NAME

       ppmhist - print a histogram of a portable pixmap

SYNOPSIS

       ppmhist [-hexcolor] [-noheader] [-map] [-nomap] [-sort={frequency,rgb}] [ppmfile]

DESCRIPTION

       Reads  a  PPM  image as input.  Generates a histogram of the colors in the image, i.e. a list of all the colors and how many pixels of each
       color are in the image.

OPTIONS

       -sort={frequency,rgb}
              The -sort option determines the order in which the colors are listed in the output.  frequency means to list them in  order  of  how
              pixels  in the input image have the color, with the most represented colors first.  rgb means to sort them first by the intensity of
              the red component of the color, the of the green, then of the blue, with the least intense first.

              The default is frequency.

       -hexcolor
              Print the color components in hexadecimal.  Default is decimal.

       -noheader
              Do not print the column headings.

       -map   Generates a PPM file of the colormap for the image, with the color histogram as comments.

       -nomap Generates the histogram for human reading.  This is the default.

SEE ALSO

       ppm(5), pgmhist(1), ppmtomap(1), pnmhistmap(1), ppmchange(1)

AUTHOR

       Copyright (C) 1989 by Jef Poskanzer.

                                                                 17 September 2000                                                      ppmhist(1)