| Components | All | New | MacOS | Windows | Linux | iOS | ||||
| Examples | Mac & Win | Server | Client | Guides | Statistic | FMM | Blog | Deprecated | Old | |
Text.FilterASCII
Filters text to ASCII.
| Component | Version | macOS | Windows | Linux | Server | iOS SDK |
| Text | 10.4 | ✅ Yes | ✅ Yes | ✅ Yes | ✅ Yes | ✅ Yes |
Parameters
| Parameter | Description | Example | Flags |
|---|---|---|---|
| Text | The text to process. | "Hello 😀 Wörld" | |
| Replacement | Replacement text for invalid characters. Default is empty. |
"?" | Optional |
Result
Returns text or error.
Description
Filters text to ASCII.Removes all non ASCII characters which can't fit into 7bit.
This function removes those for software, which may not handle them correctly.
We convert 23 variants of curly quotes into ASCII quotes.
See also Text.RemoveControlCharacters and Text.RemoveAccents functions.
Examples
Test with a lot of special characters:
MBS( "Text.FilterASCII"; "` ‘ ’ • \¶ ¨ À Á Â Ã Ä Å Æ Ç È É Ê Ë Ì Í Î Ï Ð Ñ Ò Ó Ô Õ Ö Ø Ù Ú Û Ü Ý Þ ß à á â ã ä å æ ç è é ê ë ì í î ï ð ñ ò ó ô õ ö ø ù ú û ü ý þ ÿ ¼ ½ ¾ ⅓ ⅔ ⅕ ⅖ ⅗ ⅘ ⅙ ⅚ ⅐ ⅛ ⅜ ⅝ ⅞ ⅑ ⅒ ↉"; "?")
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 emoji:
MBS( "Text.FilterASCII"; "Test 🍎 🍓 🍒"; "?" )
// shows double ? due to emojis being two characters each
Example result: Test ?? ?? ??
See also
Release notes
- Version 12.2
- Updated Text.FilterASCII, Text.RemoveAccents and Text.RemoveAccentsCaseInsensitive functions to recognize more characters like ½.
- Version 10.4
- Added Text.FilterASCII function.
Blog Entries
- MBS FileMaker Plugin, version 12.2pr5
- What is new in the MBS FileMaker Plugin Version 10.4
- MBS FileMaker Plugin, version 10.4pr9
This function is free to use.
Created 8th September 2020, last changed 31st January 2023
