Adding a new line within text field

I am importing an Excel file. One of the columns contains a lot of text. Some of the text has bullets. I would like to create a new line (carriage return) whenever there is a bullet in the field. I am then creating a table and exporting to a Word Doc with the Render tool. How can I create a new line at each bullet?

Regex

Accepted answers

markcurry

@kristinfreitas

It looks like the Reporting Tools don't like embedded newlines. I've came across this solution by @patrick_digan that should do the trick for you..

https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Working-with-wanted-line-breaks-and-the-Table-gt-Email-tools/m-p/129514#M20961

I've deleted most of the stuff out of your workflow to get it working, but see attached...

AC Appendices.yxmd

All comments

markcurry

See the attached example which hopefully helps. One way to do with would be to replace '•' with '|•', the replace the '|' with a carriage return. The bullet point in the example might be a different character to the bullet point in the Excel file, so you may need to copy the bullet point character in Excel and replace the one in the formula tool.

Split By Bullet Point.yxmd

kristinfreitas

Thank you so much for the help! Using the text to columns tool caused the bullets to split into different rows on my report which I didn't want. I just want the carriage return. So I removed that tool. The formula tool seems to work but it is not carried through to my export and I am not sure why. Any additional ideas would be greatly appreciated!

AC Appendices.yxmd

Quick Links

This months top contributors

AkimasaKajitani 387

mceleavey 383

mbarone 337

Hollingsworth 335

LanisC 335