Last update: 2022-10-04
  • Created for:
  • User

Read more about Data Workbench’s End-of-life announcement.

The Split transformation splits a string into a vector of substrings based upon a given delimiter character.

Split is particularly useful for extracting individual values from a collection of values associated with a single URI query name value.

Parameter Description Default
Name Descriptive name of the transformation. You can enter any name here.
Comments Optional. Notes about the transformation.
Condition The conditions under which this transformation is applied.

String that is used to separate the input string into substrings. Must be a single character in length.

If you hold down the Ctrl key and right-click within the Delimiter parameter, an Insert menu appears. This menu contains a list of special characters that often are used as delimiters.

Input The name of the field whose value is split to create the output string vector.
Output The name of the output field.

Consider a website in which the products purchased by a customer are listed as part of the cs-uri-query value when the confirmation page associated with a successful purchase is accessed. The following is an example of such a string:

  • /checkout/confirmed.asp?prod_selected=B57481,C46355,Z97123

The cs-uri-stem field is used to determine whether the page being requested by the log entry is the confirmation page. The codes for the products that the customer purchased are listed as the comma-separated values of the prod_selected name in the cs-uri-query. The Split transformation can be used to extract this information by splitting the product codes at the comma if the value of cs-uri-stem matches the value specified in the String Match condition. See String Match. The following transformation details the solution to this problem.

Here, the output field is x-products, which would be used to create the desired extended dimension that maps the products purchased to the sessions during which the purchase was made.

On this page