Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Append columns in order based on $1
thanks Feherke & LKBrwnDBA for your suggestions. I'll give it a try unfortunately the unix sort option did not work. cheers all -
Append columns in order based on $1
hi Mikrom, I'll let you know later today. I'm not sure if the sort approach before awk will work given the size of my file (20m+ lines, 8GB size). I'll give it a try. thanks. -
Append columns in order based on $1
Hi Mikrom, unfortunatly the server i'm using is running Solaris and there is no way to update awk with GNU, so the "asort" function does not work. Do you know of another way to sort? thanks. -
Append columns in order based on $1
Thanks Mikrom. i think that'll give me something to go on with. Many thanks. -
Append columns in order based on $1
Hi forum, I've been away from awk in the last few years but have recently come back to it and am struggling [dazed]. Can anyone help with the following? Summary I have a ascii file containing 20million+ lines. The FS = <space> Field 1 is always an accountid. There are multiple lines per... -
awk help counting number of entries per hour
Just looked again at your post PHV and i changed it slightly to; awk -F"," '{split($2,DTM,":");count[$11" "DTM[1]]++}END{for(name in count) printf "%30s - %d\n", name, (count[name]) | "sort -k1" }' This works exactly how i wanted it too, so a big thankyou to you for your help. -
awk help counting number of entries per hour
Thanks for the quick reply PHV. I neglected to say in my original post that im using Solaris I tried running you suggestion but it hit a syntax error; awk: syntax error near line 1 awk: illegal statement near line 1 I also tried running it through "/usr/xpg4/bin/awk" but that also hot an... -
awk help counting number of entries per hour
Hi, I'm struggling trying to put together something to grab out details from many logfiles created over a 24 hour period and count how many times per hour a name appears. I want to run through every hour (i.e. 00,01,02.....23) and print out how many times name 'x' was found. The only fields I'm...
