Text Functions

Functions for working with text (string) values.

Character.FromNumber
Returns the Unicode character corresponding to the given numeric code point.
Character.ToNumber
Returns the Unicode code point number for the given character.
Guid.From
Returns a validated and normalized GUID text value from the given text representation.
Text.AfterDelimiter
Returns the portion of a text value after a specified delimiter, optionally specifying which occurrence to use.
Text.At
Returns the character at the specified zero-based index position in a text value.
Text.BeforeDelimiter
Returns the portion of a text value before a specified delimiter, optionally specifying which occurrence to use.
Text.BetweenDelimiters
Returns the text between a start delimiter and an end delimiter, with optional occurrence control.
Text.Clean
Removes all control characters from a text value.
Text.Combine
Joins a list of text values into a single text value with an optional separator.
Text.Contains
Returns true if a text value contains a specified substring.
Text.End
Returns a text value of the specified length from the end of a text value.
Text.EndsWith
Returns true if a text value ends with a specified substring.
Text.From
Converts a value to its text representation.
Text.FromBinary
Decodes a binary value into text using the specified encoding.
Text.InferNumberType
Infers the most specific numeric type that can represent the given text value.
Text.Insert
Inserts a text value into another text value at the specified offset position.
Text.Length
Returns the number of characters in a text value.
Text.Lower
Converts all characters in a text value to lowercase.
Text.Middle
Returns a substring starting at the given position, optionally limited to a specified number of characters.
Text.NewGuid
Returns a new randomly generated GUID as a text string.
Text.PadEnd
Pads the end of a text value with a character to reach at least the specified total length.
Text.PadStart
Pads the start of a text value with a character to reach at least the specified total length.
Text.PositionOf
Returns the position of the first (or specified) occurrence of a substring within a text value, or -1 if not found.
Text.PositionOfAny
Returns the position of the first character in a text value that matches any character in a given list.
Text.Proper
Capitalizes the first letter of each word in a text value.
Text.Range
Returns a substring from a text value starting at a given offset, optionally limited to a specified number of characters.
Text.Remove
Removes all occurrences of specified characters from a text value.
Text.RemoveRange
Removes a specified number of characters from a text value starting at the given offset.
Text.Repeat
Returns a text value composed of the input text repeated a specified number of times.
Text.Replace
Replaces all occurrences of a substring within a text value.
Text.ReplaceRange
Replaces a specified number of characters in a text value starting at the given offset with a new text value.
Text.Reverse
Returns a text value with the characters in reverse order.
Text.Select
Returns a text value containing only the characters from the input that match the specified selector.
Text.Split
Splits a text value into a list of text values using a specified separator.
Text.SplitAny
Splits a text value at any character found in the separators string, returning a list of substrings.
Text.Start
Returns a text value of the specified length from the start of a text value.
Text.StartsWith
Returns true if a text value starts with a specified substring.
Text.ToBinary
Encodes a text value into binary using the specified character encoding.
Text.ToList
Returns a list of single-character text values, one for each character in the text.
Text.Trim
Removes leading and trailing whitespace (or specified characters) from a text value.
Text.TrimEnd
Removes trailing whitespace (or specified characters) from a text value.
Text.TrimStart
Removes leading whitespace (or specified characters) from a text value.
Text.Upper
Converts all characters in a text value to uppercase.