Re: Regular expression that splits CSV string into table

From: Jeff Davis <pgsql(at)j-davis(dot)com>
To: Nick <nboutelier(at)gmail(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Regular expression that splits CSV string into table
Date: 2010-09-11 17:48:32
Message-ID: 1284227312.11260.1.camel@jdavis-laptop
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Fri, 2010-09-10 at 18:11 -0700, Nick wrote:
> 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

It doesn't sound like a regex is the best solution here. Why not write a
function in a language that offers a CSV library, like python?

Regards,
Jeff Davis

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Darren Duncan 2010-09-11 18:20:22 Re: SQL Programming Question
Previous Message Martin Gainty 2010-09-11 13:55:02 Re: SQL Programming Question