Re: Regular expression that splits CSV string into table - Mailing list pgsql-general

From Nick
Subject Re: Regular expression that splits CSV string into table
Date
Msg-id d1323846-84ab-4b03-9dd2-40217581b337@13g2000prf.googlegroups.com
Whole thread Raw
In response to Regular expression that splits CSV string into table  (Nick <nboutelier@gmail.com>)
Responses Re: Regular expression that splits CSV string into table  (Jeff Davis <pgsql@j-davis.com>)
List pgsql-general
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...@commandprompt.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...@commandprompt.com>
> The PostgreSQL Company - Command Prompt, Inc.
> PostgreSQL Replication, Consulting, Custom Development, 24x7 support
>
> --
> Sent via pgsql-general mailing list (pgsql-gene...@postgresql.org)
> To make changes to your subscription:http://www.postgresql.org/mailpref/pgsql-general


pgsql-general by date:

Previous
From: Alvaro Herrera
Date:
Subject: Re: Regular expression that splits CSV string into table
Next
From: tony@exquisiteimages.com
Date:
Subject: SQL Programming Question