Jump to content


  • Content count

  • Joined

  • Last visited

Community Reputation

0 Neutral

About zstadel

  • Rank
  1. I'm trying to specify a calculation for a field (ExampleField) that contains data from a text field (MyTextField) but I want to replace any quote marks in MyTextField with the word " inches"... I would write it like this: ExampleField= Case(PatternCount(MyTextField, """)=1, " inches") But, of course, I get an error. Filemaker sees: Case(PatternCount(MyTextField, "" ")=1, " inches [a field] ") [expects a closing quote mark] I tried creating a global text field called QuoteMark containing a " and wrote the calculation as follows: ExampleField= Case(PatternCount(MyTextField, QuoteMark)=1, " inches") but that didn't work either. Anyone have any suggestions? Can I search by teh quote mark character's ASCII value? zack

Important Information

By using this site, you agree to our Terms of Use.