Share via


Text functions

These functions create and manipulate text values.

Information

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
Character.FromNumber Converts a number to a text character.
Character.ToNumber Converts a character to a number value.
Guid.From Returns a GUID value from the given value.
Json.FromValue Produces a JSON representation of a given value.
Text.From Creates a text value from the given value.
Text.FromBinary Decodes data from a binary value in to a text value using an encoding.
Text.NewGuid Returns a GUID value as a text value.
Text.ToBinary Encodes a text value into binary value using an encoding.
Text.ToList Returns a list of characters from a text value.
Value.FromText Creates a strongly-typed value from a textual representation.

Extraction

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.

Transformations

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 the specified leading and trailing characters.
Text.TrimEnd Removes all specified trailing characters.
Text.TrimStart Removes all specified leading characters.
Text.Upper Returns the uppercase of a text value.