in reply to Re^3: Excel To Tab Delimited using Spreadsheet::ParseExcel
in thread Excel To Tab Delimited using Spreadsheet::ParseExcel

I removed 3 lines from the script and it is working. The first 2 -
$value =~ s/^\s+//; $value =~ s/\s+$//;
, I understand, strips off spaces from beginning and end. The third line I removed
$value = " " if $value ne "0" && !$value;
, what does that do? I wanted to ensure I did not remove a line that 'should' be in there.

Replies are listed 'Best First'.
Re^5: Excel To Tab Delimited using Spreadsheet::ParseExcel
by Anonymous Monk on Feb 28, 2015 at 14:33 UTC
    $value = " " if $value ne "0" && !$value; what does that do?

    The code means: Set $value to " " if "$value" is something other than the string "0" (Equality Operators) and also $value is false (Truth and Falsehood).