Fastolfe: about hashes, I did that first, and then realized (or thought) that it would be a mess to transfer the hash into an anonymous array as needed by write_row.

As to your other suggestion, I will try it out. Hmm.. how do you us WriteExcel to give it tabbed data? It comes with a tab2xls.pl file, so I figured you have to use that. I tried just giving it an array, then a filehandle, but that doesn't work. I'll just stick with what I had unless someone knows a better way.

HOWEVER, I figured out what was wrong. Originally to solve the problem where a couple of conditions had a letter missing/one wrong letter, I used regular expressions in the @cats array. So I had a =~ instead of an eq. However, when I changed this to add the substitution I kept the =~ regex bind in, thinking "nothing will go wrong". WELL, HOW WRONG I WAS! It was matching strings I wanted another category to match (i.e., only part of the string matched, but still true result returned). I put an 'eq' there and it works perfectly (well, there's still some bugs I'm chasing down)

In reply to Re: Use of uninitialized value in array element by dimmesdale
in thread Use of uninitialized value in array element by dimmesdale

Title:
Use:  <p> text here (a paragraph) </p>
and:  <code> code here </code>
to format your post, it's "PerlMonks-approved HTML":


  • Posts are HTML formatted. Put <p> </p> tags around your paragraphs. Put <code> </code> tags around your code and data!
  • Titles consisting of a single word are discouraged, and in most cases are disallowed outright.
  • Read Where should I post X? if you're not absolutely sure you're posting in the right place.
  • Please read these before you post! —
  • Posts may use any of the Perl Monks Approved HTML tags:
    a, abbr, b, big, blockquote, br, caption, center, col, colgroup, dd, del, details, div, dl, dt, em, font, h1, h2, h3, h4, h5, h6, hr, i, ins, li, ol, p, pre, readmore, small, span, spoiler, strike, strong, sub, summary, sup, table, tbody, td, tfoot, th, thead, tr, tt, u, ul, wbr
  • You may need to use entities for some characters, as follows. (Exception: Within code tags, you can put the characters literally.)
            For:     Use:
    & &amp;
    < &lt;
    > &gt;
    [ &#91;
    ] &#93;
  • Link using PerlMonks shortcuts! What shortcuts can I use for linking?
  • See Writeup Formatting Tips and other pages linked from there for more info.