| 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 |
(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
- Version 14.5
- Updated unicode tables for removing accents for Text.RemoveAccents function.
- Version 12.2
- Updated Text.FilterASCII, Text.RemoveAccents and Text.RemoveAccentsCaseInsensitive functions to recognize more characters like ½.
- Version 11.3
- Fixed Text.RemoveAccents to not uppercase all characters, broken in v11.2.
- Version 8.5
- Improved Text.RemoveAccents to include greece characters.
- Version 8.2
- Improved Text.RemoveAccents function.
Example Databases
Blog Entries
- MBS FileMaker Plugin, version 14.5pr1
- MBS FileMaker Plugin, version 12.2pr5
- MBS FileMaker Plugin, version 11.3pr4
- MBS FileMaker Plugin, version 8.5pr2
- MBS FileMaker Plugin, version 8.2pr1
- MBS Filemaker Plugin, version 2.1 final candidate
This function checks for a license.
Created 18th August 2014, last changed 28th March 2023
