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
Tree::Simple::VisitorFactory(3pm)			User Contributed Perl Documentation			 Tree::Simple::VisitorFactory(3pm)

NAME
Tree::Simple::VisitorFactory - A factory object for dispensing Visitor objects SYNOPSIS
use Tree::Simple::VisitorFactory; my $tf = Tree::Simple::VisitorFactory->new(); my $visitor = $tf->get("PathToRoot"); # or call it as a class method my $visitor = Tree::Simple::VisitorFactory->getVisitor("PathToRoot"); DESCRIPTION
This object is really just a factory for dispensing Tree::Simple::Visitor::* objects. It is not required to use this package in order to use all the Visitors, it is just a somewhat convienient way to avoid having to type thier long class names. I considered making this a Singleton, but I did not because I thought that some people might not want that. I know that I am very picky about using Singletons, especially in multiprocess environments like mod_perl, so I implemented the smallest instance I knew how to, and made sure all other methods could be called as class methods too. METHODS
new Returns an minimal instance of this object, basically just a reference back to the package (literally, see the source if you care). get ($visitor_type) Attempts to load the $visitor_type and returns an instance of it if successfull. If no $visitor_type is specified an exception is thrown, if $visitor_type fails to load, and exception is thrown. getVisitor ($visitor_type) This is an alias of "get". AVAILABLE VISITORS
This distibution provides a number of Visitor objects which can be loaded just by giving their name. Below is a description of the available Visitors and a sort description of what they do. I have attempted to classify the Visitors into groups which are related to their use. This factory will load any module contained inside the Tree::Simple::Visitor::* namespace. Given a name, it will attempt to "require" the module Tree::Simple::Visitor::<Name>.pm. This allows others to create Visitors which can be accessed with this factory, without needed to include them in this distrobution. Search/Path Related Visitors PathToRoot Given a Tree::Simple object, this Visitor will find the path back to the tree's root node. FindByPath Given a path and Tree::Simple hierarchy, this Visitor will attempt to find the node specified by the path. FindByUID Given a UID and Tree::Simple hierarchy, this Visitor will attempt to find the node with the same UID. FindByNodeValue Given a node value and Tree::Simple hierarchy, this Visitor will attempt to find the node with the same node value. Traversal Visitors BreadthFirstTraversal This implements a breadth-first traversal of a Tree::Simple hierarchy. PostOrderTraversal Post-order traversal is a variation of the depth-first traversal in which the sub-tree's are processed before the parent. PreOrderTraversal Pre-order traversal is a depth-first traversal method in which the sub-tree's are processed after the parent. FileSystem Visitors LoadDirectoryTree This visitor can be used to load a directory tree into a Tree::Simple hierarchy. CreateDirectoryTree This visitor can be used to create a set of directories and files from a Tree::Simple object hierarchy. Conversion Visitors FromNestedArray Given a tree constructed from nested arrays, this Visitor will create the equivalent Tree::Simple heirarchy. ToNestedArray Given a Tree::Simple heirarchy, this Visitor will create the equivalent tree constructed from nested arrays. FromNestedHash Given a tree constructed from nested hashs, this Visitor will create the equivalent Tree::Simple heirarchy. ToNestedHash Given a Tree::Simple heirarchy, this Visitor will create the equivalent tree constructed from nested hashes. Reflective Visitors LoadClassHierarchy Given a class name or instance, this Visitor will create a Tree::Simple hierarchy which models the classes inheritance heirarchy. Misc. Visitors GetAllDescendents Given a Tree::Simple instance this Visitor will return all the descendents recursively on down the hierarchy. Sort This implements a multi-level sort of a Tree::Simple heirarchy. VariableDepthClone A Visitor for cloning parts of Tree::Simple hierarchy BUGS
None that I am aware of. Of course, if you find a bug, let me know, and I will be sure to fix it. CODE COVERAGE
I use Devel::Cover to test the code coverage of my tests, below is the Devel::Cover report on this module test suite. -------------------------------------------- ------ ------ ------ ------ ------ ------ ------ File stmt branch cond sub pod time total -------------------------------------------- ------ ------ ------ ------ ------ ------ ------ Tree/Simple/VisitorFactory.pm 100.0 100.0 n/a 100.0 100.0 0.4 100.0 Tree/Simple/Visitor/BreadthFirstTraversal.pm 100.0 100.0 66.7 100.0 100.0 2.5 96.3 Tree/Simple/Visitor/PostOrderTraversal.pm 100.0 100.0 77.8 100.0 100.0 1.7 96.3 Tree/Simple/Visitor/PreOrderTraversal.pm 100.0 n/a 33.3 100.0 100.0 0.7 90.5 Tree/Simple/Visitor/CreateDirectoryTree.pm 100.0 85.7 86.7 100.0 100.0 3.4 95.8 Tree/Simple/Visitor/LoadClassHierarchy.pm 100.0 73.1 33.3 100.0 100.0 4.9 89.2 Tree/Simple/Visitor/LoadDirectoryTree.pm 100.0 89.3 85.2 100.0 100.0 26.1 94.7 Tree/Simple/Visitor/FindByNodeValue.pm 100.0 100.0 86.7 100.0 100.0 3.1 98.3 Tree/Simple/Visitor/FindByPath.pm 100.0 100.0 66.7 100.0 100.0 1.2 97.9 Tree/Simple/Visitor/FindByUID.pm 100.0 100.0 86.7 100.0 100.0 2.9 98.3 Tree/Simple/Visitor/GetAllDescendents.pm 100.0 100.0 77.8 100.0 100.0 2.3 97.1 Tree/Simple/Visitor/PathToRoot.pm 100.0 87.5 75.0 100.0 100.0 0.8 95.1 Tree/Simple/Visitor/Sort.pm 100.0 100.0 77.8 100.0 100.0 8.8 98.1 Tree/Simple/Visitor/ToNestedArray.pm 100.0 100.0 66.7 100.0 100.0 1.5 96.5 Tree/Simple/Visitor/ToNestedHash.pm 100.0 100.0 66.7 100.0 100.0 1.4 96.5 Tree/Simple/Visitor/FromNestedArray.pm 100.0 94.4 81.8 100.0 100.0 8.1 96.6 Tree/Simple/Visitor/FromNestedHash.pm 100.0 91.7 77.8 100.0 100.0 4.8 95.9 Tree/Simple/Visitor/VariableDepthClone.pm 100.0 100.0 66.7 100.0 100.0 25.5 97.3 -------------------------------------------- ------ ------ ------ ------ ------ ------ ------ Total 100.0 93.8 76.3 100.0 100.0 100.0 96.1 -------------------------------------------- ------ ------ ------ ------ ------ ------ ------ SEE ALSO
These Visitor classes are meant to work with Tree::Simple hierarchies, you should refer to that module for more information. AUTHOR
stevan little, <stevan@iinteractive.com> COPYRIGHT AND LICENSE
Copyright 2004, 2005 by Infinity Interactive, Inc. <http://www.iinteractive.com> This library is free software; you can redistribute it and/or modify it under the same terms as Perl itself. perl v5.10.1 2005-11-28 Tree::Simple::VisitorFactory(3pm)
All times are GMT -4. The time now is 08:41 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy