In need of assist....


 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting In need of assist....
# 1  
Old 05-11-2011
In need of assist....

How would i take the output of a file dump it into another file while at the same time sorting it?

this is my script..simple i know!?

PHP Code:
echo "Enter the file log you wish to use. [ENTER]: "
read file
awk 
'{print $1,$2,$4,$5}' $file >> list 
Im trying to dump it into that list file and sort it at the same time..any ideas?
# 2  
Old 05-11-2011
Code:
awk '{print $1,$2,$4,$5|"sort"}' $file >> list  

This User Gave Thanks to yinyuemi For This Post:
# 3  
Old 05-11-2011
Thanks that def. did the trick.. One more question woud there be a way to combine the repeated Ip addresses.
example:
109.86.214.79 - [01/Nov/2010:15:54:36 -0400]
109.86.214.79 - [01/Nov/2010:15:54:45 -0400]
109.86.214.79 - [01/Nov/2010:16:17:15 -0400]
109.86.214.79 - [01/Nov/2010:20:09:37 -0400]
109.86.214.79 - [01/Nov/2010:20:09:41 -0400]
114.58.112.39 - [01/Nov/2010:08:06:08 -0400]
114.58.112.39 - [01/Nov/2010:08:06:09 -0400]
114.58.112.39 - [01/Nov/2010:08:06:10 -0400]
114.58.112.39 - [01/Nov/2010:08:06:10 -0400]
114.58.112.39 - [01/Nov/2010:08:06:10 -0400]
114.58.112.39 - [01/Nov/2010:08:06:10 -0400]

You see how they repeat the ip but the date/time is different is there a way to sort that so it only shows one Ip but multiple dates and time?
ex: 109.86.214.79
[01/Nov/2010:15:54:36 -0400]
[01/Nov/2010:15:54:45 -0400]

114.58.112.39
[01/Nov/2010:08:06:10 -0400]
[01/Nov/2010:08:06:10 -0400]

something like that example
# 4  
Old 05-11-2011
try:
Code:
awk '{a[$1]=a[$1] RS $4 FS $5;b[$1]=$1}END{l=asort(b);for(i=1;i<=l;i++) print b[i],a[b[i]]}' $file >>list

# 5  
Old 05-11-2011
this the error im getting:

awk: line 2: function asort never defined
# 6  
Old 05-12-2011
or try:
Code:
awk '{a[$1]=a[$1] RS $1 FS $3 FS $4}END{for(i in a) {print i,i,a[i]}}' $file |sort -r |cut -d' ' -f2- >>list

This User Gave Thanks to yinyuemi For This Post:
# 7  
Old 05-12-2011
that worked perfect! I appreciate your help! Thank you.
Login or Register to Ask a Question

Previous Thread | Next Thread

7 More Discussions You Might Find Interesting

1. Red Hat

assist me in UNIX scripting

hi ... i want to monitor the httpd service whether its online or offline.. if httpd service goes offline/stopped then i need to get alert to my mail. how to do construct this script.. myself using RHEL4 ... (1 Reply)
Discussion started by: sriniv666
1 Replies

2. Shell Programming and Scripting

Need of a Parsing Script Assist...

Im trying to find a script that will pull ip addresses along with the date and time sort it by ip addresses and output it to a file... As a newbie to scripting im kinda stumped here...and suggestions? (2 Replies)
Discussion started by: jspinal
2 Replies

3. UNIX for Dummies Questions & Answers

Please Assist

I try taip this script below...but i have got error.The error message is Input read error..Anybody can see whether my script have problem.Below this is my script: #!/bin/sh filename=test.txt vi $filename <<EndOfCommands i This file was created automatically from a shell script ^ (1 Reply)
Discussion started by: mastercar
1 Replies

4. Shell Programming and Scripting

New to KSH Scripting > Please Assist!

Array Example: $ colors=RED $ colors=GREEN $ colors=BLUE (4 Replies)
Discussion started by: ora_umair
4 Replies

5. HP-UX

Assist me in doing certification please

Hi Everybody, Iam new to the unix world but interested a lot to know about unix. i want to do a certification course in unix so can anybody please suggest me what course can i do for unix adminstration and what books do i have to refer to. Thanks in Advance. (5 Replies)
Discussion started by: ajazshariff
5 Replies

6. UNIX for Dummies Questions & Answers

Script Assist

Hello all I am new and I had a question that I was hoping you could answer. I am using mutt on a directory in this directory will be pdf files named 001.pdf , 002.pdf and so on. I need a script that can read the filename and associate that with a user like so : if 001.pdf exists then email... (16 Replies)
Discussion started by: linuxguy30350
16 Replies

7. Programming

could some assist please

i was searching on the net have found a couple of sample programs and was wondering if some could tell me what they do cheers. main() { printf("Executing ls\n"); execl("/bin/ls","ls","-l", (char *)0); perror("execl failed to run ls"); exit(1); } main() { int i; i =... (5 Replies)
Discussion started by: ruffenator
5 Replies
Login or Register to Ask a Question