Split

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.

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.