Text.AfterDelimiter Function in Power Query

The Text.AfterDelimiter function returns the portion of text after the specified delimiter.

Syntax

Text.AfterDelimiter(text as nullable text, delimiter as text, optional index as any) as any

Example: Get the portion of the text after the (first) hyphen.

Power Query M

let
    Source = Text.AfterDelimiter("Ashish-Haryana-India", "-")
in
    Source

The output of the above code is “Haryana-India”.

Previous Next