Re: Regular expression that splits CSV string into table

I dont mind if the commas are at the beginning and end, im more
concerned about "three,four" staying in one row because its surrounded
by quotes. -Nick

On Sep 10, 6:03 pm, alvhe(dot)(dot)(dot)(at)commandprompt(dot)com (Alvaro Herrera) wrote:
> Excerpts from Nick's message of vie sep 10 20:36:24 -0400 2010:
>
> > Yes, that gets down to the root of my question... what is the
> > expression that would properly split the values? -Nick
>
> The only idea that comes to mind right now is to remove them before
> processing the rest of the string, and put them back to the first and
> last element if they were removed.
>
> --
> Álvaro Herrera <alvhe(dot)(dot)(dot)(at)commandprompt(dot)com>
> The PostgreSQL Company - Command Prompt, Inc.
> PostgreSQL Replication, Consulting, Custom Development, 24x7 support
>
> --
> Sent via pgsql-general mailing list (pgsql-gene(dot)(dot)(dot)(at)postgresql(dot)org)
> To make changes to your subscription:http://www.postgresql.org/mailpref/pgsql-general