Search Postgresql Archives

Re: Regular expression that splits CSV string into table

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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...@xxxxxxxxx (bricklen) wrote:
> On Fri, Sep 10, 2010 at 3:43 PM, Nick <nboutel...@xxxxxxxxx> 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...@xxxxxxxxxxxxxx)
> To make changes to your subscription:http://www.postgresql.org/mailpref/pgsql-general


-- 
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general



[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux