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. 

 

 

 

Major Brown Belt

Re: Break Line based on character for use in Mail Merge

I think this thread will be helpful to you. Rather than copy - Thought it would be best for you to have the context so that I don't leave anything out that may be helpful to you.

https://dojo.domo.com/t5/Beast-Mode-ETL-Dataflow/Nested-Concatenations-in-Beast-Mode/m-p/38064#M6211
DataMaven
Breaking Down Silos - Building Bridges
Check out my story!
Announcements
We want your feedback to improve the Dojo Community! If you are coming to the Dojo Award Ceremony next week Click here to learn more!