Text functions
Article
04/02/2024
4 contributors
Feedback
In this 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.