using " in variables as symbol for inches

[eoneon123]

Super basic question, but I was wondering how to capture single quotation (") marks in variables or calc fields. This is just for display purposes as I'm using FMP as way of simplify a bunch of repetitive cutting and pasting between fields on an online database at work. FMP won't allow me to use the symbol for inches (") and if I cheat and use two single quotes (''), it doesn't display correctly in the work database where I'm pasting the data into. Any help would be greatly appreciated. 

 

[jbante]

To use a double quotation mark (") in a text literal, you need to use an additional "escape" character so FileMaker knows you mean to include the double quote character, and not trying to end the string. FileMaker uses a backslash prefix for an escape character, so the calculation to output a double quote character would be """ — The first quote character to tell FileMaker you're starting a literal string, the backslash to tell FileMaker that the next character is part of the string, and the last quote character to tell FileMaker you're done writing the string.

[eoneon123]

As always, much obliged!

[RodM]

Hi,    looking at my question,, this seems similar, 
Is okay here to  further ask a question regarding same or need to re post new

 

 

my $filePath   C:/User/Rod/DropBox

I think i am having problems with forward slashes using a FileCopy of Scriptmaster

 

My question is..  trying to use a Substitute ($filePath   ; "/"   ; ""  )    getting a error

tried all kinds of combinations.. Subsitute ($filePath   ; "/"   ; """  )     removes / replaces with "

and others.. just errors,  not maybe understanding your answer to Eoneon enough to solve my own thing..

 

Appreciate..

[doughemi]

Since the is used to delimit other reserved characters, you have to precede the literal backslash that you are trying to replace with another backslash as a delimiter:

 

Substitute($filePath; "/"; "")