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

Thomas Seidler   Thomas Seidler
The Good Book Company
http://www.harmlesswise.com/it

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.

Under construction. Email me your wish list for improvements.