I have a script that collect information from several fields into a new field for composing an email.
Spot Name &" v." & Version Number & " (" & Spot_Length& " )"
So I get: Here He Comes v4 (:30).
But sometime the spot name has quotes in it.
So spot name: Here comes "The Captain"
Display in this calculated field as Her comes \"The Captain\"
How can I fix this?