There is a standard solution to this problem, mostly from Mastering Regular Expressions: 

# You need to match a double quoted string with the following regex
# [^"\\]*(\\.[^"\\]*)*",?
#
# But to get the text between double quotes use some ( )
# ([^"\\]*(\\.[^"\\]*)*)",?
# gets text inside quotes as $1
#
# but you also have non quoted fields, thus
# ([^,]+),?
# which should match things optionally followed by a comma
#
# and then a match for separation commas
# ,
#
# this must be repeated with m/.../g

[download]

Before attempting this yourself, take at look at Text::ParseWords and the quotewords routine. This should solve your problem. If the module is not available to you then the following untested code from Mastering Regular Expressions should work: 

@fields = ();
while ($text =~ m/"([^"\\]*(\\.[^"\\]*)*)",?|([^,]+),?|,/g {
push (@fields, defined ($1) ? $1 : $3) ;
}
push (@fields, undef) if $text =~ m/,$/; # Account for the special cas
+e of an empty last field.

# all data is now in @fields

[download]

Note: untested.


SciDude
The first dog barks... all other dogs bark at the first dog.

In reply to Re: Regex Conundrum by SciDude
in thread Regex Conundrum by jblakey

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.