| Components | All | New | MacOS | Windows | Linux | iOS | ||||
| Examples | Mac & Win | Server | Client | Guides | Statistic | FMM | Blog | Deprecated | Old | |
Component: Text
Functions for working with text.
| Version | macOS | Windows | Linux | Server | iOS SDK |
| 2.1 / 15.5 | ✅ Yes | ✅ Yes | ✅ Yes | ✅ Yes | ✅ Yes |
| Item | Details |
|---|---|
| Text.AddLineNumbers Adds line numbers to text. | All 8.3 |
| Text.AppendTextFile Appends a text file with the given text. | All 2.8 |
| Text.CapitalCase Converts text to capital case letters. | All 5.1 |
| Text.Character Creates a character with given number. | All 5.2 |
| Text.Characters Returns the character codes. | All 5.2 |
| Text.Code Queries the number of a character. | All 5.2 |
| Text.Concat Creates a text with concatenating all the given parameters. | All 11.5 |
| Text.ConcatWithDelimiter Creates a text with concatenating all the given parameters. | All 13.3 |
| Text.ConvertFromTextEncoding Converts text from a text encoding. | All 9.4 |
| Text.ConvertToTextEncoding Converts text into a text encoding. | All 9.4 |
| Text.ConvertUnicodeToCharacterComposition Converts text by applying unicode character normalization. | All 5.2 |
| Text.ConvertUnicodeToCharacterDecomposition Converts text by applying unicode character normalization. | All 5.2 |
| Text.CountWords Counts words. | All 8.1 |
| Text.DecodeBytesFromBase64 Decodes base64 string and encodes it as byte values. | All 3.0 |
| Text.DecodeFromBase64 Decode a base 64 string. | All 3.0 |
| Text.DecodeFromBase64URL Decode a base 64 URL string. | All 7.5 |
| Text.DecodeFromBytes Decode a byte string. | All 3.0 |
| Text.DecodeFromHTML Decodes html text. | All 2.4 |
| Text.DecodeFromHex Decode a hex string. | All 2.4 |
| Text.DecodeFromQuotedPrintable Decodes a string with quoted printable encoding. | All 4.3 |
| Text.DecodeFromURL Decode an URL string. | All 2.6 |
| Text.DecodeFromXML Decodes xml text. | All 4.3 |
| Text.DecodeHexFromBase64 Decodes base64 string and encodes it as hex values. | All 3.0 |
| Text.DecodeIMAPFolderName Decodes text from IMAP UTF-7. | All 9.2 |
| Text.DecodeURLComponent Decodes an URL component. | All 3.1 |
| Text.Deserialize Restores a styled text. | All 5.4 |
| Text.EncodeBytesToBase64 Encodes string with byte values to base 64. | All 3.0 |
| Text.EncodeEmailSubject Encodes an email subject. | All 4.3 |
| Text.EncodeHexToBase64 Encodes hex string to base 64. | All 3.0 |
| Text.EncodeToBase64 Encode a base64 string. | All 3.0 |
| Text.EncodeToBase64URL Encode a base64 URL string. | All 7.5 |
| Text.EncodeToBytes Encode a byte string. | All 3.0 |
| Text.EncodeToHTML Encodes text as html. | All 2.4 |
| Text.EncodeToHex Encode a hex string. | All 2.4 |
| Text.EncodeToQuotedPrintable Returns a string with quoted printable characters. | All 4.3 |
| Text.EncodeToURL Encode an URL string. | All 2.6 |
| Text.EncodeToXML Encodes text as xml. | All 4.3 |
| Text.EncodeURLComponent Encodes an URL component. | All 3.1 |
| Text.FileExtensionToMimeType Finds a mime type for a file extension. | All 5.4 |
| Text.FilterASCII Filters text to ASCII. | All 10.4 |
| Text.FilterSwissQRCode Filters characters for Swiss QR code for payments. | All 14.5 |
| Text.FilterUTF16 Filters text to UTF-16. | All 9.3 |
| Text.FindBetween Searches text for text between the two search strings. | All 3.0 |
| Text.FromStyles Creates styled text from JSON made with Text.Style. | All 11.3 |
| Text.HTMLtoJSON Parses HTML and transforms to JSON. | All 14.4 |
| Text.HTMLtoStyledText Converts HTML to styled text. | All 15.5 |
| Text.IdentifyData Checks file type from the data. | All 14.0 |
| Text.InvalidCharactersForEncoding Looks for invalid characters for an encoding. | All 5.2 |
| Text.JaroWinklerDistance Calculates the string distance. | All 2.9 |
| Text.LeftTrim Trims whitespace on the left side. | All 14.2 |
| Text.Length Query length of text. | All 7.2 |
| Text.LevenshteinDistance Calculates the string distance. | All 2.9 |
| Text.List Creates a list with all the given parameters. | All 11.5 |
| Text.ListWords Split words and list them. | All 8.1 |
| Text.LowerCase Converts text to lower case letters. | All 5.1 |
| Text.MergeFields Merge field and variable names into text. | All 8.5 |
| Text.MimeTypeToFileExtension Returns file extension for given mime type. | All 5.4 |
| Text.RTFToText Parses RTF to styled text. | All 11.3 |
| Text.ReadEMLXFile Reads email text from emlx file. | All 5.3 |
| Text.ReadTextFile Reads a text file. | All 2.4 |
| Text.ReadTextFromContainer Reads content of container value as text. | All 4.4 |
| Text.RedefineEncoding Takes a text in a given encoding and reencodes it with other encoding. | All 5.2 |
| Text.RemoveAccents Returns text without accents. | All 2.1 |
| Text.RemoveAccentsCaseInsensitive Returns text without accents. | All 2.1 |
| Text.RemoveControlCharacters Removes control characters. | All 5.1 |
| Text.RemoveNewLine Removes newline characters from string. | All 2.4 |
| Text.RemovePostfix Removes the postfix from text. | All 6.1 |
| Text.RemovePrefix Removes the prefix from text. | All 6.1 |
| Text.ReplaceAll Find & Replace all occurrences of a text. | All 7.3 |
| Text.ReplaceNewLine Replaces newline characters. | All 2.4 |
| Text.Reverse Reverses the order of characters in the text. | All 12.1 |
| Text.RightTrim Trims whitespace on the right side. | All 14.2 |
| Text.Serialize Serializes styled text as text. | All 5.4 |
| Text.SoundEx Returns soundex string for the given text. | All 2.1 |
| Text.SoundExGerman Returns soundex string for the given text. | All 3.5 |
| Text.SplitByLength Split the text by length and returns a list. | All 15.1 |
| Text.Styles Queries style information as JSON. | All 9.3 |
| Text.TextToHTML Creates HTML text for a given FileMaker formatted styled text. | All 4.3 |
| Text.TextToRTF Creates RTF text for a given FileMaker formatted styled text. | All 2.4 |
| Text.Tidy Performs tidy on XML or HTML. | All 14.4 |
| Text.TidyErrorLog Queries the error log for the last call to the Text.Tidy function. | All 14.4 |
| Text.Trim Trims whitespace on the left and right side. | All 8.2 |
| Text.UpperCase Converts text to upper case letters. | All 5.1 |
| Text.WriteTextFile Writes a text file with the given text. | All 2.4 |
| Text.WriteToContainer Write a text as a FILE in a container. | All 4.4 |
| Text.ZLibCompress Compresses the given data using lib. | All 15.5 |
| Text.ZLibDecompress Decompresses the given data using lib. | All 15.5 |
87 functions shown.
These functions require a license (68%).
Release notes
- Version 16.2
- Improved Text.TextToHTML to better handle closing tags with paragraphs.
- Version 16.1
- Improved Text.ReadTextFile and other functions to read files on Windows instead of complaining about file in use.
- Version 16.0
- Changed Text.HTMLtoStyledText to add return after DIV element.
- Fixed handling of block elements for Text.HTMLtoStyledText function.
- Fixed Text.HTMLtoStyledText to show DEL tag as strikethrough.
- Version 15.5
- Added MarkDown.StyledText using Text.HTMLtoStyledText to convert HTML to styled text.
- Added Text.HTMLtoStyledText function.
- Added Text.ZLibCompress and Text.ZLibDecompress functions.
- Implemented WebView.GetFormattedText for Windows using Text.HTMLtoStyledText internally.
- Version 15.3
- Improved Text.RemoveControlCharacters function to also remove BOM character.
- Version 15.1
- Added Text.SplitByLength function.
- Improved Text.ReadTextFile to read things from /proc/ folder on Linux.
- Version 14.5
- Added Text.FilterSwissQRCode function.
- Updated unicode tables for removing accents for Text.RemoveAccents function.
- Version 14.4
- Added Text.Tidy and Text.TidyErrorLog functions to tidy XML and HTML.
- Added Text.HTMLtoJSON function.
- Version 14.2
- Added Text.LeftTrim and Text.RightTrim functions.
Blog Entries
- New in version 11.5 of MBS FileMaker Plugin
- Combine MBS functions to automate processes in FileMaker
- MBS FileMaker Plugin 5.4 for OS X/Windows
FileMaker Magazin
- Ausgabe 4/2025, Seite 23
- Ausgabe 3/2025, Seite 21
- Ausgabe 6/2024, Seite 38
- Ausgabe 6/2024, Seite 14 bis 15
- Ausgabe 6/2021, Seite 23
- Ausgabe 6/2021, Seite 21
- Ausgabe 2/2019, Seite 13 bis 14
- Ausgabe 6/2018, Seite 33
- Ausgabe 6/2018, Seite 30 bis 31
- Ausgabe 5/2018, Seite 29
Example Databases
- CURL/Amazon S3/Amazon S3 Upload Picture
- CURL/Email/Build and send HTML Email with inline graphics
- CURL/WebServices/VAT WebService Example/VAT WebService Example
- Encryption and Hash/JWT RS256
- Mac and iOS/Events/Events Import
- Mac only/ImageCapture/ImageCapture
- Overlay
- Text functions/Merge Fields
- Text functions/Text to RTF or HTML
- Text functions/Word Count functions