Text::CSV::Simple does a great job of ignoring the first column of each line (which is not needed)

Your code ignores the first two columns, because the columns are numbered from zero.

I don't quite understand your overall goal, but this should help: 

#!/usr/bin/perl -w
use strict;
use Text::CSV::Simple;

my $parser = Text::CSV::Simple->new;
$parser->want_fields(1, 2, 3, 4);
my @data = $parser->read_file(\*DATA);
foreach my $line (@data)
{
   if ($line->[0] =~ m/SMTP:/i)
   {
      print "here are the parts of the first column:\n";
      my @parts_of_first_column = split(';', $line->[0]);
      foreach my $part (@parts_of_first_column)
      {
         print " * $part\n";
      }
   }
}
__DATA__
"CN=MBX_MANA,OU= Mailboxes,DC=doman,DC=com",SMTP:Manager@domain.com;sm
+tp:MBX_MANA@domain.com;FAX:MBX_MANA@domain.com;X400:c=us\;a= \;p=doma
+in\;o=Exchange\;s=MANAGER\;,MBX_MANA,/o=Exchange Org/ou=First Adminis
+trative Group/cn=Configuration/cn=Servers/cn=SERVER
"CN=Guest,CN=Users,DC=domain,DC=com",,Guest,

[download]

Which prints out: 

here are the parts of the first column:
 * SMTP:Manager@domain.com
 * smtp:MBX_MANA@domain.com
 * FAX:MBX_MANA@domain.com
 * X400:c=us\
 * a= \
 * p=domain\
 * o=Exchange\
 * s=MANAGER\

[download]

So Text::CSV::Simple splits up the CSV in a smart way, and then the code splits up the first (remaining) column by semicolons. From there on you should be able to test each part for the stuff you want.


($_='kkvvttuu bbooppuuiiffss qqffssmm iibbddllffss')
=~y~b-v~a-z~s; print

In reply to Re: Best method of munging CSV data - using Text::CSV::Simple? by Cody Pendant
in thread Best method of munging CSV data - using Text::CSV::Simple? by billie_t

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.