Re: Writing Program With Hashes and Loops For Files With Data in Columns

in reply to Writing Program With Hashes and Loops For Files With Data in Columns

Best help I know how to give, for now: Give us a bit more crucial information.

Are the data files made up of fixed length fields, CSV or TSV ... or something else?
Is there a data-base involved? If so, it may be that using the DBs capabilities would help

That information would help us to help you

If you didn't program your executable by toggling in binary, it wasn't really programming!

Comment on Re: Writing Program With Hashes and Loops For Files With Data in Columns

Replies are listed 'Best First'.
Re^2: Writing Program With Hashes and Loops For Files With Data in Columns by Anonymous Monk on Mar 05, 2013 at 16:32 UTC
Thank you for both replying. I am not using a database (that I know of). The files with the names are text files, and the columns are separated by a space. (A space is the delimiter.) I appreciate your time.	[reply]
Re^3: Writing Program With Hashes and Loops For Files With Data in Columns by ww (Archbishop) on Mar 05, 2013 at 18:07 UTC
It may be worth considering dumping the milcar file into an SQLite database, using Perl to get your data from file2, and then using the modules `DBI` & `DBD::SQLite` along with SQL's native functions to find db-matches against file2's fname, lname. That's not to claim I'm sufficiently expert with dbs to guarantee that this is the best approach but -- based on limited experience with (mostly) toy-applications -- it looks pretty plausible to me and DBI and DBD::SQLite will make the learning curve much shallower while the SQL capabilities can handle most of your search, sort and write requirements. If you didn't program your executable by toggling in binary, it wasn't really programming!	[reply] [d/l] [select]

In Section Seekers of Perl Wisdom