Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
Syntax
Splitter.SplitTextByRanges(ranges as list, optional startAtEnd as nullable logical) as function
About
Returns a function that splits text into a list of text according to the specified offsets and lengths. A null length indicates that all remaining input should be included.
Example 1
Split the input by the specified position and length pairs, starting from the beginning of the input. Note that the ranges in this example overlap.
Usage
Splitter.SplitTextByRanges({{0, 4}, {2, 10}})("codelimiter")
Output
{"code", "delimiter"}
Example 2
Split the input by the specified position and length pairs, starting from the end of the input.
Usage
let
startAtEnd = true
in
Splitter.SplitTextByRanges({{0, 5}, {6, 2}}, startAtEnd)("RedmondWA?98052")
Output
{"WA", "98052"}