Brian Dunning's FileMaker Custom Functions

DecodeAccents ( text )

Converts most upper and lower case latin accented characters into standard alphabetical characters.

  Average rating: 4.1 (39 votes) Log in to vote

Sean Dellis   Sean Dellis - Show more from this author
http://seandellis.com

Share on Facebook Share on Twitter

  Sample input:
DecodeAccents ( àéìóù )
  Sample output:
aeiou

  Function definition: (Copy & paste into FileMaker's Edit Custom Function window)

Converts most upper and lower case accented characters into standard alphabetical characters.

 

Comments

Olivier Caulet   Olivier Caulet, Helixir
Oct 4, 2011
Simple, efficace, et utile. Il suffisait d'y penser :-)
Merci
 
João Coutinho   João Coutinho
Jun 1, 2012
You can add

[ "ç" ; "c" ] ;
[ "Ç" ; "C" ] ;

Great saving time function.

Best regards,
 
Sean Dellis   Sean Dellis
Oct 10, 2012
Thanks for the suggestions João. I found some more characters and added an additional 160 characters to the function.
 
Doug Staubach   Doug Staubach, Denver CO USA
Mar 10, 2014
Hi - the German character "ß" stands for "ss" (not "B").
So it should say [ "ß" ; "ss" ] ;

Awesome job though - very useful - thank you!
 
R. Miller   R. Miller, Berlin, Germany
Nov 8, 2016
This is great, but turning the German letter Esszet or double-S "ß" into a capital "B" is a mistake; the equivalent of ß is "ss", it has nothing to do, despite its appearance, with the letter B.

Cheers,
RM
 
Sean Dellis   Sean Dellis
Nov 14, 2016
Thanks for the feedback R. Miller and Doug Staubach.

I've corrected "ß" so that it replaces with "ss".

Regards,
Sean
 

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 16 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: