Re: Comparing fields in 2 large files

2008-06-11 Thread Rob Dixon
Ferry, Craig wrote: >> >> 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, whi

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

Re: Comparing fields in 2 large files

2008-06-11 Thread Rob Dixon
Ferry, Craig wrote: > > My original data is in a database. I did really mean that field 1 in > file a could be any part of field 1 in file b. I also forgot to > mention that in addition to it being in any part of field 1 of file b, I > have to strip out special characters from file b before do

Re: Comparing fields in 2 large files

2008-06-11 Thread Rob Dixon
Ferry, Craig wrote: > > 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 fi