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 |
(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
- Version 12.2
- Updated Text.FilterASCII, Text.RemoveAccents and Text.RemoveAccentsCaseInsensitive functions to recognize more characters like ½.
Example Databases
Blog Entries
This function checks for a license.
Created 18th August 2014, last changed 29th April 2022
