I recently had a similar task of having to organize CSV files. I originally started out using DBD::CSV because I wanted the SQL like access to the information. However, I ended up using Text::CSV_XS. I did this for a number of reasons.

The first reason was that I was also able to use Text::CSV::Simple which allowed me an easy interface (since many of the CSV files I was working with had less than 15 columns in them). I also used it because it has a simple straightforward interface to handle quoted delimiters (ex. val1,val2,"val,3",val4) which is something I needed.

You weren't specific as to what you were using it for, but if you are just merging CSV files, some of the modules are very useful (at least they were for what I needed them for).

In reply to Re: dbi:csv how to by madbombX
in thread dbi:csv how to by zli034

Title:
Use:  <p> text here (a paragraph) </p>
and:  <code> code here </code>
to format your post, it's "PerlMonks-approved HTML":


  • Posts are HTML formatted. Put <p> </p> tags around your paragraphs. Put <code> </code> tags around your code and data!
  • Titles consisting of a single word are discouraged, and in most cases are disallowed outright.
  • Read Where should I post X? if you're not absolutely sure you're posting in the right place.
  • Please read these before you post! —
  • Posts may use any of the Perl Monks Approved HTML tags:
    a, abbr, b, big, blockquote, br, caption, center, col, colgroup, dd, del, details, div, dl, dt, em, font, h1, h2, h3, h4, h5, h6, hr, i, ins, li, ol, p, pre, readmore, small, span, spoiler, strike, strong, sub, summary, sup, table, tbody, td, tfoot, th, thead, tr, tt, u, ul, wbr
  • You may need to use entities for some characters, as follows. (Exception: Within code tags, you can put the characters literally.)
            For:     Use:
    & &amp;
    < &lt;
    > &gt;
    [ &#91;
    ] &#93;
  • Link using PerlMonks shortcuts! What shortcuts can I use for linking?
  • See Writeup Formatting Tips and other pages linked from there for more info.