coolboy7163 Posted March 10, 2005 Share Posted March 10, 2005 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 More sharing options...
Bush Posted March 10, 2005 Share Posted March 10, 2005 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 More sharing options...
coolboy7163 Posted March 24, 2005 Author Share Posted March 24, 2005 Two quotation marks to be precise. Link to comment Share on other sites More sharing options...
FileMakin' Tom Posted March 24, 2005 Share Posted March 24, 2005 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", "''Y''", "") which would return "Y" if the field equaled Y or a null (Blank) if it equaled anything else. Be well . . . Tom Link to comment Share on other sites More sharing options...
comment Posted March 24, 2005 Share Posted March 24, 2005 Try: Case ( FieldX = "Y" ; "Y" ; """""" ) or 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 More sharing options...
FileMakin' Tom Posted March 25, 2005 Share Posted March 25, 2005 True - Just force of habit, Comment. Not a bad habit to have though. Link to comment Share on other sites More sharing options...
By Soliant Consulting,
By Soliant Consulting,
By Soliant Consulting,
Recommended Posts
Archived
This topic is now archived and is closed to further replies.