in reply to How can I read a file that is comma delimited but includes a comma in the string?

If these conditions are met:
  1. There are always 5 Fields
  2. Additional commas only appear in the fifth field
    3. then this code will give you the desired result: 
    while ($line=<DATA>) {
    chomp $line;
    ($char, $num1, $num2, $num3, $commafield)=split(/,/,$line,5);
    print <<MYDATA;
$char
$num1
$num2
$num3
$commafield
-------
MYDATA
}
__DATA__
R,2164,27-2164,270102,Add Terminal Server to John, Jane, and Georges
$,1111,22-2222,333333,Ignore mails from support, microsoft or bill

    [download]
    • Comment on Re: How can I read a file that is comma delimited but includes a comma in the string?
    • Download Code

In Section Seekers of Perl Wisdom