RE: Comparing fields in 2 large files

2008-06-11 Thread Ferry, Craig
Hi Craig Please keep your responses to the perl.beginners group so that others can both provide input as well as learn from your experience. Thanks. I suggest you stick with Perl but process the data directly from the database. Take a look at the DBI module, which isn't a standard one and so may

Comparing fields in 2 large files

2008-06-11 Thread Ferry, Craig
I am new to perl and would appreciate any suggestions as to how to do the following. I have two files, one with 3.5 million records, the other with almost a million records. Basically here's what I need to do. See if field_1 in file_a is part of field_1 in file_b If so, see if field_2 in file_a