Text.Split

 

This topic applies to the Power Query Formula Language which can be used with Power Query and Power BI Desktop to build queries that mashup data. See the list of function categories.

Returns a list containing parts of a text value that are delimited by a separator text value.

Text.Split(string as text, separator as text) as list  

ArgumentDescription
stringThe string to parse.
separatorA delimiter value.
  • If two delimiter values are adjacent, or appear at the beginning or end of the text value, the corresponding element in the returned list is an empty text value.

  • If the text value does not contain separator, the returned array consists of a single item containing the original text value.

Show: