Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: Sort table ignoring header
Top Forums UNIX for Beginners Questions & Answers Sort table ignoring header Post 303046346 by shanul karim on Friday 1st of May 2020 01:32:42 PM
Old 05-01-2020
Sort table ignoring header
Dear experts,


Need help in order to find out way to sort table ignoring header.




Quote:
awk 'BEGIN{print ("NAME DATE,TIME CNT1 CNT2 CNT3 CNT4 SR1 SR2 SR3 ")}function printValues(){if (Values){print S, Date, Value["NSMSSMRLTOT"],Value["NSMSSRSUCC"],Value["NSMSCMTOT"],Value["NSMSCMRSUCC"],(Value["NSMSSRSUCC"]/Value["NSMSSMRLTOT"])*100,(Value["NSMSCMRSUCC"]/Value["NSMSSMRLTOT"])*100,(Value["NSMSCMRSUCC"]/Value["NSMSCMTOT"])*100;}delete Value;}$1~/^BC/{S=$1}$7=="(OK)"{printValues();Date = $2 " " $3 " " $4;S;next;}$1+0{Value[$3] = $2;Values++;next;}END{ printValues()}' SHMSGSERV24_2 | column -t |sort -n -k 4

Here I tried the sort option to ignoring header as



Code:
awk 'BEGIN{print ("NAME DATE,TIME CNT1 CNT2 CNT3 CNT4 SR1 SR2 SR3 ")}function printValues(){if (Values){print  S, Date,   Value["NSMSSMRLTOT"],Value["NSMSSRSUCC"],Value["NSMSCMTOT"],Value["NSMSCMRSUCC"],(Value["NSMSSRSUCC"]/Value["NSMSSMRLTOT"])*100,(Value["NSMSCMRSUCC"]/Value["NSMSSMRLTOT"])*100,(Value["NSMSCMRSUCC"]/Value["NSMSCMTOT"])*100;}delete Value;}$1~/^BC/{S=$1}$7=="(OK)"{printValues();Date = $2 " " $3 " " $4;S;next;}$1+0{Value[$3] = $2;Values++;next;}END{ printValues()}' SHMSGSERV24_2 | column -t |{head -n 1;sort -n -k 4;}


But this option deleting few lines in between. Any other suggestion.
 

10 More Discussions You Might Find Interesting

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

2. 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 ... (4 Replies)
Discussion started by: genehunter
4 Replies

3. Linux

Top header says 50% free, but table shows 100% used

Hi, Can anyone explain this? top - 04:21:04 up 23 days, 2:35, 1 user, load average: 0.02, 0.02, 0.00 Tasks: 37 total, 1 running, 36 sleeping, 0 stopped, 0 zombie Cpu(s): 0.0%us, 0.0%sy, 0.0%ni,100.0%id, 0.0%wa, 0.0%hi, 0.0%si, 0.0%st Mem: 524288k total, 253084k used,... (1 Reply)
Discussion started by: varontron
1 Replies

4. Shell Programming and Scripting

How to Add Table with Header for Shell Output

I have a Script that generates 3 columns of the result. The line script is /usr/xpg4/bin/awk -F' ' '{print $1 /t $2}' File_Name | awk -F'>' '{print $2}' | cut -d'<' -f1 | sort -rn | uniq -c The output of the Command is : Code.500 4 Input Error Code.404 ... (4 Replies)
Discussion started by: raghunsi
4 Replies

5. UNIX for Dummies Questions & Answers

Merge all csv files in one folder considering only 1 header row and ignoring header of all others

Friends, I need help with the following in UNIX. Merge all csv files in one folder considering only 1 header row and ignoring header of all other files. FYI - All files are in same format and contains same headers. Thank you (4 Replies)
Discussion started by: Shiny_Roy
4 Replies

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

7. Shell Programming and Scripting

Replace a column with a value by ignoring the header lines

i have a file in the gz format , the content of the file is as follow. gzcat f1.gz # 1.name # 2.location # 3.age # 4.dob . . . . . . . . . # 43.hobbies < Aravind,33,chennai,09091980, , , , , , , surfing> (5 Replies)
Discussion started by: aravindj80
5 Replies

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

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

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

LEARN ABOUT DEBIAN

tm::coverage

TM::Coverage(3pm)					User Contributed Perl Documentation					 TM::Coverage(3pm)

NAME

       TM::Coverage - Topic Maps, Code Coverage

DESCRIPTION

       This auxiliary package keeps track of the code coverage. Probably quite irrelevant for a user.

       Automatically generated for TM (1.44).

	  ---------------------------- ------ ------ ------ ------ ------ ------ ------
	  File				 stmt	bran   cond    sub    pod   time  total
	  ---------------------------- ------ ------ ------ ------ ------ ------ ------
	  blib/lib/TM.pm		 96.4	84.5   58.0   93.7   90.6   27.5   89.6
	  blib/lib/TM/Analysis.pm	100.0	90.9	n/a  100.0  100.0    0.0   97.5
	  blib/lib/TM/AsTMa/Fact.pm	100.0	 n/a	n/a  100.0    n/a    0.0  100.0
	  blib/lib/TM/AsTMa/Fact2.pm	100.0	 n/a	n/a  100.0    n/a    0.0  100.0
	  blib/lib/TM/Bulk.pm		 76.8	71.4   62.5   85.7  100.0    0.0   75.3
	  blib/lib/TM/CTM/CParser.pm	 65.6	34.3   31.0   84.6    0.0    1.6   52.5
	  blib/lib/TM/CTM/Parser.pm	 90.9	50.0	n/a  100.0    0.0    0.0   79.4
	  blib/lib/TM/DM.pm		100.0	65.0   66.7  100.0    n/a    0.0   96.5
	  blib/lib/TM/Graph.pm		 99.1	88.5	n/a  100.0  100.0    0.0   97.4
	  blib/lib/TM/Index.pm		100.0	80.0   60.0  100.0   83.3    0.3   87.8
	  .../Index/Characteristics.pm	100.0  100.0	n/a  100.0    0.0    0.0   97.0
	  blib/lib/TM/Index/Match.pm	 98.5	87.5	n/a  100.0  100.0    0.5   97.6
	  blib/lib/TM/LTM/CParser.pm	 84.9	45.3   42.7   98.2    0.0    0.2   67.8
	  blib/lib/TM/LTM/Parser.pm	 95.7	62.5   50.0  100.0    0.0    0.0   87.1
	  blib/lib/TM/Literal.pm	 45.8	 0.0   11.8   30.0    0.0    0.4   24.2
	  blib/lib/TM/MapSphere.pm	 96.5	84.6   68.8  100.0  100.0    0.0   91.7
	  .../TM/Materialized/AsTMa.pm	100.0	 n/a	n/a  100.0    0.0    0.0   95.5
	  ...ib/TM/Materialized/LTM.pm	100.0	 n/a	n/a  100.0    0.0    0.0   95.5
	  .../TM/Materialized/MLDBM.pm	100.0	83.3	n/a  100.0    0.0    0.0   92.6
	  ...b/TM/Materialized/Null.pm	100.0	 n/a	n/a  100.0    n/a    0.0  100.0
	  ...TM/Materialized/Stream.pm	100.0  100.0  100.0  100.0    0.0    0.0   96.0
	  ...ib/TM/Materialized/XTM.pm	100.0	 n/a	n/a  100.0    0.0    0.0   96.7
	  blib/lib/TM/PSI.pm		100.0	 n/a	n/a  100.0    n/a    0.0  100.0
	  blib/lib/TM/QL.pm		 91.4	61.5   66.7  100.0   50.0    0.1   83.9
	  blib/lib/TM/QL/CParser.pm	 76.2	42.4   41.9   90.3    0.0    9.1   62.0
	  blib/lib/TM/QL/PE.pm		 83.8	77.3   80.0   91.7    0.0   52.5   80.5
	  blib/lib/TM/QL/TS.pm		 65.2	35.4   27.8   70.8   53.3    2.4   56.9
	  blib/lib/TM/ResourceAble.pm	 88.1	87.5	n/a  100.0  100.0    0.0   90.0
	  .../TM/ResourceAble/MLDBM.pm	100.0	75.0	n/a  100.0    0.0    0.0   94.2
	  blib/lib/TM/Serializable.pm	 94.9	65.6  100.0  100.0  100.0    0.0   84.1
	  .../TM/Serializable/AsTMa.pm	 99.1	87.9   66.7  100.0  100.0    0.0   94.2
	  ...TM/Serializable/Dumper.pm	100.0	 n/a	n/a  100.0    0.0    0.0   93.5
	  ...ib/TM/Serializable/LTM.pm	 94.1	 n/a	n/a   83.3  100.0    0.0   92.0
	  ...ib/TM/Serializable/XTM.pm	 96.3	85.2   72.9  100.0  100.0    0.2   91.5
	  .../lib/TM/Synchronizable.pm	100.0	75.0  100.0  100.0  100.0    0.0   97.2
	  ...M/Synchronizable/MLDBM.pm	100.0	50.0	n/a  100.0    0.0    0.0   89.3
	  ...nchronizable/MapSphere.pm	100.0	63.6   64.3  100.0  100.0    0.0   88.6
	  ...TM/Synchronizable/Null.pm	100.0	 n/a	n/a  100.0    0.0    0.0   87.5
	  blib/lib/TM/Tau.pm		100.0	91.7   80.0  100.0    0.0    0.0   95.6
	  blib/lib/TM/Tau/Federate.pm	 63.2	39.3	n/a   62.5   27.3    0.0   54.5
	  blib/lib/TM/Tau/Filter.pm	100.0	91.7   66.7  100.0   50.0    0.0   90.0
	  .../TM/Tau/Filter/Analyze.pm	100.0	 n/a	n/a  100.0  100.0    0.0  100.0
	  blib/lib/TM/Tree.pm		100.0	57.1   44.4  100.0   66.7    0.0   88.0
	  blib/lib/TM/Utils.pm		100.0	50.0	n/a  100.0    0.0    0.0   89.3
	  ...ib/TM/Utils/TreeWalker.pm	100.0  100.0	n/a  100.0    0.0    0.0   96.0
	  ...ib/TM/Workbench/Plugin.pm	100.0	 n/a	n/a  100.0    0.0    0.0   75.0
	  ...M/Workbench/Plugin/Tau.pm	 87.5	50.0	n/a   80.0    0.0    0.0   73.1
	  yapp/astma-fact.yp		 96.9	91.5   73.3   97.8    0.0    4.8   92.7
	  yapp/astma2-fact.yp		 97.4	91.6   58.3  100.0    0.0    0.2   91.6
	  Total 			 76.8	45.2   40.2   91.2   57.0  100.0   63.8
	  ---------------------------- ------ ------ ------ ------ ------ ------ ------

SEE ALSO

       TM

COPYRIGHT AND LICENSE

       Copyright 200[8] by Robert Barta, <drrho@cpan.org>

       This library is free software; you can redistribute it and/or modify it under the same terms as Perl itself.

perl v5.10.1							    2008-10-05							 TM::Coverage(3pm)
All times are GMT -4. The time now is 08:06 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy