AnsweredAssumed Answered

Using Quote marks and symbols in text in calculation fields?

Question asked by PaulaMcGrath on Oct 19, 2011
Latest reply on Feb 24, 2017 by beverly

Title

Using Quote marks and symbols in text in calculation fields?

Post

 Hi,

I've been using Filemaker for a few weeks now.  I need to set up a calculation similar to concatenate in excel so I'm using the ampersand (&) function.  The calculation will result in a text string. 

One section of the result needs to contain a text string, so I think I need to put this text string in quote marks (""). It is the same text string in every calculation.

Now here's my problem, some of the text string actually contains quote marks, and greater than and less than signs.  So the calculation won't work as Filemaker gets a bit confused as to what should be inside the quote marks.

Any suggestions?

Thanks

Outcomes