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
Text.SplitAny(text as text, separators as text) as list
About
Returns a list of text values resulting from the splitting of a text value based on any character specified in the delimiter.
text: The text value to split.separator: The delimiter characters used to split the text.
Example 1
Create a list from the given text using the specified delimiter characters.
Usage
Text.SplitAny("Name|Customer ID|Purchase|Month-Day-Year", "|-")
Output
{
"Name",
"Customer ID",
"Purchase",
"Month",
"Day",
"Year"
}