Re: Multiple file handles

If the reason you used a spreadsheet was because it was the easiest way for you to edit the data, and your actual question here is "what is the easiest way to pull data from a spreadsheet into Perl", I will suggest my Data::TableReader which can easily extract some columns of a spreadsheet into perl hashrefs (one per row) which you can then use in any algorithm you like, such as suggested by others here.

Comment on Re: Multiple file handles

Replies are listed 'Best First'.
Re^2: Multiple file handles by MoodyDreams999 (Beadle) on Apr 07, 2023 at 21:33 UTC
OMG that module would of made my life so much easier months ago!!! Thank you!	[reply]
Re^3: Multiple file handles by BillKSmith (Monsignor) on Apr 08, 2023 at 15:44 UTC
Be aware that even five-digit zip codes do not always tell what state a person lives in. I once had a boss who lived in New Jersey. (Paid state and local taxes in NJ. Had a NJ drivers license) But, he had a New York mailing address (both the zip cope and the "NY"). His zip code physically included a small part of NJ. Bill	[reply]
Re^4: Multiple file handles by LanX (Saint) on Apr 08, 2023 at 15:57 UTC
To add an international case, some German villages like Buesingen are exclaves surrounded by Swiss territory. They have two sets of ZIP codes and the official local currency are Swiss francs not euros. You'll find plenty of more examples for such bi-national spots on Wikipedia, like Austrian mountain valleys which are only accessible by street from Germany, and so on... In the end you will always need look-up tables to cover exceptions in the system. Cheers Rolf _{(addicted to the 𐍀𐌴𐍂𐌻 Programming Language :) Wikisyntax for the Monastery}	[reply]
Re^4: Multiple file handles by AnomalousMonk (Archbishop) on Apr 08, 2023 at 23:54 UTC
For more info on state ZIP-code insurgency in the USA, see the file noted in the update of tybalt89's reply. Give a man a fish: `<%-{-{-{-<`	[reply] [d/l]


Come for the quick hacks, stay for the epiphanies.
	PerlMonks