Text functions
- Article
-
-
These functions create and manipulate text values.
Name |
Description |
Text.InferNumberType |
Infers the granular number type (Int64.Type, Double.Type, and so on) of a number encoded in text. |
Text.Length |
Returns the number of characters in a text value. |
Text Comparisons
Name |
Description |
Text.At |
Returns a character starting at a zero-based offset. |
Text.Middle |
Returns the substring up to a specific length. |
Text.Range |
Returns a number of characters from a text value starting at a zero-based offset and for count number of characters. |
Text.Start |
Returns the count of characters from the start of a text value. |
Text.End |
Returns the number of characters from the end of a text value. |
Modification
Name |
Description |
Text.Insert |
Inserts one text value into another at a given position. |
Text.Remove |
Removes all occurrences of the given character or list of characters from the input text value. |
Text.RemoveRange |
Removes count characters at a zero-based offset from a text value. |
Text.Replace |
Replaces all occurrences of a substring with a new text value. |
Text.ReplaceRange |
Replaces length characters in a text value starting at a zero-based offset with the new text value. |
Text.Select |
Selects all occurrences of the given character or list of characters from the input text value. |
Membership
Name |
Description |
Text.Contains |
Returns true if a text value substring was found within a text value string; otherwise, false. |
Text.EndsWith |
Returns a logical value indicating whether a text value substring was found at the end of a string. |
Text.PositionOf |
Returns the first position of the value (-1 if not found). |
Text.PositionOfAny |
Returns the first position in the text value of any listed character (-1 if not found). |
Text.StartsWith |
Returns a logical value indicating whether a text value substring was found at the beginning of a string. |
Name |
Description |
Text.AfterDelimiter |
Returns the portion of text after the specified delimiter. |
Text.BeforeDelimiter |
Returns the portion of text before the specified delimiter. |
Text.BetweenDelimiters |
Returns the portion of text between the specified startDelimiter and endDelimiter. |
Text.Clean |
Returns the original text value with non-printable characters removed. |
Text.Combine |
Returns a text value that is the result of joining all text values with each value separated by a separator. |
Text.Lower |
Returns the lowercase of a text value. |
Text.PadEnd |
Returns text of a specified length by padding the end of the given text. |
Text.PadStart |
Returns text of a specified length by padding the start of the given text. |
Text.Proper |
Returns a text value with first letters of all words converted to uppercase. |
Text.Repeat |
Returns a text value composed of the input text value repeated a number of times. |
Text.Reverse |
Reverses the provided text. |
Text.Split |
Returns a list containing parts of a text value that are delimited by a separator text value. |
Text.SplitAny |
Returns a list containing parts of a text value that are delimited by any separator text values. |
Text.Trim |
Removes all leading and trailing whitespace. |
Text.TrimEnd |
Removes all trailing whitespace. |
Text.TrimStart |
Removes all leading whitespace. |
Text.Upper |
Returns the uppercase of a text value. |