Using Quote marks and symbols in text in calculation fields?
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.