# split Splits a string using a delimiter and creates an array of strings. Information noteNote: This feature is only available in Talend Cloud Pipeline Designer and Talend Data Mapper with the 8.0.1-R2023-10 monthly update or a later one. ## Arguments 1. String to split. 2. Regular expression that matches the delimiter. ## Examples | Input JSON | Query | Result | | --- | --- | --- | | ```
{
"list" : "5.6.7.8"
}
``` | ```
SELECT {
array = split(list, "\.")
}
``` | ```
{
"array" : [ "5", "6", "7", "8" ]
}
``` | | ```
{
"date" : "2023-07-31"
}
``` | ```
WITH $full_date = split(date, "-")
SELECT {
year = $full_date[0],
month = $full_date[1],
day = $full_date[2]
}
``` | ```
{
"year" : "2023",
"month" : "07",
"day" : "31"
}
``` |