Today (Saturday) We will make some minor tuning adjustments to MySQL.

You may experience 2 up to 10 seconds "glitch time" when we restart MySQL. We expect to make these adjustments around 1AM Eastern Daylight Saving Time (EDT) US.


sort a report file having header and footer


Login or Register to Reply

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

What you have you tried so far?

Example input & output?
# 3  
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  
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  
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
Eliminate Header and footer from EBCDIC file
abhilashnair
Is there any command to eliminate Header and footer from EBCDIC file... UNIX for Dummies Questions & Answers
4
UNIX for Dummies Questions & Answers
Is there a way to append both at header and footer of a file
jediwannabe
currently I've a file Insert into CD_CARD_TYPE (CODE, DESCRIPTION, LAST_UPDATE_BY, LAST_UPDATE_DATE) Values ('024', '024', 2, sysdate); Insert into CD_CARD_TYPE (CODE, DESCRIPTION, LAST_UPDATE_BY, LAST_UPDATE_DATE) Values ('032', '032', 2, sysdate); ........ is it...... Shell Programming and Scripting
3
Shell Programming and Scripting
Removing header or footer from file
sridhardwh
Hi Every one, what is the coomand to remove header or footer from a file. Please help me by providing command/syntax to remove header/footer from unix. Thanks in advance for all your support.... Shell Programming and Scripting
5
Shell Programming and Scripting
Add header and footer with record count in footer
itsranjan
This is my file(Target.txt) name|age|locaction abc|23|del xyz|24|mum jkl|25|kol The file should be like this 1|03252012 1|name|age|location 2|abc|23|del 2|xyz|24|mum 2|jkl|25|kol 2|kkk|26|hyd 3|4 Column 1 is row indicator for row 1 and 2, column indicator is 1,for data rows...... Shell Programming and Scripting
1
Shell Programming and Scripting
Ignore Header and Footer and Sort the data in fixed width file
sasikari
Hi Experts, I want to Sort the data in fixed width file where i have Header and Footer also in file. I m using below commad to do the sort based on field satarting from 15 position to 17 position , but it is not ignoring the Header and Footer of the file while sorting. In the output i am...... Shell Programming and Scripting
5
Shell Programming and Scripting

Featured Tech Videos