Break Line based on character for use in Mail Merge

Reply
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!
**Say "Thanks" by clicking the heart in the post that helped you.
**Please mark the post that solves your problem by clicking on "Accept as Solution"
Announcements
Looking for the latest Community solutions? Please visit our accepted solutions board here!