Remove lines from a file based on a second file

[Anonymous Monk]

Greetings, I've got two files - a long CSV file, and another long file with a list of values in it. I need to remove from the long CSV file all of the entries where field 2 in the CSV matches any value in the long file. I can see loading the two into perl arrays, but I'm hoping there is a way to do this without two nested loops inside the perl script. Any suggestions? Thanks

[AR]

Could you adapt the advice given in this node?

[wwe]

In general first read the file with values into a hash using values as hash keys then loop over the csv file and skip every value which matches a key in a hash. We'll be happy to help you when you show us your code.

[Anonymous Monk]

load files with DBD::CSV, issue appropriate sql query, be done in time for dinner