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 / 14.0 ✅ 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.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.IdentifyData   New in 14.0
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.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.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.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.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

77 functions shown.

These functions require a license (68%).

Release notes

Blog Entries

FileMaker Magazin

Example Databases