Splitter.SplitTextByRanges

 

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 function that splits text according to the specified ranges.

Splitter.SplitTextByRanges(ranges as list) as function  

ArgumentDescription
rangesThe ranges to split on.
  • Each item in ranges should specify a tuple of offset and length (where offset zero refers to the first character). The subset of characters of the line denoted by each tuple is returned as a separate item. If the offset or length is less than zero, an error is thrown. Otherwise, if the tuple is out of range of the line, spaces are used to fill out the value. Therefore, the list returned will have the same cardinality as ranges, and each item will be of the length specified in the corresponding tuple. There is no checking for overlap of tuple ranges.
Show: