AnsweredAssumed Answered

I need a text comparison function the works with accents

Question asked by portybelly on Nov 2, 2015
Latest reply on Nov 21, 2015 by oceanwest

I'm writing a simple application which tests students on their french. In my data file I have the text "vous êtes" in a field (note the circonflex). My app asks the answer a question to which this is the answer. If they get it right the text goes green, wrong it goes red. All I do is compare the 2 strings using the not equals operator. However if the user types "vous etes" (no circonflex), which is not the same, and  definitely not correct, filemaker says they match. I tried the EXACT function too, same result. Is there a function I can use which gets this right?


I'm on pro 13 advanced.


Thanks John