absolutely: here is the first 10 lines of text: http://pastebin.com/R8E6jVhs

Here is the code:

#! c:\program files\perl\bin use DBI; my $csv="viewmanifest.csv"; $dbh=DBI->connect('DBI:CSV:$csv') or die "Can't Connect"; $sth=$dbh->prepare("SELECT RowId, dahandle, darelativepath, dafilestat +e, dafilestatetime, dafilesource, fileguid, size, filemd5, child, chi +ldtype, childhandle, container, containerfolder, maghandle, mailconta +inererror, mailcontainer, mailfolder, mailfolderpath, contentmd5, cre +atedtime, datescanned, embeddedchildren, docclass, handle, docnum, os +folder, filename, docext, origdocext, filemode, fullpath, filetype, a +uxfiletype, lastaccesstime, lastmodifiedtime, lastchangetime, mimetyp +e, kftdesc, ocrpath, ocrstatus, ownergroup, owneruser, acls, parent, +parsingstatus, parserversion, altbody, importpath, importdevice, impo +rtarea, ancestordahandle, depotfile, inode, batch FROM $csv") or die +"Can't prepare"; $sth->execute(); $sth->dump_results(); $sth->finish(); $dbh->disconnect();

Here are the results for the first line (notice the ellipses)

'0', '000083e0143381bbe8db4b0db7baa5...', 'vmi/v920m3/weekly.20091014/pro...', 'imported', '2011-04-15-21-00-51', '000083e0143381bbe8db4b0db7baa5...', '', '0000000000000063906', 'a088be10e6f02f614385fa19628cfb6f', '', '', '', '', '', '', '', '', '', '', '', '', '2011-04-15-21-00-51', '', 'loose', 'a088be10e6f02f614385fa19628cfb...', '', 'vmi/v920m3/weekly.20091014/pro...', 'en_X11.xml', 'xml', '', '33188', '', 'extensible markup language (xml)', '', '2009-10-15-19-15-34', '2009-10-15-19-15-49', '2009-10-15-19-15-49', '', '', '', '', '100', '13936', '', '', '00000 SUCCESS', '3.4;3.4', '', '000083e0143381bbe8db4b0db7baa5...', '', '', '', '', '32457187', 'f8023f8fc92a4fc4'

Other things of note, could have unicode filenames...


In reply to Re^2: DBD::CSV and long fields (LongReadLen not supported?) by zyzzogeton
in thread DBD::CSV and long fields (LongReadLen not supported?) by zyzzogeton

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.