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

MoodyDreams999 has asked for the wisdom of the Perl Monks concerning the following question:

Hey, Monks, I've never done this before, besides referencing from a database in sql to perl. I have a file that will have missing data that I am parsing, I want to populate the State based off the zip codes, so I created spreadsheet with like 80000 zip codes and they state abbr. Could you please give me some guidance on using one file to reference zip codes and based on those to update the state on another external file.