Replace function

[benrob82]

Hi can anyone help me to replace " in a replace function?

Thanks in advance

 

[gpzcrasher]

To replace " with '

replace(string,"""","'")


--------------------------------
Rome did not create a great empire by having meetings, they did it by killing all those who opposed them.

 

[DotNetGnat]

you want to replace " with what??

here is the syntax:

REPLACE(yourfield,whatyouwanttoreplace,newreplacement)

-DNG

 

[Sheco]

You could also refer to the double quote character by its ASCII value like this:
[tt]sDoubleQuote = Chr(34)
sSingleQuote = Chr(39)
MyString = Replace(MyString, sDoubleQuote, sSingleQuote)
[/tt]

Or I guess you could also do this:
[tt]MyString = Replace(MyString, Chr(34), "'")[/tt]

 

[DotNetGnat]

i am not sure why you guys are assuming that benrob82 wants to replace double quote with a single quote...just curious...

-DNG

 

[Genimuse]

I'm not getting that, either.

Maybe it's

Replace(theThing, """", """)

or

Replace(theThing, """, """")

or

Replace(theThing, """", "\""")

or something else entirely.

 

[gpzcrasher]

Personally I wasn't assuming, just used it as an example.

replace(string,"""","anchovie")



--------------------------------
Rome did not create a great empire by having meetings, they did it by killing all those who opposed them.

 

[benrob82]

Hi all thanks for the replies but the fiest post solved it, I wanted to remove the " totally which was solved.