Syntax Text.Contains(text as nullable text, substring as text, optional comparer as nullable function) as nullable logical Description Detects whether the text text contains the text substring. Returns true if the text is found. Reference Data https://docs.microsoft.com/en-us/powerquery-m/power-query-m-function-reference Power Query M Functions / Text Functions / Text.Contains
Syntax Text.Replace(text as nullable text, old as text, new as text) as nullable text Description Returns the result of replacing all occurrences of text value old in text value text with text value new. This function is case sensitive. Reference Data https://docs.microsoft.com/en-us/powerquery-m/power-query-m-function-reference Power Query M… Read More »Text.Replace
Syntax Text.BeforeDelimiter(text as nullable text, delimiter as text, optional index as any) as any Description Returns the portion of text before the specified delimiter. An optional numeric index indicates which occurrence of the delimiter should be considered. An optional list index indicates which occurrence of… Read More »Text.BeforeDelimiter
Syntax Text.PadEnd(text as nullable text, count as number, optional character as nullable text) as nullable text Description Returns a text value padded to length count by inserting spaces at the end of the text value text. An optional character character can be used to specify… Read More »Text.PadEnd
Syntax Text.Clean(text as nullable text) as nullable text Description Returns a text value with all non-printable characters of text removed. Reference Data https://docs.microsoft.com/en-us/powerquery-m/power-query-m-function-reference Power Query M Functions / Text Functions / Text.Clean
Syntax Text.End(text as nullable text, count as number) as nullable text Description Returns a text value that is the last count characters of the 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.End
Syntax Text.Middle(text as nullable text, start as number, optional count as nullable number) as nullable text Description Returns count characters, or through the end of text; at the offset start. Reference Data https://docs.microsoft.com/en-us/powerquery-m/power-query-m-function-reference Power Query M Functions / Text Functions / Text.Middle
Syntax Text.PositionOfAny(text as text, characters as list, optional occurrence as nullable number) as any Description Returns the position of the first occurrence of any of the characters in the character list text found in the text value characters. An optional parameter occurrence may be used… Read More »Text.PositionOfAny
Syntax Text.Start(text as nullable text, count as number) as nullable text Description Returns the first count characters of text as a text value. Reference Data https://docs.microsoft.com/en-us/powerquery-m/power-query-m-function-reference Power Query M Functions / Text Functions / Text.Start
Syntax Text.Range(text as nullable text, offset as number, optional count as nullable number) as nullable text Description Returns the substring from the text text found at the offset offset. An optional parameter, count, can be included to specify how many characters to return. Throws an… Read More »Text.Range