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

Text.RemoveAccents

Returns text without accents.

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

(old name: String.RemoveAccents)

Parameters

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

Result

Returns the string without accents.

Description

Returns text without accents.
for example é to e
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 umlaut:

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

Example result: Muller

Removes Polish L with stroke:

MBS( "Text.RemoveAccents"; "Łužica")

Example result: Luzica

Test with a lot of special characters:

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

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"

Remove some invisble characters:

Substitute("Hello";
[Char(173);""]; // 00AD soft hyphen
[Char(8203);""]; // 200B zero width space
[Char(8204);""]; // 200C zero width non-joiner
[Char(8205);""]; // 200D zero width joiner
[Char(8239);" "]; // 202F narrow no-break space
[Char(8287);" "]; // 205F medium mathematical space
[Char(8288);""]; // 2060 word joiner
[Char(8289);""]; // 2061 function application
[Char(8290);""]; // 2061 invisible times
[Char(8291);""]; // 2062 invisible separator
[Char(8292);""]; // 2063 invisible plus
[Char(65279);""] // FEFF zero width space
)

See also

Release notes

Example Databases

Blog Entries

This function checks for a license.

Created 18th August 2014, last changed 28th March 2023


Text.RedefineEncoding - Text.RemoveAccentsCaseInsensitive