If a user has a quotation mark (") in a field and I want to remove it, how do I go about doing this?

I tried:

code:

---

Replace(description,""","")

---

which would obviously replace any quotations in the field with nothing, but this does not work. An example would be:

Description field:

"This is driving me nuts"

I would want it to be:

This is driving me nuts

Is there any way to do this? Thanks,

Eric

I think Chuck posted an answer to this in one of the forums here so you could do a search but I think you need """""

(4) quote marks or something goofy like that.

[This message has been edited by signal (edited January 27, 2001).]

This should work:

Replace [ description, """", "" ]

I found this in a tech note on FileMaker's web site.

http://tidb.filemaker.com/ti/FMPro?-db=ti.fp5&-lay=list&-sortfield=relevancecalc&-sortorder=descend&-op=eq&product=filemaker%20&-op=eq&article=calculation%20quote&-token.0=filemake r%20calculation%20quote&-token.1=30&-find=&-format=detail.html&-recid=43643

Chuck

I figured it out... well, I know what the problem is now. It turns out I have the "use smart quotes" feature on, so the substitute for the " does not work because it is not really a " and is instead a smart quote.

Thanks for the replies. I still can't get it to work after reading the FileMaker tech article.

I created a field called Description.

In the description I have (quotes are part of the field)

"This is just a test."

To test this, I then have a calculation that is "calculate only when needed."

For the calculation I have:

Substitute(description,"""","")

However, it still displays:

"This is just a test."

Any ideas? This is driving me crazy....

Thanks