in reply to DBD::CSV and Macperl

Hello, I believe the default is CRLF, so for Mac you may need this line: $dbh->{'csv_eol'} = "\015"; # lines end with ctrl-m Some other notes.. Vertical tabs, binary/two-byte code, and Excel may also mess up your data. I rebuilt SQL-HTML to use the DBD::CSV SQL wrapper for a couple projects of mine, and had to deal with unsupported functions, so careful of other SQL commands you might take for granted like list tables. Also you might also include "use Text::CSV_XS" (changing the default field separator to the pipe symbol) for direct manipulation routines but I found the quote methods to be spooky especially with Japanese data. Always safer to roll your own. Hope this helps, Matt Rosin

Replies are listed 'Best First'.
RE: RE: DBD::CSV and Macperl
by mattr (Curate) on Sep 01, 2000 at 07:31 UTC
    P.S.

    Sorry about the lack of html formatting. Wanted to mention I might have found a bug in timing of writes to the disk, as I had trouble selecting all records to find the highest record number when automatically generating a new record number. This was solved by using a separate text file to store the highest record number.

    Matt