Beefy Boxes and Bandwidth Generously Provided by pair Networks
Problems? Is your data what you think it is?

Re: Parsing/manipulating CSV files

by tospo (Hermit)
on Oct 20, 2011 at 22:39 UTC ( #932773=note: print w/replies, xml ) Need Help??

in reply to Parsing/manipulating CSV files

If you are handling the CSV files in Perl, you might also want to do the database interaction with your Perl scripts to keep it all together. It is possible to query/manipulate an MSAccess database from Perl using the DBI module. See DBD::ODBC

Replies are listed 'Best First'.
Re^2: Parsing/manipulating CSV files
by Anonymous Monk on Oct 21, 2011 at 11:00 UTC

    In this particular instance, I'm looking to get rid of any reliance on MsAccess. It's purely accidental that I use Access now; it just happened that I could write the app within Access as a module as it was available at work so I could use their time to write it (and leave more time for beer at home).

    Database connectivity isn't a requirement for this, I want it to stand alone though I can see that it could be useful for future projects.

      If your data collection is large (for any value of large), DBD::CSV might grow (very) slow. For relatively small dtasets, DBD::CSV gives you instant relief: combining CSV files and selecting from one based on contents of others gets dead easy. When the dataset grows, and you still do not need a full relational dtabase like PostgreSQL or MariaDB, DBD::SQLite might be the interface of choice.

      Enjoy, Have FUN! H.Merijn

Log In?

What's my password?
Create A New User
Node Status?
node history
Node Type: note [id://932773]
[stonecolddevin]: o/ planetscape
[Sinistral]: I think that just the sight of his username now causes a downvote storm. I agree, and the gratuitous use of formatting does make reading hard. I've given him +1 on things where there seemed to be actual good advice, but I think the big
[Sinistral]: nail in coffin was the rant against a Schwarzian Transform
[stonecolddevin]: at best, from what i've seen, his knowledge is accurate up to maybe 2002. the sheer volume of words is mostly worthy of a downvote in most cases though i think
[erix]: ITYM Schwartzian Transform :P
[erix]: hey planetscape :)
[planetscape]: howdy stonecolddevin, erix
[Sinistral]: eric Aye. I thought I typed that wrong. All hail Randall! I listen to him on FLOSS Weekly
[Discipulus]: i think his vacuus, trombon like, absence of meaning, joined with a ostentatious style, after many years irritates the most
[erix]: easy to get wrong -- I guess that was sund's point, too :P

How do I use this? | Other CB clients
Other Users?
Others contemplating the Monastery: (10)
As of 2017-06-22 20:56 GMT
Find Nodes?
    Voting Booth?
    How many monitors do you use while coding?

    Results (530 votes). Check out past polls.