From: | Kieran Ashley <krashley(at)space(dot)qinetiq(dot)com> |
---|---|
To: | pgsql-sql(at)postgresql(dot)org |
Subject: | Problems with Quotes |
Date: | 2005-01-12 18:08:41 |
Message-ID: | 6665151E3647D711B27B0090277C004F9AF71F@ntexch02s.scs.dra.hmg.gb |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-sql |
Hi,
I have a PL/SQL function which breaks up a comma-separated list of values stored in one column, and uses that (along with other data) to make a new table.
My problem is that some of the incoming data is quoted e.g.
"value1, value2, value3"
Meaning that when I split on the commas, I end up with:
"value1
value2
value3"
I've tried using the replace() function to get rid of the ", but I can't figure out how to use it without throwing an error. I tried
replace(col_name, '\"', '')
and several other permutations but to no avail, do I need to use something like an ASCII character code in order to get rid of a quote? If so which one, and if not, is there a better solution?
Many thanks.
Kieran
#############################################################
The information contained in this email and any subsequent
correspondence is private and is intended solely for the
intended recipient(s). For those other than the intended
recipient(s) any disclosure, copying, distribution, or any
action taken or omitted to be taken in reliance on such
information is prohibited and may be unlawful.
#############################################################
From | Date | Subject | |
---|---|---|---|
Next Message | John DeSoi | 2005-01-12 18:17:33 | Re: Problems with Quotes |
Previous Message | Bradley Miller | 2005-01-12 17:53:26 | Recursive query to be used in another result ? |