sort a report file having header and footer


Login or Register to Reply

 
Thread Tools Search this Thread
# 1  
Old 11-25-2011
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
# 2  
Old 11-25-2011
None of your previous threads with extremely similar questions gave you any ideas?

What you have you tried so far?

Example input & output?
# 3  
Old 11-25-2011
MNM PRIVATE LIMITED
REPORT GENERATED ON 25.11.2011
CONSOLIDATION REPORT
--------------------------------------
NAME | EMPID | PLACE | RANK | SALARY|
--------------------------------------
A1 |121 | AP | 19 |2000 |
A2 |125 | KA | 11 |12000 |
A3 |129 | GJ | 16 |2000 |
A4 |127 | CHE | 81 |8000 |
A5 |126 | DEL | 61 |5000 |
A6 |120 | KA | 21 |5000 |
A7 |128 | AP | 10 |2000 |
A8 |123 | AP | 91 |2000 |
--------------------------------------
tOTAL |38000 |
--------------------------------------
# 4  
Old 11-25-2011
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.

The report file is given below

MNM PRIVATE LIMITED
REPORT GENERATED ON 25.11.2011
CONSOLIDATION REPORT
--------------------------------------
NAME | EMPID | PLACE | RANK | SALARY|
--------------------------------------
A1 |121 | AP | 19 |2000 |
A2 |125 | KA | 11 |12000 |
A3 |129 | GJ | 16 |2000 |
A4 |127 | CHE | 81 |8000 |
A5 |126 | DEL | 61 |5000 |
A6 |120 | KA | 21 |5000 |
A7 |128 | AP | 10 |2000 |
A8 |123 | AP | 91 |2000 |
--------------------------------------
tOTAL|38000 |
--------------------------------------

I have to sort above based on empid,rank,salary

pls help
# 5  
Old 11-25-2011
This makes some assumptions about the report format. Should work if it is as you indicated in your sample.


Code:
awk '
    BEGIN {
        sort = "sort -t \\| -k 2n,2 -k 4n,4 -k 5n,5"
    }
    /------/ {                  # use dashes to determine records to sort
        if( ++snarf > 2 )
        {
            close( sort );
            snarf = -1;
        }
        print;
        next;
    }
    {
         if(  snarf > 1 )
              print |sort;
          else
              print;
   }
' input-file


Last edited by agama; 11-25-2011 at 10:57 PM.. Reason: fixed major bug
Login or Register to Reply

|
Thread Tools Search this Thread
Search this Thread:
Advanced Search

More UNIX and Linux Forum Topics You Might Find Helpful
Split large xml into mutiple files and with header and footer in file karthik Shell Programming and Scripting 36 19 Hours Ago 01:33 AM
Eliminate Header and footer from EBCDIC file abhilashnair UNIX for Dummies Questions & Answers 4 12-18-2014 05:48 AM
Strip header and footer samrat dutta Shell Programming and Scripting 5 06-17-2013 02:08 PM
File Row Line Count without Header Footer gagan8877 UNIX for Dummies Questions & Answers 7 05-02-2013 02:29 PM
Is there a way to append both at header and footer of a file jediwannabe Shell Programming and Scripting 3 02-28-2013 06:57 AM
Removing header or footer from file sridhardwh Shell Programming and Scripting 5 06-04-2012 06:43 AM
Add header and footer with record count in footer itsranjan Shell Programming and Scripting 1 03-25-2012 12:45 AM
Header and Footer... suresh_target Shell Programming and Scripting 1 02-15-2012 04:44 AM
Ignore Header and Footer and Sort the data in fixed width file sasikari Shell Programming and Scripting 5 07-14-2011 12:42 PM
How to add header and footer? ken002 Shell Programming and Scripting 4 11-22-2010 11:23 PM
Inserting Header and footer digitalrg Shell Programming and Scripting 4 04-17-2009 06:17 AM
Split large file and add header and footer to each small files ashish4422 Shell Programming and Scripting 7 07-07-2008 03:13 PM
Split large file and add header and footer to each file ashish4422 Shell Programming and Scripting 1 04-15-2008 07:12 AM
Total of lines w/out header and footer incude for a file gzs553 Shell Programming and Scripting 1 11-16-2006 07:42 PM
Need to Chop Header and Footer record from input file coolbudy Shell Programming and Scripting 4 08-09-2005 01:26 PM