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 CENTOS

dlaqr1.f

dlaqr1.f(3)							      LAPACK							       dlaqr1.f(3)

NAME

       dlaqr1.f -

SYNOPSIS

   Functions/Subroutines
       subroutine dlaqr1 (N, H, LDH, SR1, SI1, SR2, SI2, V)
	   DLAQR1 sets a scalar multiple of the first column of the product of 2-by-2 or 3-by-3 matrix H and specified shifts.

Function/Subroutine Documentation
   subroutine dlaqr1 (integerN, double precision, dimension( ldh, * )H, integerLDH, double precisionSR1, double precisionSI1, double precisionSR2,
       double precisionSI2, double precision, dimension( * )V)
       DLAQR1 sets a scalar multiple of the first column of the product of 2-by-2 or 3-by-3 matrix H and specified shifts.

       Purpose:

		 Given a 2-by-2 or 3-by-3 matrix H, DLAQR1 sets v to a
		 scalar multiple of the first column of the product

		 (*)  K = (H - (sr1 + i*si1)*I)*(H - (sr2 + i*si2)*I)

		 scaling to avoid overflows and most underflows. It
		 is assumed that either

			 1) sr1 = sr2 and si1 = -si2
		     or
			 2) si1 = si2 = 0.

		 This is useful for starting double implicit shift bulges
		 in the QR algorithm.

       Parameters:
	   N

		     N is integer
			 Order of the matrix H. N must be either 2 or 3.

	   H

		     H is DOUBLE PRECISION array of dimension (LDH,N)
			 The 2-by-2 or 3-by-3 matrix H in (*).

	   LDH

		     LDH is integer
			 The leading dimension of H as declared in
			 the calling procedure.  LDH.GE.N

	   SR1

		     SR1 is DOUBLE PRECISION

	   SI1

		     SI1 is DOUBLE PRECISION

	   SR2

		     SR2 is DOUBLE PRECISION

	   SI2

		     SI2 is DOUBLE PRECISION
			 The shifts in (*).

	   V

		     V is DOUBLE PRECISION array of dimension N
			 A scalar multiple of the first column of the
			 matrix K in (*).

       Author:
	   Univ. of Tennessee

	   Univ. of California Berkeley

	   Univ. of Colorado Denver

	   NAG Ltd.

       Date:
	   September 2012

       Contributors:
	   Karen Braman and Ralph Byers, Department of Mathematics, University of Kansas, USA

       Definition at line 122 of file dlaqr1.f.

Author
       Generated automatically by Doxygen for LAPACK from the source code.

Version 3.4.2							  Tue Sep 25 2012						       dlaqr1.f(3)
All times are GMT -4. The time now is 10:44 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy