Jump to content

How do I insert " in Set Field


This topic is 5675 days old. Please don't post here. Open a new topic instead.

Recommended Posts

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.

Link to comment
Share on other sites

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 by Guest
Link to comment
Share on other sites

This topic is 5675 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.