There are several SQL split functions, from loop driven, to using xml commands, and even using a numbers table. I haven't found one that supports text qualifiers.
Using the example string below, I would like to split on ",", but not when it appears between double or single quotes.
Example data:
[email protected], "Sally \"Heat\"
Jones" <
[email protected]>, "Mark
Jones" <
[email protected]>, "Stone, Ron" <
[email protected]>
Should return a table:
[email protected]
"Sally \"Heat\"
Jones" <
[email protected]>
"Mark
Jones" <
[email protected]>
"Stone, Ron" <
[email protected]>
I know this is a complex query/function, but any suggestions or any guidance would be mucho appreciated.