Re^3: Excel To Tab Delimited using Spreadsheet::ParseExcel

Replies are listed 'Best First'.
Re^4: Excel To Tab Delimited using Spreadsheet::ParseExcel by Anonymous Monk on Feb 26, 2015 at 16:03 UTC
I removed 3 lines from the script and it is working. The first 2 - `$value =~ s/^\s+//; $value =~ s/\s+$//;` [download] , I understand, strips off spaces from beginning and end. The third line I removed `$value = " " if $value ne "0" && !$value;` [download] , what does that do? I wanted to ensure I did not remove a line that 'should' be in there.	[reply] [d/l] [select]
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).	[reply] [d/l] [select]