I'd like to replace the delimiter from comma to semi-colon in Webtrends WT.pn_sku parameter.

Gold Contributor
Gold Contributor
In one of my UDO field product_sku, it contains an array of multiple values. When I apply that data source to my webtrends parameter WT.pn_sku, it shows up with comma delimiter (or %2C). I'd like to replace that with a semi-colon (%3B). So final output is transformed from xxx-xxxxxx%2Czzz-zzzzzz TO xxx-xxxxxx%3Bzzz-zzzzzz
3 REPLIES 3

I'd like to replace the delimiter from comma to semi-colon in Webtrends WT.pn_sku parameter.

Employee Emeritus
Hi Kris, thanks for sending over these details. I agree that the semi-colon is the more common separator for multiple values in Webtrends. We'll go ahead and update the latest Webtrends template to use semi-colon by default. We should have this in there in the next few days.

I'd like to replace the delimiter from comma to semi-colon in Webtrends WT.pn_sku parameter.

Gold Contributor
Gold Contributor
Thought I'd share what I did that seemed to work. I created an extension using Set Data Value, setting a data source to JS Code writing b.product_sku.join(";");

I'd like to replace the delimiter from comma to semi-colon in Webtrends WT.pn_sku parameter.

Employee Emeritus
Excellent. Thanks for posting the workaround. The master template is also updated so that any Array value that is mapped will be ';' separated. Those who like the ',' (comma) separator will need to use your workaround if they decide to update to the latest Webtrends template.
Public