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.