Beefy Boxes and Bandwidth Generously Provided by pair Networks
The stupid question is the question not asked
 
PerlMonks  

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

by ww (Bishop)
on Mar 05, 2013 at 15:19 UTC ( #1021843=note: print w/ replies, xml ) Need Help??


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
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.

      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!

Log In?
Username:
Password:

What's my password?
Create A New User
Node Status?
node history
Node Type: note [id://1021843]
help
Chatterbox?
and the web crawler heard nothing...

How do I use this? | Other CB clients
Other Users?
Others cooling their heels in the Monastery: (8)
As of 2014-12-21 05:50 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    Is guessing a good strategy for surviving in the IT business?





    Results (103 votes), past polls