Archive

RelativePosition.FromStart

Syntax null Description Indicates indexing should be done from the start of the input. Reference Data https://docs.microsoft.com/en-us/powerquery-m/power-query-m-function-reference Power Query M Functions / Text Functions / RelativePosition.FromStart

Text.AfterDelimiter

Syntax Text.AfterDelimiter(text as nullable text, delimiter as text, optional index as any) as any Description Returns the portion of text after 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.AfterDelimiter

Text.Repeat

Syntax Text.Repeat(text as nullable text, count as number) as nullable text Description Returns a text value composed of the input text text repeated count times. Reference Data https://docs.microsoft.com/en-us/powerquery-m/power-query-m-function-reference Power Query M Functions / Text Functions / Text.Repeat

Text.ToList

Syntax Text.ToList(text as text) as list Description Returns a list of character values from the given 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.ToList

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 Power Query M Functions / Text Functions / TextEncoding.BigEndianUnicode

RelativePosition.FromEnd

Syntax null Description Indicates indexing should be done from the end of the input. Reference Data https://docs.microsoft.com/en-us/powerquery-m/power-query-m-function-reference Power Query M Functions / Text Functions / RelativePosition.FromEnd

Guid.From

Syntax Guid.From(value as nullable text) as nullable text Description Returns a Guid.Type value from the given value. If the given value is null, Guid.From returns null. A check will be performed to see if the given value is in an acceptable format. Acceptable formats provided… Read More »Guid.From

Text.Length

Syntax Text.Length(text as nullable text) as nullable number Description Returns the number of characters in the text text. Reference Data https://docs.microsoft.com/en-us/powerquery-m/power-query-m-function-reference Power Query M Functions / Text Functions / Text.Length

Text.PositionOf

Syntax Text.PositionOf(text as text, substring as text, optional occurrence as nullable number, optional comparer as nullable function) as any Description Returns the position of the specified occurrence of the text value substring found in text. An optional parameter occurrence may be used to specify which… Read More »Text.PositionOf

Text.RemoveRange

Syntax Text.RemoveRange(text as nullable text, offset as number, optional count as nullable number) as nullable text Description Returns a copy of the text value text with all the characters from position offset removed. An optional parameter, count can by used to specify the number of… Read More »Text.RemoveRange