Break Line based on character for use in Mail Merge

user07596

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. 

 

 

 

DataMaven

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