Break Line based on character for use in Mail Merge

Reply
Highlighted
Visitor

Break Line based on character for use in Mail Merge

Greetings All,

 

I am seeking advice on how to add a break line to a string based on a specific character. I was able to get the table to look semi correct using ETL + Beast Mode.

 

REPLACE(`String`,';','<br>')

 

But I am unable to use my mail merge doc because the data doesn't doesn't export to excel correctly. I am a bit stumped. Please review the images below and let me know what other options I may have.

 

Any assistance would be greatly appreciated. Thank you in advance. 

 

 

 

Announcements
Win free lodging at Domopalooza! We want to hear your Domo story, enter our Dojo contest and win up to four nights lodging at Domopalooza. Click here!