הערה
הגישה לדף זה מחייבת הרשאה. באפשרותך לנסות להיכנס או לשנות מדריכי כתובות.
הגישה לדף זה מחייבת הרשאה. באפשרותך לנסות לשנות מדריכי כתובות.
Syntax
Text.Split(text as text, separator as text) as list
About
Returns a list of text values resulting from the splitting of a text value based on the specified delimiter.
text: The text value to split.separator: The delimiter used to split the text. The delimiter can be either a single character or a sequence of characters. If a sequence of characters is used, the text is split only at instances where the exact sequence occurs.
Example 1
Create a list from the "|" delimited text value "Name|Address|PhoneNumber".
Usage
Text.Split("Name|Address|PhoneNumber", "|")
Output
{
"Name",
"Address",
"PhoneNumber"
}
Example 2
Create a list from the text value using a sequence of characters.
Usage
Text.Split("Name, the Customer, the Purchase Date", ", the ")
Output
{
Name,
Customer,
Purchase Date
}