Text Functions

Text.ReplaceRange

Syntax Text.ReplaceRange(text as nullable text, offset as number, count as number, newText as text) as …

Text.NewGuid

Syntax Text.NewGuid() as text Description Returns a new, random globally unique identifier (GUID). Reference Data …

Text.EndsWith

Syntax Text.EndsWith(text as nullable text, substring as text, optional comparer as nullable function) as nullable …

Text.Insert

Syntax Text.Insert(text as nullable text, offset as number, newText as text) as nullable text Description …

Value.FromText

Syntax Value.FromText(text as any, optional culture as nullable text) as any Description Decodes a value …

Text.SplitAny

Syntax Text.SplitAny(text as text, separators as text) as list Description Returns a list of text …

Occurrence.First

Syntax null Description The position of the first occurrence of the found value is returned. …

TextEncoding.Unicode

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 …

Text.BetweenDelimiters

Syntax Text.BetweenDelimiters(text as nullable text, startDelimiter as text, endDelimiter as text, optional startIndex as any, …

Text.Reverse

Syntax Text.Reverse(text as nullable text) as nullable text Description Reverses the provided text. Reference Data …

Text.At

Syntax Text.At(text as nullable text, index as number) as nullable text Description Returns the character …

Text.Remove

Syntax Text.Remove(text as nullable text, removeChars as any) as nullable text Description Returns a copy …

TextEncoding.Utf16

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 …

Occurrence.Last

Syntax null Description The position of the last occurrence of the found value is returned. …

Occurrence.All

Syntax null Description A list of positions of all occurrences of the found values is …

Text.From

Syntax Text.From(value as any, optional culture as nullable text) as nullable text Description Returns the …

Text.RemoveRange

Syntax Text.RemoveRange(text as nullable text, offset as number, optional count as nullable number) as nullable …

Text.PositionOf

Syntax Text.PositionOf(text as text, substring as text, optional occurrence as nullable number, optional comparer as …

Text.Length

Syntax Text.Length(text as nullable text) as nullable number Description Returns the number of characters in …

Guid.From

Syntax Guid.From(value as nullable text) as nullable text Description Returns a Guid.Type value from the …

RelativePosition.FromEnd

Syntax null Description Indicates indexing should be done from the end of the input. Reference …

TextEncoding.BigEndianUnicode

Syntax null Description Use to choose the UTF16 big endian binary form. Reference Data https://docs.microsoft.com/en-us/powerquery-m/power-query-m-function-reference …

Text.ToList

Syntax Text.ToList(text as text) as list Description Returns a list of character values from the …

Text.Repeat

Syntax Text.Repeat(text as nullable text, count as number) as nullable text Description Returns a text …

Text.AfterDelimiter

Syntax Text.AfterDelimiter(text as nullable text, delimiter as text, optional index as any) as any Description …

RelativePosition.FromStart

Syntax null Description Indicates indexing should be done from the start of the input. Reference …

Text.TrimEnd

Syntax Text.TrimEnd(text as nullable text, optional trim as any) as nullable text Description Returns the …

Text.Contains

Syntax Text.Contains(text as nullable text, substring as text, optional comparer as nullable function) as nullable …

Text.Replace

Syntax Text.Replace(text as nullable text, old as text, new as text) as nullable text Description …

Text.BeforeDelimiter

Syntax Text.BeforeDelimiter(text as nullable text, delimiter as text, optional index as any) as any Description …

Text.PadEnd

Syntax Text.PadEnd(text as nullable text, count as number, optional character as nullable text) as nullable …

Text.Clean

Syntax Text.Clean(text as nullable text) as nullable text Description Returns a text value with all …

Text.End

Syntax Text.End(text as nullable text, count as number) as nullable text Description Returns a text …

Text.Middle

Syntax Text.Middle(text as nullable text, start as number, optional count as nullable number) as nullable …

Text.PositionOfAny

Syntax Text.PositionOfAny(text as text, characters as list, optional occurrence as nullable number) as any Description …

Text.Start

Syntax Text.Start(text as nullable text, count as number) as nullable text Description Returns the first …

Character.ToNumber

Syntax Character.ToNumber(character as nullable text) as nullable number Description Returns the number equivalent of the …

Text.Select

Syntax Text.Select(text as nullable text, selectChars as any) as nullable text Description Returns a copy …

Text.InferNumberType

Syntax Text.InferNumberType(text as text, optional culture as nullable text) as type Description Infers the granular …

Text.Split

Syntax Text.Split(text as text, separator as text) as list Description Returns a list of text …

Text.ToBinary

Syntax Text.ToBinary(text as nullable text, optional encoding as nullable number, optional includeByteOrderMark as nullable logical) …

TextEncoding.Ascii

Syntax null Description Use to choose the ASCII binary form. Reference Data https://docs.microsoft.com/en-us/powerquery-m/power-query-m-function-reference Power Query …

Text.Upper

Syntax Text.Upper(text as nullable text, optional culture as nullable text) as nullable text Description Returns …

Text.TrimStart

Syntax Text.TrimStart(text as nullable text, optional trim as any) as nullable text Description Returns the …

TextEncoding.Windows

Syntax null Description Use to choose the Windows binary form. Reference Data https://docs.microsoft.com/en-us/powerquery-m/power-query-m-function-reference Power Query …

Text.FromBinary

Syntax Text.FromBinary(binary as nullable binary, optional encoding as nullable number) as nullable text Description Decodes …

Json.FromValue

Syntax Json.FromValue(value as any, optional encoding as nullable number) as binary Description Produces a JSON …

Character.FromNumber

Syntax Character.FromNumber(number as nullable number) as nullable text Description Returns the character equivalent of the …

Text.Proper

Syntax Text.Proper(text as nullable text, optional culture as nullable text) as nullable text Description Returns …

Text.Combine

Syntax Text.Combine(texts as list, optional separator as nullable text) as text Description Returns the result …

Text.Trim

Syntax Text.Trim(text as nullable text, optional trim as any) as nullable text Description Returns the …

Text.StartsWith

Syntax Text.StartsWith(text as nullable text, substring as text, optional comparer as nullable function) as nullable …

TextEncoding.Utf8

Syntax null Description Use to choose the UTF8 binary form. Reference Data https://docs.microsoft.com/en-us/powerquery-m/power-query-m-function-reference Power Query …

Text.Lower

Syntax Text.Lower(text as nullable text, optional culture as nullable text) as nullable text Description Returns …

Text.PadStart

Syntax Text.PadStart(text as nullable text, count as number, optional character as nullable text) as nullable …

Text.Range

Syntax Text.Range(text as nullable text, offset as number, optional count as nullable number) as nullable …