Skip to main content Skip to complementary content

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

Did this page help you?

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