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. 

 

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.

As always, much obliged!

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..

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; "/"; "")