Security & Virus | Hardware | Windows XP | Windows Vista | PC Gaming

akw unique query

Comment:

Looking for an AWK solution to pull out unique entries on $1. If multiple occurences exist the rule is to examine the second field and print the line with the greatest numeric, as illustrated by the sample data below: Input aa:10:123 aa:18:123 aa:11:123 aa:10:123 bb:50:10 cc:11:00 bb:49:00 Output aa:18:123 bb:50:10 cc:11:00

Name: ghostdog
Date: September 14, 2008 at 19:45:14 Pacific

Reply:

awk -F":" '{ if ( arr[$1] < $2 ) { arr[$1]=$2 } else { arr[$1] } } END{ for(i in arr) { print arr[i],i } }' file

0

Reply:

That's great ghostdog. Many thanks for your assistance.

0

C Structure

shell script code for fil...

Post Locked

This post is quite old and has been locked from receiving new replies. Please create a new posting instead.

Summary: Dear All, I currently have a data structure that has been taken from a database with the relevant bits looking like this: Survey 1..* SurveyEvent 1..* Sample 1..* SampleSpecies. Survey's key is 'Surve...

Summary: Running "Select DISTINCT from logins" in Query Analyzer returns the entire column, just as you indicated: ID ID ID ... I need to retrieve only the ID of the row just inserted, not the entire column. I...

Summary: Hello, I have two tables, one with only phone numbers and the 2nd has Names, Addresses, and Phone Numbers. I need to run a query to see if any of the phone numbers in Table2 match those in Table1. ...