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

Replies are listed 'Best First'.
Re^3: Excel To Tab Delimited using Spreadsheet::ParseExcel by graff (Chancellor) on Feb 26, 2015 at 04:04 UTC
A similar script that I posted here a couple years prior to the one above preserves empty cells that occur to the left of non-empty cells. (It also handles unicode character content, in case that's relevant.) Here: xls2tsv	[reply]
Re^3: Excel To Tab Delimited using Spreadsheet::ParseExcel by Anonymous Monk on Feb 26, 2015 at 03:27 UTC
use the option that is documented to stop doing that :) (hint, read the "f"riendly docs)	[reply]
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]


Problems? Is your data what you think it is?
	PerlMonks