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

by Anonymous Monk

on Feb 26, 2015 at 03:27 UTC ( [id://1117898]=note: print w/replies, xml )

Need Help??

use the option that is documented to stop doing that :) (hint, read the "f"riendly docs)

Comment on 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]

Domain Nodelet^?

Node Status^?

node history
Node Type: note [id://1117898]
help

Chatterbox^?

How do I use this? • Last hour • Other CB clients

Other Users^?

Others about the Monastery: (3)

As of 2024-04-26 00:09 GMT

Sections^?

Information^?

Find Nodes^?

Leftovers^?

Voting Booth^?

No recent polls found