Posted by Tony Marston on 01/15/06 20:43

I am seeking help with a regular expression that will split a string into
several parts with ',' (comma) as the separator, but NOT where the separator
is enclosed in parentheses. For example, take the string "field1,
CONCAT(field2,' ', field3) as field23, field4". I would like to be able to
split this into the following:
[0] field1
[1] CONCAT(field2,' ', field3) as field23
[2] field4

Thanks in advance.

--
Tony Marston
http://www.tonymarston.net

• Next in forum: Help with regular expression
• Prev in forum: Help with regular expression
• Thread view: Help with regular expression

[Reply to this message]