← Back to Splitter functions

Splitter.SplitTextByCharacterTransition

This function produces a result that separates text into a list based on a change from one type of character to another. The before and after inputs can be a list of characters, or a function that eva...

Syntax

Splitter.SplitTextByCharacterTransition(before as anynonnull, after as anynonnull) as function

About

This function produces a result that separates text into a list based on a change from one type of character to another. The before and after inputs can be a list of characters, or a function that evaluates a character and outputs true or false.

Explanation

Separate the input every time a letter is followed by a number, regardless of case. Usage: Power Query MSplitter.SplitTextByCharacterTransition({"A".."Z", "a".."z"}, {"0".."9"})("Abc123") Result: {"Abc", "123"}