How do I insert " in Set Field

[kayp]

I need to put text that contains quotation marks into a field from a script. Can anyone tell me how?

Thanks,

Kay

[John Mark Osborne]

There are several methods. You can use the Quote function:

Set Field [MYTABLE::myfield; Quote("John Mark Osborne")]

Or, you can use the old method:

Set Field [MYTABLE::myfield; """John Mark Osborne"""]

After you enter the calculation above, FileMaker will change it to the following:

Set Field [MYTABLE::myfield; ""John Mark Osborne""]

So, you could type it in using the " for indicating quote marks.

[kayp]

I guess I should have made it clear. I'm running Filemaker 5.5. None of the three suggestions appears to work.

Any other suggestions?

Kay

[Lee Smith]

This question has come up many times in the past.

In version 6, you have to either inclose each " in "", or creat a field to hold a " in it.

in the first example, it would look something like.

FirstName & "[color:red]^" & """" & Nickname & """" & "^" & LastName

(In this example, the FirstName field is concatenated with a double-quote character, etc. You should type a [color:red]space where you see a caret ([color:red]^) in this formula.)

The sample output from this formula is as such:

Jonathan "John" Doe

or,

FirstName & " " & g_QuoteField & NickName & g_QuoteField & " " & LastName

g_QuoteField (text, global) and populated with one Plain Quote.

Use the Set Field script step.

HTH

Lee

Edited May 23, 2006 by Guest

[kayp]

Finally got it.

Thanks, Kay

[John Mark Osborne]

Actually, you were clear in your profile, I just missed it. Sorry about that. Looks like Lee has provided a great answer in my absence. Thanks, Lee.