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
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!
 
ererger   ererger, jyyj
Jan 11, 2016
1
00:00:06,000 --> 00:00:12,074
Advertise your product or brand here
contact www.OpenSubtitles.org today

2
00:00:56,485 --> 00:01:02,361
-PEDESET NIJANSI NA SIVO-
Ne se preporačuva za lica pod 16 god.

3
00:02:15,000 --> 00:02:17,000
KUЌA GREJ

4
00:02:33,987 --> 00:02:35,987
Ana, zemi ja mojata kola.

5
00:02:36,875 --> 00:02:38,946
Ti dadov diktafon, zar ne?

6
00:02:39,923 --> 00:02:44,743
Da. -Gi imaš site prašanja?
-Gi imam. -Znaeš li kade odiš?

7
00:02:44,932 --> 00:02:49,975
Da, imam GPS i odličen
prosek. Ќe se snajdam.

8
00:02:50,100 --> 00:02:52,100
Toa ќe go oblečeš?

9
00:02:52,804 --> 00:02:57,504
Podobro pomalku zboruvaj,
a poveќe jadi.

10
00:03:30,836 --> 00:03:32,928
Intervju so Kristijan Grej

11
00:03:46,468 --> 00:03:48,468
G-ѓice Kavana?

12
00:03:48,630 --> 00:03:50,802
Može da vi go zemam kaputot?
-Da.

13
00:03:51,763 --> 00:03:56,750
Taa e... ova... -G-n. Grej
sega ќe ve primi. -Vo red

14
00:03:57,434 --> 00:03:59,513
Odovde, Ve molam.
-Dobro.

15
00:04:10,569 --> 00:04:12,569
Na ovaa vrata.

16
00:04:20,093 --> 00:04:22,093
G-ce Kavana.

17
00:04:22,750 --> 00:04:25,171
Dobro li ste?

18
00:04:27,452 --> 00:04:30,473
Kristijan Grej.
-Jas sum Anastasija Stil.

19
00:04:32,021 --> 00:04:35,128
G-ca Kavana ima grip.
Me zamoli da ja zamenam.

20
00:04:35,253 --> 00:04:40,075
Taka znači. Studirate novinarstvo?
-Ne, angliska kniževnost.

21
00:04:40,200 --> 00:04:45,516
Kejt mi e cimerka. -Kako što
rekov, imam samo 10 min.

22
00:04:45,641 --> 00:04:47,855
Sednete, Ve molam, G-ce Stil.

23
00:05:13,852 --> 00:05:
 
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.

Under construction. Email me your wish list for improvements.