Syntax Text.From(value as any, optional culture as nullable text) as nullable text Description Returns the text representation of value. The value can be a number, date, time, datetime, datetimezone, logical, duration or binary value. If the given value is null, Text.From returns null. An optional… Read More »Text.From
Syntax Text.BetweenDelimiters(text as nullable text, startDelimiter as text, endDelimiter as text, optional startIndex as any, optional endIndex as any) as any Description Returns the portion of text between the specified startDelimiter and endDelimiter. An optional numeric startIndex indicates which occurrence of the startDelimiter should be… Read More »Text.BetweenDelimiters
Syntax null Description Use to choose the UTF16 little endian binary form. Reference Data https://docs.microsoft.com/en-us/powerquery-m/power-query-m-function-reference Power Query M Functions / Text Functions / TextEncoding.Unicode
Syntax null Description The position of the first occurrence of the found value is returned. Reference Data https://docs.microsoft.com/en-us/powerquery-m/power-query-m-function-reference Power Query M Functions / Text Functions / Occurrence.First
Syntax Text.SplitAny(text as text, separators as text) as list Description Returns a list of text values resulting from the splitting a text value text based on any character in the specified delimiter, separators. Reference Data https://docs.microsoft.com/en-us/powerquery-m/power-query-m-function-reference Power Query M Functions / Text Functions / Text.SplitAny
Syntax Value.FromText(text as any, optional culture as nullable text) as any Description Decodes a value from a textual representation, text, and interprets it as a value with an appropriate type. Value.FromText takes a text value and returns a number, a logical value, a null value,… Read More »Value.FromText
Syntax Text.Insert(text as nullable text, offset as number, newText as text) as nullable text Description Returns the result of inserting text value newText into the text value text at position offset. Positions start at number 0. Reference Data https://docs.microsoft.com/en-us/powerquery-m/power-query-m-function-reference Power Query M Functions / Text… Read More »Text.Insert
Syntax Text.EndsWith(text as nullable text, substring as text, optional comparer as nullable function) as nullable logical Description Indicates whether the given text, text, ends with the specified value, substring. The indication is case-sensitive. Reference Data https://docs.microsoft.com/en-us/powerquery-m/power-query-m-function-reference Power Query M Functions / Text Functions / Text.EndsWith
Syntax Text.NewGuid() as text Description Returns a new, random globally unique identifier (GUID). Reference Data https://docs.microsoft.com/en-us/powerquery-m/power-query-m-function-reference Power Query M Functions / Text Functions / Text.NewGuid
Syntax Text.TrimEnd(text as nullable text, optional trim as any) as nullable text Description Returns the result of removing all trailing whitespace from text value text. Reference Data https://docs.microsoft.com/en-us/powerquery-m/power-query-m-function-reference Power Query M Functions / Text Functions / Text.TrimEnd