Syntax Text.PadStart(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 start of the text value text. An optional character character can be used to specify… Read More »Text.PadStart
Syntax Text.Lower(text as nullable text, optional culture as nullable text) as nullable text Description Returns the result of converting all characters in text to lowercase. An optional culture may also be provided (for example, “en-US”). Reference Data https://docs.microsoft.com/en-us/powerquery-m/power-query-m-function-reference Power Query M Functions / Text Functions… Read More »Text.Lower
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 M Functions / Text Functions / TextEncoding.Utf8
Syntax Text.StartsWith(text as nullable text, substring as text, optional comparer as nullable function) as nullable logical Description Returns true if text value text starts with text value substring. Reference Data https://docs.microsoft.com/en-us/powerquery-m/power-query-m-function-reference Power Query M Functions / Text Functions / Text.StartsWith
Syntax Text.Trim(text as nullable text, optional trim as any) as nullable text Description Returns the result of removing all leading and 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.Trim
Syntax Text.Combine(texts as list, optional separator as nullable text) as text Description Returns the result of combining the list of text values, texts, into a single text value. An optional separator used in the final combined text may be specified, separator. Reference Data https://docs.microsoft.com/en-us/powerquery-m/power-query-m-function-reference Power… Read More »Text.Combine
Syntax Text.Proper(text as nullable text, optional culture as nullable text) as nullable text Description Returns the result of capitalizing only the first letter of each word in text value text. All other letters are returned in lowercase. An optional culture may also be provided (for… Read More »Text.Proper
Syntax Character.FromNumber(number as nullable number) as nullable text Description Returns the character equivalent of the number. Reference Data https://docs.microsoft.com/en-us/powerquery-m/power-query-m-function-reference Power Query M Functions / Text Functions / Character.FromNumber
Syntax Json.FromValue(value as any, optional encoding as nullable number) as binary Description Produces a JSON representation of a given value value with a text encoding specified by encoding. If encoding is omitted, UTF8 is used. Values are represented as follows: Reference Data https://docs.microsoft.com/en-us/powerquery-m/power-query-m-function-reference Power Query… Read More »Json.FromValue
Syntax Character.ToNumber(character as nullable text) as nullable number Description Returns the number equivalent of the character, character. Reference Data https://docs.microsoft.com/en-us/powerquery-m/power-query-m-function-reference Power Query M Functions / Text Functions / Character.ToNumber