Components All New MacOS Windows Linux iOS
Examples Mac & Win Server Client Guides Statistic FMM Blog Deprecated Old

Text.RemoveAccentsCaseInsensitive

Returns text without accents.

Component Version macOS Windows Linux Server iOS SDK
Text 2.1 ✅ Yes ✅ Yes ✅ Yes ✅ Yes ✅ Yes
MBS( "Text.RemoveAccentsCaseInsensitive"; Text )   More

(old name: String.RemoveAccentsCaseInsensitive)

Parameters

Parameter Description Example
Text The input string. "Müller"

Result

Returns the string without accents in upper case letters.

Description

Returns text without accents.
For example é to E and ä to A
If you miss a certain character in our substitution list, please email us.

This function works on pure text, so any text style is lost.

Examples

Removes umlauts from Müller:

MBS( "Text.RemoveAccentsCaseInsensitive"; "Müller" )

Example result: MULLER

Test with a lot of special characters:

MBS( "Text.RemoveAccentsCaseInsensitive"; "` ‘ ’ • \¶ ¨ À Á Â Ã Ä Å Æ Ç È É Ê Ë Ì Í Î Ï Ð Ñ Ò Ó Ô Õ Ö Ø Ù Ú Û Ü Ý Þ ß à á â ã ä å æ ç è é ê ë ì í î ï ð ñ ò ó ô õ ö ø ù ú û ü ý þ ÿ ¼ ½ ¾ ⅓ ⅔ ⅕ ⅖ ⅗ ⅘ ⅙ ⅚ ⅐ ⅛ ⅜ ⅝ ⅞ ⅑ ⅒ ↉")

Example result: "` ' ' * ¶ ¨ A A A A A A AE C E E E E I I I I D N O O O O O O U U U U Y P s a a a a a a ae c e e e e i i i i d n o o o o o o u u u u y p y 1/4 1/2 3/4 1/3 2/3 1/5 2/5 3/5 4/5 1/6 5/6 1/7 1/8 3/8 5/8 7/8 1/9 1/10 0/3"

See also

Release notes

Example Databases

Blog Entries

This function checks for a license.

Created 18th August 2014, last changed 29th April 2022


Text.RemoveAccents - Text.RemoveControlCharacters