Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Inserting Line Breaks Before Bullet Points in a Text Field

CrisRoman
7 - Meteor

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. 

 

 

7 REPLIES 7
Qiu
20 - Arcturus
20 - Arcturus

@CrisRoman 
Can you upload the file in your workflow?

CrisRoman
7 - Meteor

hi @Qiu 

sorry about that.  

 

I'm attaching the file now. 

 

 

Qiu
20 - Arcturus
20 - Arcturus

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

0314-CrisRoman.png

CrisRoman
7 - Meteor

@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: 

TasksDecisions
•Task 1
•Task 2
•Task 3
•Task 4
•Task 5
•Decisions 1
•Decisions 2
•Decisions 3
Qiu
20 - Arcturus
20 - Arcturus

@CrisRoman 
Something like this?

0314-CrisRoman-r2.png

CrisRoman
7 - Meteor

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

Qiu
20 - Arcturus
20 - Arcturus

@CrisRoman 
Glad to help.

Labels