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 the delimiter should be considered, as well as whether indexing should be done from the start or end of the input.
Reference Data
https://docs.microsoft.com/en-us/powerquery-m/power-query-m-function-reference