Problems with Quotes
От | Kieran Ashley |
---|---|
Тема | Problems with Quotes |
Дата | |
Msg-id | 6665151E3647D711B27B0090277C004F9AF71F@ntexch02s.scs.dra.hmg.gb обсуждение исходный текст |
Ответы |
Re: Problems with Quotes
|
Список | 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 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. #############################################################
В списке pgsql-sql по дате отправления: