Newest functions Upload a function Leave a tip My account

There are 2,520 functions in this library.

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 - Show more from this author http://seandellis.com

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

/* * ============================== * DecodeAccents ( text ) * ============================== * Created: 2011-10-01 * By: Sean Dellis • http://seandellis.com * Version: 1.1 * ============================== * Purpose: Converts most upper and lower case accented characters into standard alphabetical characters. * ============================== * Input: àéìóù * Output: aeiou * ============================== */ Substitute ( text ; [ "ª" ; "a" ] ; [ "á" ; "a" ] ; [ "Á" ; "A" ] ; [ "à" ; "a" ] ; [ "À" ; "A" ] ; [ "ă" ; "a" ] ; [ "Ă" ; "A" ] ; [ "â" ; "a" ] ; [ "Â" ; "A" ] ; [ "ǎ" ; "a" ] ; [ "Ǎ" ; "A" ] ; [ "å" ; "a" ] ; [ "Å" ; "A" ] ; [ "ǻ" ; "a" ] ; [ "Ǻ" ; "A" ] ; [ "ä" ; "a" ] ; [ "Ä" ; "A" ] ; [ "ã" ; "a" ] ; [ "Ã" ; "A" ] ; [ "ą" ; "a" ] ; [ "Ą" ; "A" ] ; [ "ā" ; "a" ] ; [ "Ā" ; "A" ] ; [ "æ" ; "ae" ] ; [ "Æ" ; "AE" ] ; [ "ǽ" ; "ae" ] ; [ "Ǽ" ; "AE" ] ; [ "ć" ; "c" ] ; [ "Ć" ; "C" ] ; [ "ĉ" ; "c" ] ; [ "Ĉ" ; "C" ] ; [ "č" ; "c" ] ; [ "Č" ; "C" ] ; [ "ċ" ; "c" ] ; [ "Ċ" ; "C" ] ; [ "ç" ; "c" ] ; [ "Ç" ; "C" ] ; [ "ď" ; "d" ] ; [ "Ď" ; "D" ] ; [ "đ" ; "d" ] ; [ "Đ" ; "D" ] ; [ "ð" ; "d" ] ; [ "Ð" ; "D" ] ; [ "é" ; "e" ] ; [ "É" ; "E" ] ; [ "è" ; "e" ] ; [ "È" ; "E" ] ; [ "ĕ" ; "e" ] ; [ "Ĕ" ; "E" ] ; [ "ê" ; "e" ] ; [ "Ê" ; "E" ] ; [ "ě" ; "e" ] ; [ "Ě" ; "E" ] ; [ "ë" ; "e" ] ; [ "Ë" ; "E" ] ; [ "ė" ; "e" ] ; [ "Ė" ; "E" ] ; [ "ę" ; "e" ] ; [ "Ę" ; "E" ] ; [ "ē" ; "e" ] ; [ "Ē" ; "E" ] ; [ "ƒ" ; "f" ] ; [ "ğ" ; "g" ] ; [ "Ğ" ; "G" ] ; [ "ĝ" ; "g" ] ; [ "Ĝ" ; "G" ] ; [ "ġ" ; "g" ] ; [ "Ġ" ; "G" ] ; [ "ģ" ; "g" ] ; [ "Ģ" ; "G" ] ; [ "ĥ" ; "h" ] ; [ "Ĥ" ; "H" ] ; [ "ħ" ; "h" ] ; [ "Ħ" ; "H" ] ; [ "í" ; "i" ] ; [ "Í" ; "I" ] ; [ "ì" ; "i" ] ; [ "Ì" ; "I" ] ; [ "ĭ" ; "i" ] ; [ "Ĭ" ; "I" ] ; [ "î" ; "i" ] ; [ "Î" ; "I" ] ; [ "ǐ" ; "i" ] ; [ "Ǐ" ; "I" ] ; [ "ï" ; "i" ] ; [ "Ï" ; "I" ] ; [ "ĩ" ; "i" ] ; [ "Ĩ" ; "I" ] ; [ "İ" ; "I" ] ; [ "į" ; "i" ] ; [ "Į" ; "I" ] ; [ "ī" ; "i" ] ; [ "Ī" ; "I" ] ; [ "ij" ; "ij" ] ; [ "IJ" ; "IJ" ] ; [ "ı" ; "i" ] ; [ "ĵ" ; "j" ] ; [ "Ĵ" ; "J" ] ; [ "ķ" ; "k" ] ; [ "Ķ" ; "K" ] ; [ "ĺ" ; "l" ] ; [ "Ĺ" ; "L" ] ; [ "ľ" ; "l" ] ; [ "Ľ" ; "L" ] ; [ "ļ" ; "l" ] ; [ "Ļ" ; "L" ] ; [ "ł" ; "l" ] ; [ "Ł" ; "L" ] ; [ "ŀ" ; "l" ] ; [ "Ŀ" ; "L" ] ; [ "ń" ; "n" ] ; [ "Ń" ; "N" ] ; [ "ň" ; "n" ] ; [ "Ň" ; "N" ] ; [ "ñ" ; "n" ] ; [ "Ñ" ; "N" ] ; [ "ņ" ; "n" ] ; [ "Ņ" ; "N" ] ; [ "º" ; "o" ] ; [ "ó" ; "o" ] ; [ "Ó" ; "O" ] ; [ "ò" ; "o" ] ; [ "Ò" ; "O" ] ; [ "ŏ" ; "o" ] ; [ "Ŏ" ; "O" ] ; [ "ô" ; "o" ] ; [ "Ô" ; "O" ] ; [ "ǒ" ; "o" ] ; [ "Ǒ" ; "O" ] ; [ "ö" ; "o" ] ; [ "Ö" ; "O" ] ; [ "ő" ; "o" ] ; [ "Ő" ; "O" ] ; [ "õ" ; "o" ] ; [ "Õ" ; "O" ] ; [ "ø" ; "o" ] ; [ "Ø" ; "O" ] ; [ "ǿ" ; "o" ] ; [ "Ǿ" ; "O" ] ; [ "ō" ; "o" ] ; [ "Ō" ; "O" ] ; [ "ơ" ; "o" ] ; [ "Ơ" ; "O" ] ; [ "œ" ; "oe" ] ; [ "Œ" ; "OE" ] ; [ "ŕ" ; "r" ] ; [ "Ŕ" ; "R" ] ; [ "ř" ; "r" ] ; [ "Ř" ; "R" ] ; [ "ŗ" ; "r" ] ; [ "Ŗ" ; "R" ] ; [ "ś" ; "s" ] ; [ "Ś" ; "S" ] ; [ "ŝ" ; "s" ] ; [ "Ŝ" ; "S" ] ; [ "š" ; "s" ] ; [ "Š" ; "S" ] ; [ "ş" ; "s" ] ; [ "Ş" ; "S" ] ; [ "ſ" ; "s" ] ; [ "ß" ; "ss" ] ; [ "ť" ; "t" ] ; [ "Ť" ; "T" ] ; [ "ţ" ; "t" ] ; [ "Ţ" ; "T" ] ; [ "ŧ" ; "t" ] ; [ "Ŧ" ; "T" ] ; [ "ú" ; "u" ] ; [ "Ú" ; "U" ] ; [ "ù" ; "u" ] ; [ "Ù" ; "U" ] ; [ "ŭ" ; "u" ] ; [ "Ŭ" ; "U" ] ; [ "û" ; "u" ] ; [ "Û" ; "U" ] ; [ "ǔ" ; "u" ] ; [ "Ǔ" ; "U" ] ; [ "ů" ; "u" ] ; [ "Ů" ; "U" ] ; [ "ü" ; "u" ] ; [ "Ü" ; "U" ] ; [ "ǘ" ; "u" ] ; [ "Ǘ" ; "U" ] ; [ "ǜ" ; "u" ] ; [ "Ǜ" ; "U" ] ; [ "ǚ" ; "u" ] ; [ "Ǚ" ; "U" ] ; [ "ǖ" ; "u" ] ; [ "Ǖ" ; "U" ] ; [ "ű" ; "u" ] ; [ "Ű" ; "U" ] ; [ "ũ" ; "u" ] ; [ "Ũ" ; "U" ] ; [ "ų" ; "u" ] ; [ "Ų" ; "U" ] ; [ "ū" ; "u" ] ; [ "Ū" ; "U" ] ; [ "ư" ; "u" ] ; [ "Ư" ; "U" ] ; [ "ŵ" ; "w" ] ; [ "Ŵ" ; "W" ] ; [ "ý" ; "y" ] ; [ "Ý" ; "Y" ] ; [ "ŷ" ; "y" ] ; [ "Ŷ" ; "Y" ] ; [ "ÿ" ; "y" ] ; [ "Ÿ" ; "Y" ] ; [ "ź" ; "z" ] ; [ "Ź" ; "Z" ] ; [ "ž" ; "z" ] ; [ "Ž" ; "Z" ] ; [ "ż" ; "z" ] ; [ "Ż" ; "Z" ] ; [ "ʼn" ; "n" ] ) Click to copy

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

 

Comments

		Olivier Caulet, Helixir Oct 4, 2011
Simple, efficace, et utile. Il suffisait d'y penser :-) Merci

		João Coutinho Jun 1, 2012
You can add [ "ç" ; "c" ] ; [ "Ç" ; "C" ] ; Great saving time function. Best regards,

		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 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, 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 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 20 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: