Syntax Text.InferNumberType(text as text, optional culture as nullable text) as type Description Infers the granular number type (Int64.Type, Double.Type, etc.) of text. An error is raised if text is not a number. 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… Read More »Text.InferNumberType
Syntax Text.Split(text as text, separator as text) as list Description Returns a list of text values resulting from the splitting a text value text based on the specified delimiter, separator. Reference Data https://docs.microsoft.com/en-us/powerquery-m/power-query-m-function-reference Power Query M Functions / Text Functions / Text.Split
Syntax Text.ToBinary(text as nullable text, optional encoding as nullable number, optional includeByteOrderMark as nullable logical) as nullable binary Description Encodes the given text value, text, into a binary value using the specified encoding. Reference Data https://docs.microsoft.com/en-us/powerquery-m/power-query-m-function-reference Power Query M Functions / Text Functions / Text.ToBinary
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 M Functions / Text Functions / TextEncoding.Ascii
Syntax Text.Upper(text as nullable text, optional culture as nullable text) as nullable text Description Returns the result of converting all characters in text to uppercase. 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.Upper
Syntax Text.TrimStart(text as nullable text, optional trim as any) as nullable text Description Returns the result of removing all leading 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.TrimStart
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 M Functions / Text Functions / TextEncoding.Windows
Syntax Text.Select(text as nullable text, selectChars as any) as nullable text Description Returns a copy of the text value text with all the characters not in selectChars removed. Reference Data https://docs.microsoft.com/en-us/powerquery-m/power-query-m-function-reference Power Query M Functions / Text Functions / Text.Select
Syntax Text.FromBinary(binary as nullable binary, optional encoding as nullable number) as nullable text Description Decodes data, binary, from a binary value in to a text value, using encoding type. Reference Data https://docs.microsoft.com/en-us/powerquery-m/power-query-m-function-reference Power Query M Functions / Text Functions / Text.FromBinary
Syntax Table.UnpivotOtherColumns(table as table, pivotColumns as list, attributeColumn as text, valueColumn as text) as table Description Translates all columns other than a specified set into attribute-value pairs, combined with the rest of the values in each row. Reference Data https://docs.microsoft.com/en-us/powerquery-m/power-query-m-function-reference Power Query M Functions /… Read More »Table.UnpivotOtherColumns