Adding a new line within text field
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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?
Solved! Go to Solution.
- Labels:
- Regex
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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!
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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..
I've deleted most of the stuff out of your workflow to get it working, but see attached...
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Thank you so much!
