I have about 10-20K records and only need certain cities. I would like to make this work in perl but i can't seem to find an example of just what i need. searchme.csv and list.csv if city is found delete record/row. I was sorting and splitting the screen but now there is just way to many to hand pick out. Please any help would be much appreciated. Im only a nueb.

list.csv contains 1 row with header 'city' and 50+ rows of the cities that I want to keep.

So for each row in searchme.csv get the 'city' into a $variable and loop thru the list.csv if match found write the full row from searchme.csv to new file new.csv. the more i play with this i got it to loop over the searchme.csv, i think i need to load the cities.csv into and array and loop thru the array within the while loop. and if found print to new.csv.

I'm a little confused by your description. Could you re-write your description as a numbered list of steps?
–
DavidAug 20 '12 at 19:45

i'm trying to compare 1 *.csv to another the csv doc being compared is only going to have a list of cities that i want to keep and if it's not on the list remove it. I was looking around and Yes squiguy i have been playing with Text::CSV but now i was looking and i found this
–
Steven GAug 21 '12 at 0:15