Bring your best ideas to the AI Use Case Contest! Enter to win 40 hours of expert engineering support and bring your vision to life using the powerful combination of Alteryx + AI. Learn more now, or go straight to the submission form.
Start Free Trial

Alteryx Designer Desktop Discussions

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

Display field value on new line in Report after number of occurrences

VickyA
6 - Meteoroid

Hello Community,

 

I am trying to figure out how to display a field value in new line in Report Text after certain number of occurrences of a character. So I have a Number field which includes data similar to ****5572,****5185,****5193,****5201,****5219,****5227,****5235,****5243,****5250,****5268,****5276,****5284,****5292,****5318,****5326,****5334,****5342,****5359,****5367,****5375,****5383,****5391. I would want to wrap the data to the next line after 8 occurrences of ' , ' . Currently the data is trimmed off when displayed on a pdf/word.

Attached is a sample workflow and input data.

Thank you

3 REPLIES 3
Qiu
21 - Polaris
21 - Polaris

@VickyA 
Lets try something like this

0303-VickyA.PNG0303-VickyA-1.PNG

saveeshkumar
9 - Comet

Hi @Vicky,

 

Please find the workflow.

 

saveeshkumar_0-1646305404470.png

 

VickyA
6 - Meteoroid

Thank you both!

Labels
Top Solution Authors