Posted by Jim Michaels on 11/17/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
>

• Next in forum: Re: mysql_fetch_array and table aliases
• Prev in forum: Re: help understanding an ereg expression
• Thread view: Re: Help with regular expression

[Reply to this message]