Filter ( text ; AZazƒ09etc )
FilterC built to handle foreign characters (and a bit more)
Average rating: 4.2 (39 votes) Log in to vote
ThomasSeidler - Show more from this author
The Good Book Company Ltd
ƒilter ( "ÜMLaüt" ; "AZazƒ" )
ƒilter ( "ÜMLaüt" ; "AZƒ" )
ƒilter ( "ÜMLaüt" ; "azƒ" )
Function definition: (Copy & paste into FileMaker's Edit Custom Function window)
I would have updated FilterC, but cos this is so much more complex than FilterC – on account of handling foreign characters tolerably well – I really thought it merited a separate function. Look at FilterC to understand the principles in simplicity [also a more varied example of usage]. Then come here if you need to deal with foreign characters - keep them in some fields, exchange and control in others.
Filemaker is actually quite clever as it replaces almost all in searching anyway - but Stølen will not find Stolen and Stolen will not find Stølen, so in some instances a pain, therefore having guaranteed clean keys could be helpful.
Principle use to me is to not chop foreigns out when filtering - you don't want to. 'Ümlaüt' being AZaz filtered down to 'Umlaut' is OK behaviour, but to filter it to 'mlat' is not. Hence default behaviour added.
Note: these functions are not guaranteed or supported by BrianDunning.com. Please contact the individual developer with any questions or problems.