How to find and replace double quotes?

Paul LeFrancois

Hi All,
Here's my dilemma. I am trying to create a data cleansing app that looks at a single column in a Sybase db and replaces double quotes " with a space.
Here is my current code (which obviously isn't working).
Any ideas?
Many thanks.
---------------
string strSql = string.Empty;
string find = """;
string replace = " ";
strSql = "DECLARE @patfind varchar(255)"
+ "UPDATE my_table SET my_column = ltrim(rtrim(STUFF( my_column,PATINDEX( '"+find+"', my_column),"
+ "DATALENGTH( '" + find + "' ),'" + replace + "' ))) WHERE email LIKE '" + find + "' ";

3 Replies

Know the answer? Post it — somebody with the same question will find it here.

Vasanth16y ago
Please try to use own function here ,

String_Replace(, , )

UPDATE my_table SET my_column = String_Replace( my_column ,'"', ' ')

If it helps you , please mark as answer.
0
Paul LeFrancois16y ago
Thank you Vasanth. That would work if I was updating an Oracle db. However, I am working on a Sybase db which doesn't have the REPLACE function.

Cheers!
Paul
0
Vasanth16y ago
hi paul , its pretty simple

UPDATE my_table SET my_column = REPLACE(my_column ,'"', ' ')

Here don't use where clause for double Quotes.

If it helps out , please mark as answer
0