Brian Dunning's FileMaker Custom Functions

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   ThomasSeidler - Show more from this author
The Good Book Company Ltd
http://www.thegoodbook.co.uk

Share on Facebook Share on Twitter

  Sample input:
ƒilter ( "ÜMLaüt" ; "AZaz" )

ƒilter ( "ÜMLaüt" ; "AZazƒ" )

ƒilter ( "ÜMLaüt" ; "AZƒ" )

ƒilter ( "ÜMLaüt" ; "azƒ" )
  Sample output:
UMLaut

ÜMLaüt

ÜML

aüt


  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.

 

Comments

Log in to post comments.

 

Note: these functions are not guaranteed or supported by BrianDunning.com. Please contact the individual developer with any questions or problems.

Support this website.

This library has been a free commmunity resource for FileMaker users and developers for 15 years. It receives no funding and has no advertisements. If it has helped you out, I'd really appreciate it if you could contribute whatever you think it's worth: