split

Splits a string using a delimiter and creates an array of strings.

Note: 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

Input JSON Query Result

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" }`

{
   "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"
}

If you find any issues with this page or its content – a typo, a missing step, or a technical error – please let us know!