in reply to Re: This looks like whitespace in my CSV but doesn't seem to be
in thread This looks like whitespace in my CSV but doesn't seem to be

Text:CSV_XS has a native builtin way to delete trailing and leading whitespace:

my $csv= text::CSV_XS->new ({ binary => 1, allow_whitespace => 1, auto +_diag => 1 });

But that would not help in this case for two reasons

Spreadsheet::Read however offers to strip leading and trailing whitespace from every field. I could extend that on request to allow it to strip Unicode whitespace too.

strip If set, "ReadData ()" will remove trailing- and/or leading- whitespace from every field. strip leading strailing ----- ------- --------- 0 n/a n/a 1 strip n/a 2 n/a strip 3 strip strip

Enjoy, Have FUN! H.Merijn

Replies are listed 'Best First'.
Re^3: This looks like whitespace in my CSV but doesn't seem to be
by Marshall (Canon) on Oct 05, 2012 at 01:38 UTC
    This sounds just fine.

    I haven't worked with any CSV files with leading spaces. That idea appears to be uncommon. But your suggestion sounds good.