Re: Regular expression that splits CSV string into table

Yes, that gets down to the root of my question... what is the
expression that would properly split the values? -Nick

On Sep 10, 4:43 pm, brick(dot)(dot)(dot)(at)gmail(dot)com (bricklen) wrote:
> On Fri, Sep 10, 2010 at 3:43 PM, Nick <nboutel(dot)(dot)(dot)(at)gmail(dot)com> wrote:
> > What would be the regexp_split_to_table pattern that splits a comma
> > separated string into a table? Im having trouble when a string
> > contains commas or there are commas at the beginning or end
>
> > String
> > ',one,two,''three,four'',five,six,'
>
> > Should return
> > ,one
> > two
> > three,four
> > five
> > six,
>
> You can roll your own function, or try regexp_split_to_table, though
> you will probably have to use a different delimiter if you don't want
> it to break on "three,four".
> Eg.
>
> select regexp_split_to_table('"one","two","three,four","five"',',');
>  regexp_split_to_table
> -----------------------
>  "one"
>  "two"
>  "three
>  four"
>  "five"
>
> --
> 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