How to sort standard input without first line < Header >


 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting How to sort standard input without first line < Header >
# 1  
Old 03-26-2008
How to sort standard input without first line < Header >

Do somebody have idea How to sort standard input without first line which in my case it's header
Example:
Cnt|VT |STAT|Date |Time |From |Alert Message |Instance |
125| | | 260308 |160026 |ZAMUAT2|ifpollq forZAMUAT2 0 from 1 Processes Found |emeflxci |
125| | | 260308 |160026 |ZAMUAT2|/zam/edlr/bin/ifind forZAMUAT2 0 from 1 Processes Found |emeflxci |
126| | | 260308 |160026 |UGNUAT4|ugn/fts/bin/FTS_SERVER.EXE for UGNUAT4 0 from 4 Processes Found |emeflxci |
121| | | 260308 |160026 |TUNUAT4|tun/switch/bin/ifstart for TUNUAT4 0 from 1 Processes Found |emeflxci |
121| | | 260308 |160026 |TUNUAT4|ifreader_TN for TUNUAT4 0 from 1 Processes Found |emeflxci |
# 2  
Old 03-26-2008
Code:
sed 1d file | sort >output

Reattaching the first line back on is left as an exercise, if you even want that.
# 3  
Old 03-26-2008
This assumes that you want to sort on the first field of the file
Code:
awk 'NR==1; NR > 1 {print $0 | "sort -t\| -n -k 1,1"}' file

# 4  
Old 03-26-2008
I want to sort all lines in input - except first [ header ] but i want header on output also.
Example file:
Time
123
1245
122134
123412
123123
1243123
12334
123123

- Time line is header
- sort by key 1reverse and numeric [ sort -k1rn ]
expected outout:
Time
1243123
123412
123123
123123
122134
12334
1245
123

Last edited by pp56825; 03-26-2008 at 02:20 PM..
# 5  
Old 03-26-2008
If the input file has a single column then you do not need the sort by key 1
Code:
awk 'NR == 1; NR > 1 {print $0 | "sort -nr"}'

# 6  
Old 03-26-2008
this is example, my input contain more then one column
# 7  
Old 03-26-2008
Quote:
Originally Posted by pp56825
this is example, my input contain more then one column
In that case Click here!
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. Homework & Coursework Questions

Removing punctuations from file input or standard input

Just started learning Unix and received my first assignment recently. We haven't learned many commands and honestly, I'm stumped. I'd like to receive assistance/guidance/hints. 1. The problem statement, all variables and given/known data: How do I write a shell script that takes in a file or... (4 Replies)
Discussion started by: fozilla
4 Replies

2. Shell Programming and Scripting

standard input and cron

I have a program that requires the user to enter input values while it is being run for example in bash ... ... .. echo "Enter your input" read input echo $input ... ... ...I need to schedule this program with crontab, hence a problem, cronjobs run in the background, any ideas on how to... (10 Replies)
Discussion started by: walforum
10 Replies

3. Shell Programming and Scripting

Reading from standard input

So, I am new to shell scripting and have a few problems. I know how to read from standard input but I do not know how to really compare it to say, a character. I am trying to compare it to a character and anything exceeding just a character, the user will get an output message, but the program... (7 Replies)
Discussion started by: Bungkai
7 Replies

4. Shell Programming and Scripting

Reading Standard Input

Hello, I am new to scripting. How do I read multiple lines from the command line? I know read reads one line, but if I have to read multiple lines, how should I do? Thanks, Prasanna (4 Replies)
Discussion started by: prasanna1157
4 Replies

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

6. Solaris

standard input

Please give me any example for standard input in Solaris. (6 Replies)
Discussion started by: karman0931
6 Replies

7. UNIX for Dummies Questions & Answers

Sort and uniq lines of a file while keeping a header line

So, I have a file that has some duplicate lines. The file has a header line that I would like to keep at the top. I could do this by extracting the header from the file, 'sort -u' the remaining lines, and recombine them. But they are quite big, so if there is a way to do it with a single... (1 Reply)
Discussion started by: Digby
1 Replies

8. Shell Programming and Scripting

change standard input ?

Dear... I have a scrpit that contains multiple read command.... when I run the script I have to enter 3 variables so that I can get the output.. but, I dont want to put those 3 inputs manually every time... I want to make a shell that reads the 3 inputs from a file. the script name is... (4 Replies)
Discussion started by: yahyaaa
4 Replies

9. Shell Programming and Scripting

How to copy from standard input

I tried copy the output files from find command into a directory. Example, find / -name core 2>/dev/null | xargs cp???? I have known that we can use xargs to execute command lines from standard input but how to use it in this case. Or I can do something besides xargs. (2 Replies)
Discussion started by: lalelle
2 Replies

10. Shell Programming and Scripting

standard input

how can i redirect standard input? i dont remember :/, though could you redirec not from a command? i mean, to redirect always stdin and stout (1 Reply)
Discussion started by: Jariya
1 Replies
Login or Register to Ask a Question