<P> tags added by GrandFather to improve readability

No you broke my post and the monastery ate the brackets!
It's supposed to look like this, please stop editing lol: 

$t[6] means the 7th item of the array @t. But you 
declared my @t=(',',$_); which only has 2 items 
($t[0] and $t[1]). So when you try $t[6] eq "CA" 
then perl says it's uninitialized because that 
item does not exist in that list.

The code you posted makes no sense. Try to start 
from scratch and organize your thoughts, using 
pen and paper if necessary, before and while 
writing the code. You're making some progress. 
Keep trying, and organize your code:

    my $input   = 'SRC185.xlsx';
    my $output  = 'Output2022.xlsx';

    my $workbook  = Excel::Writer::XLSX->new( $output );   
    my $worksheet = $workbook->add_worksheet('List');
    my $rowCount  = 0;

    open my $FH, '<', $input or die "Can't open $input: $!";

[download]

In reply to Re^2: Parsing error by Anonymous Monk
in thread Parsing error by MoodyDreams999

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.