Posted by Jim Michaels on 10/23/33 11:39

([cC][oO][nN][cC][aA][tT]\s\(.*\)\s[aA][sS])?\s*(\w+\d+)|,([cC][oO][nN][cC][aA][tT]\s\(.*\)\s[aA][sS])?\s*(\w+\d+){1,}

the problem with doing this is that you are going to get CONCAT AS (...) as
one of your array elements, so just delete it or detect and ignore it.
you can always detect it with preg_match("/^CONCAT/",$string);


"Tony Marston" <tony@NOSPAM.demon.co.uk> wrote in message
news:dqe547$90c$1$8300dec7@news.demon.co.uk...
>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
>

[Back to original message]