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

Including " " in result of calculation


Recommended Posts

Hello to all,


This should be simple to figure out, but I could not find it on Filemaker help. Is it possible to include " " to show in the result of a calculation?

Link to comment
Share on other sites

Yer gonna need to be a bit more precise in your request. Do you want to have a space in the result or do you wish to show two quotation marks? Either is possible.

Link to comment
Share on other sites

  • 2 weeks later...

As Quote marks are part of the text calc function, they cannot be used in the result. However, one can use "two single quote marks" to emulate the double quote marks as in:


Case(FieldX = "Y",






which would return "Y" if the field equaled Y or a null (Blank) if it equaled anything else.


Be well . . .


Tom smile.gif

Link to comment
Share on other sites



Case ( FieldX = "Y" ; "Y" ; """""" )


Case ( FieldX = "Y" ; "Y" ; "\"\"" )


BTW, it is not necessary to specify a null default result.

Case ( FieldX = "Y" ; "Y" )

is the same as:

Case ( FieldX = "Y" ; "Y" ; "" )

Link to comment
Share on other sites


This topic is now archived and is closed to further replies.

  • Create New...

Important Information

Terms of Use