petepots Posted May 11, 2008 Share Posted May 11, 2008 Hi Guys I am having a real problem because I need to use the"\" char. below but it wont except it. The end result should be ie \cost for example Case(isempty(Mod CatA),"",""\""&Mod CatA) Why cant I use this "\" char and is there a ay over the problem Peter Link to comment Share on other sites More sharing options...
Maarten Witberg Posted May 11, 2008 Share Posted May 11, 2008 It's the ignore next character-character. If you type Case(isempty(Mod CatA),"","\\"&Mod CatA) you should be fine. btw 1 I believe "\\" & Mod CatA, without the case statement, will give the exact same result as long as you keep "do not evaluate if all referenced fields are empty. " checked (bottom left calculation dialog). btw 2 Mod () is a function in Filemaker. Consider avoiding function names in field names to prevent confusion. Link to comment Share on other sites More sharing options...
petepots Posted May 13, 2008 Author Share Posted May 13, 2008 Thank you very much fo your help, much appreciated Peter Link to comment Share on other sites More sharing options...
By Soliant Consulting,
By Soliant Consulting,
By Soliant Consulting,
Recommended Posts