UNIX for Dummies Questions & Answers

Hi,
I have a semi colon delimited file of following layout:
FName;Email;LName;Age

eg.

Simon;simon@email.com;Pat;30
Pat;pat@simon@email.com;Simon;25
Sachin;sachin@email.com;Kambli;44


I want to get all records with a particular FName as Simon and LName Pat How do I dowit?

(Also, my file contains 150K record, so performance is also to be considered!)


Thanks in Advance!

One way:
awk -F\; '$1 == "Simon" && $3 == "Pat"' < file
Make sure you get the quoting right... Pat is followed by a double quote then a single quote.

Thanks for the reply.

Also, there is possibility of two words in FName and LName.
And "Van Ronney" and "VanRonney" should be considered same.
(This check should be put only on FName and LName fields.)

Help Please!

Python alternative:

Code:

for line in open("test.txt"):
 	lline = line.strip().split(";")
 	fname , lname = lline[0].replace(" ","").lower(), lline[2].replace(" ","").lower()
	if fname == 'vanronney' and lname == 'peter':
		print line

Just to extend this a little:

Code:

name1=Simon
name2=Pat
awk -F\; -v name1=$name1 -v name2=$name2 '$1 == name1 && $3 == name2'  < file