Load Data in Adobe Campaign classic

[#1]

we are trying to load data in to campaign but due to some reason we are getting xml tags for the product name like xxproductname and we are having it as <span class="xxx">xx</span>productname.

how to remove the xml tags and update the product name in ACC and have final output as xxproductname?

[#2 · Accepted solution]

Hi,

Make use of Replace function in When function. Case(When(check for substring to see if you have a tag, use replace function here), Else(use original product name if you don't have tags))

Example:

Case(When(Left(ProductName, 1) = '<', Replace(ProductName, '<span class="xxx">xx</span>', 'xx')),Else(ProductName))

I have used something similar to the above earlier. you can make use of it.

[#3]

Thank for the help.. that worked for me