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
slaqr1.f(3)							      LAPACK							       slaqr1.f(3)

NAME
slaqr1.f - SYNOPSIS
Functions/Subroutines subroutine slaqr1 (N, H, LDH, SR1, SI1, SR2, SI2, V) SLAQR1 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 slaqr1 (integerN, real, dimension( ldh, * )H, integerLDH, realSR1, realSI1, realSR2, realSI2, real, dimension( * )V) SLAQR1 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, SLAQR1 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 REAL 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 REAL SI1 SI1 is REAL SR2 SR2 is REAL SI2 SI2 is REAL The shifts in (*). V V is REAL 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 slaqr1.f. Author Generated automatically by Doxygen for LAPACK from the source code. Version 3.4.2 Tue Sep 25 2012 slaqr1.f(3)

Featured Tech Videos

All times are GMT -4. The time now is 04:43 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy