| Components | All | New | MacOS | Windows | Linux | iOS | ||||
| Examples | Mac & Win | Server | Client | Guides | Statistic | FMM | Blog | Deprecated | Old | |
Text.RemoveControlCharacters
Removes control characters.
| Component | Version | macOS | Windows | Linux | Server | iOS SDK |
| Text | 5.1 | ✅ Yes | ✅ Yes | ✅ Yes | ✅ Yes | ✅ Yes |
MBS( "Text.RemoveControlCharacters"; Text ) More
Parameters
| Parameter | Description | Example |
|---|---|---|
| Text | The text to process. | "Hello World" |
Result
Returns text or error.
Description
Removes control characters.Leaves tab, return and new line characters in the text, but removes other characters with code point <32.
See also Text.ReplaceNewLine for replacing line endings.
Rewritten for version 12.1 to preserve text styles.
Examples
Remove control characters test:
Length(MBS( "Text.RemoveControlCharacters"; "Hello" & Char(3) & "World" ))
Example result: 10
Do cleanup in a calculated field:
MBS(“Text.RemoveControlCharacters”; self)
Remove a BOM Character:
Length(MBS("Text.RemoveControlCharacters"; "Hello" & Char(65279)))
Example result: 5
See also
Release notes
- Version 15.3
- Improved Text.RemoveControlCharacters function to also remove BOM character.
- Version 12.1
- Rewrote Text.RemoveControlCharacters, Text.ConvertUnicodeToCharacterDecomposition and Text.ConvertUnicodeToCharacterComposition functions to preserve text styles.
Example Databases
Blog Entries
- MBS FileMaker Plugin, version 15.3pr1
- MBS FileMaker Plugin, version 12.1pr2
- MBS FileMaker Plugin, version 12.1pr1
This function checks for a license.
Created 22nd April 2015, last changed 16th May 2025
