Inserting Line Breaks Before Bullet Points in a Text Field

[CrisRoman]

Hello Alteryx Community,

I'm encountering a challenge with formatting a text field in my report. The field includes bullet points (•), and I aim to insert a line break before each to enhance readability.  So rather than to have the bullet points side by side, I'd like to have them as a list such as:

• Task 1

• Task 2 

• Task 3

what I've tried so far:

• Direct line breaks (\n, \r\n) and character functions (CharFromInt) don't seem to affect the output.
• The REPLACE() function and combinations of carriage return and line feed characters also failed to produce the desired result.

Given these constraints, I'm seeking alternative strategies or insights to achieve the required formatting while maintaining the content within a single record.

Appreciate any guidance or suggestions from the community. Thank you!

My ultimate goal is to generate a word document. 

[Qiu]

@CrisRoman 
Can you upload the file in your workflow?

[CrisRoman]

hi @Qiu 

sorry about that.  

I'm attaching the file now. 

[Qiu]

@CrisRoman 
How about we process the data before the reporting tools?

[CrisRoman]

@Qiu 

I appreciate you taking the time to review this.  my objective however is to have the tasks & decisions within the same row.  something like this: 

Tasks	Decisions
•Task 1 •Task 2 •Task 3 •Task 4 •Task 5	•Decisions 1 •Decisions 2 •Decisions 3

[Qiu · Accepted solution]

@CrisRoman 
Something like this?

[CrisRoman]

@Qiu  this was really helpful. thank you so much!

[Qiu]

@CrisRoman 
Glad to help.