Using " as Text in calculation

[Patrick Savelberg]

Hi,

I try to add some external functions to my filemaker project. Using AppleScript.

When i want to calculate my script i keep running to that i can't use " as a text. I made it now working with a text field with " in it. But is there a more commen way to do this ..?

[TheTominator]

In FileMaker you can precede the quote by a slash character to put it directly into a text string in a calculation.

myCalcField = "He said, "Get a job." so I did."

Edited March 24, 2010 by Guest

[niallmac]

Hi

Is there a way to do this in FMP6 please?

Cheers

Niall

[Raybaudi]

Yes...

myCalcField = "He said, [color:red]''Get a job.[color:red]'' so I did."

Note that there are double [color:red]' chars

[comment]

In version 6, you can use two quotation marks in succession in order to escape a quote:

"He said, ""get a job"" so I did."

BTW, this still works in v.7 and later.