I am pulling data out of a .csv file and doing a calculation, then putting the data into an excel file. I tried the following:
if(@$data[$i]->{"Date1"} eq "" || @$data[$i]->{"Date2"} eq ""){
### getting error from above line
$days = "N/A";
}
else{
my $t1 = Time::Piece->strptime(@$data[$i]->{"Date1"},"%m/%d/%Y");
my $t2 = Time::Piece->strptime(@$data[$i]->{"Date2"},"%m/%d/%Y");
$days = $t2 - $t1;
$days = int($days->days);
}
$ws->write(1, $i+1, $i+1, $colhdr);
I am getting an error saying that it is an un-initialized variable in the string where marked. The program still runs and gives me the file I want, but I just want to understand and get rid of the error.
Thanks for the input FYI, I am debugging in Komodo IDE
Thanks everyone for input. I found the error. It was in my .csv file. There were a few blank lines so they didn't get the comma separation. After deleting the lines, the error went away and the program works. Thanks again though :)
-
Are you posting in the right place? Check out Where do I post X? to know for sure.
-
Posts may use any of the Perl Monks Approved HTML tags. Currently these include the following:
<code> <a> <b> <big>
<blockquote> <br /> <dd>
<dl> <dt> <em> <font>
<h1> <h2> <h3> <h4>
<h5> <h6> <hr /> <i>
<li> <nbsp> <ol> <p>
<small> <strike> <strong>
<sub> <sup> <table>
<td> <th> <tr> <tt>
<u> <ul>
-
Snippets of code should be wrapped in
<code> tags not
<pre> tags. In fact, <pre>
tags should generally be avoided. If they must
be used, extreme care should be
taken to ensure that their contents do not
have long lines (<70 chars), in order to prevent
horizontal scrolling (and possible janitor
intervention).
-
Want more info? How to link
or How to display code and escape characters
are good places to start.
|