AnsweredAssumed Answered

PI AF Analytics: Escape single and double quote characters

Question asked by dave.johnson on Jul 11, 2017
Latest reply on Jul 11, 2017 by dave.johnson

I am trying to use PI AF Analytics to format a tank level with feet and fractional inches in the following example format: 10' 3.2"

 

I can't figure out how to escape the single and double quotes in my expression to produce this format.  The following expression works:

 

Concat(Int('Level')," ft ", Roundfrac(Frac('Level') * 12, 1)," in")

 

However, I want to replace "ft" with a single quote and "in" with a double quote. I have tried multiple escape character sequences including backslash to no avail. How can I accomplish this objective?

Outcomes