That's probably possible -- but as is the case with many things that can be done with regexen but which are outside its core utility, it's apt to be awkward, verbose and perhaps fragile.

Better, perhaps, you may wish to study up on the various CSV modules and the many compound data structures available to you -- Array of Arrays; Hash of Arrays, etc. Either approach should work well.

If you Super Search with the terms seen unique you'll find some quite helpful nodes.

PS: Your problem statement implies that you're prepared to abandon the content of the "Effect" column. If that's not so, you'll want to make that clear with an update to your OP.

Update: tweaked first sentence for clarity.

In reply to Re: read a name, recognise a tag and output by ww
in thread read a name, recognise a tag and output by perllearner007

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.