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

Thanks,

Kay

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.

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

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, 200619 yr by Guest

Finally got it.

Thanks, Kay

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.