Postgres Pro
Downloads
Home   >   mailing lists

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

From Nick
Subject Regular expression that splits CSV string into table
Date
Msg-id 937000a6-1430-438e-a0b5-ef3a66d86321@k17g2000prf.googlegroups.com
Whole thread Raw
Responses Re: Regular expression that splits CSV string into table  (bricklen <bricklen@gmail.com>)
List pgsql-general
Tree view 
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,

pgsql-general by date:

Previous
From: Dmitriy Igrishin
Date:
Subject: Re: regexp on null
Next
From: bricklen
Date:
Subject: Re: Regular expression that splits CSV string into table