From: "BK GOOD" <[EMAIL PROTECTED]>
> The TEXT::CSV_XS module has problems parsing delimited files with
> funny characters, binary data or missing quotes. It will blank out
> the records. Does anyone know of another module for parsing delimited
> files that can handle this type of data?
>
> Thanks!
> Kristi
perldoc Text::CSV_XS
new(\%attr)
(Class method) Returns a new instance of Text::CSV_XS. The
objects
attributes are described by the (optional) hash ref "\%attr".
Currently the following attributes are available:
...
binary If this attribute is TRUE, you may use binary
characters in
quoted fields, including line feeds, carriage returns
and
NUL bytes. (The latter must be escaped as ""0".) By
default
this feature is off.
This should take care of the funny characters/binary data.
If the data are not proper CSV and are missing quotes you'll most
probably have to handle those yourself.
Or use Text::CSV_XS like this:
...
if ($csv->parse($line)) {
my @columns = $csv->fields();
# do something with the data
} else {
my $bad_line = $csv->error_input();
# do something about the incorrectly formated line
}
HTH, Jenda
===== [EMAIL PROTECTED] === http://Jenda.Krynicky.cz =====
When it comes to wine, women and song, wizards are allowed
to get drunk and croon as much as they like.
-- Terry Pratchett in Sourcery
--
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
