14 Replies Latest reply on Feb 24, 2017 10:14 AM by beverly

    Using Quote marks and symbols in text in calculation fields?

    PaulaMcGrath

      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