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 …