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.
#############################################################
---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match
