Velocity email script split data based on delimiter "|"

Question

In CO table, one of the field has product value in below format product = productname | productimage | productcode My pain point is to split the data but I am getting below issue Cannot get email content-

An error occurred when procesing the email Body!

Encountered "]" near

<p><span style="font-family: Verdana;">#set( $productArr = ["1","2","3"] )

#if( !$display.alt($CO_c["product"],"").isEmpty())

#set( $productArr[] = $CO_c["product"].split("|") )

$productArr[1]

$productArr[2]

I have tried below sample VTL code. ##Using split("|") function to seprate the data sets #set( $productArr = ["1","2","3"] ) #if( !$display.alt($CO_c["product"],"").isEmpty()) #set( $productArr[] = $CO_c["product"].split("|") ) $productArr[1] $productArr[2] $productArr[3]

SanfordWhiteman · Accepted Answer

Hi @sanfordwhiteman

CO and keyname all are correct. please refer below screenshot.

Although, In Marketo last we saw issue deleting the CO even after CO was not used anywhere in Marketo. After that Marketo support team fixed that issue. But, now in this case I am not sure if I should reach out to support team because they do not support coding part.

I'm referring to the Velocity name of the object list and key.

Not the API name, that must be considered completely different (even if it is closely related).

You only know the Velocity name by dragging it onto the Velocity Script Editor canvas.

SanfordWhiteman · Answer

There's a syntax error. You're missing an #end.

But even when you fix that, it still won't do what you expect, because the argument you're passing to split() is a regex pattern, not a string. As such, the pipe needs to be escaped as

[|]

Sign up

Login with SSO

Login to the community

Login with SSO

Scanning file for viruses.

This file cannot be downloaded