Jump to content
Salesforce and other SMB Solutions are coming soon. ×

" = &quot


forbade
 Share

Recommended Posts

ok,

I am trying to see if its possible for me to get a calculation to replace all instances of the character " in field with the text &quot

 

I am having problems figuring out how to do this, any help is appreciated as always.

 

(this will be used in HTML generation via another calculation)

 

I use FMP 8 ADV so I can write custom functions.

Link to comment
Share on other sites

Define a calc field, text, definition of which is simply a backslash: \.

 

In FileMaker 6 and earlier, you can use four consecutive quotation marks, which also works in 8: """"

 

Let's call that field "Qmk".

 

Then:

 

 

Substitute(YourTable::YourField, Table::Qmk, "")

 

 

 

 

 

 

& Bob's Yer Mama's Brother :)

Link to comment
Share on other sites

 Share



×
×
  • Create New...

Important Information

Terms of Use