How can I use Substitute to replace " by nothing?

[tvdl]

I am trying to use Substitute to replace "-signs in a text by nothing.

But FM does not accept a formula like Substitute (Text; """"; "")

Is there another way to remove " signs from a field via a calculation?

Ton

[keshalyi]

If you enter the string """" then it equates it to a literal quote mark. For instance, I have a script that inserts a font name in quotation marks, in an xtag, as follows:

"@Add-on:<z18><f" & """" & "WoodwardDing" & """" & "><*C>"

yielding

@Add-on:<z18><f"WoodwardDing"><*C>

[IdealData]

Did you try this ?

I don't think it works. FMP tries to match every pair of quote chars, and use the content between as a parameter.

You need to:

Create a GLOBAL to hold the quote char

Enter a single quote char in the global

Now use the global field where you wanted to use """ (yes 3 x ")

The global acts as a secondary reverence which FMP must evaluate and cannot treat as literal.

[keshalyi]

I actually pasted that straight from my database, and I just rechecked - yup, it gives me a quote character, inside a calculation. That's 3 quote characters in a row, if its hard to tell on screen?