Hi,
I have a PL/SQL function which breaks up a comma-separated list of values stored in one column, and uses that (along
withother 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
ridof 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.
#############################################################