On Fri, Sep 10, 2010 at 3:43 PM, Nick <nboutelier(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"