http://qs1969.pair.com?node_id=778152


in reply to Comparing multiple entries from two files

Have you considered loading the data into a relational DB (SQLite would do just fine) and querying it with SQL? Certainly you could do the job with Perl, but processing significant numbers of rows, coordinating two different datasets based on shared identifiers, and doing filtering based on the joined data is exactly what relational databases were created for.
  • Comment on Re: Comparing multiple entries from two files