I'm curious as to why you ended up in this situation to begin with.

  1. Why do you need to have them split that way? (What is the ultimate goal you're trying to achieve using that data?)

  2. Do you have any control over how the initial data is structured? Smarter data structures make for easier maintenance.

I know this isn't the "answer" you were looking for, but if you can change the format of the data to something easier to work with, or if you can solve your problem without even having to parse it the way you think you need to, your maintenance programmer will thank you.

In reply to Re: Splitting a comma-delimited string where a substring could countain commas by mothra
in thread Splitting a comma-delimited string where a substring could contain commas by Eisbar

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.