Line Break within a cell using Condition

[Gsiva3]

Hi Team,

I have a column named Data in which the each row value differs by length. And there is no standard length for the row values.

My concern is whenever the length of row value exceeds 26 I need the values in the row to be breaked into next line in the same row. For example if my length of the row is 52, then I need a row with 26 values at the top and 26 characters at the same row in the next line.

If my length of the row is 78, then I need 3 lines splitted as 26 characters each in a single row.

Can anyoune help me on this.

Have attached the sample input & output data

[gawa]

hi @Gsiva3 

Here is the WF to realize it. Key is to split Data into row by Regex tool.

By the way, in your dataset, Data2 contains non-uniform length, that is 26 or 27. Anyway, you can adjust its threshold in Formula tool in my WF as you wish.

[caltang]

Here's how:

I am assuming the "," comma delimiter counts towards the length as well.

[Gsiva3]

Hi @caltang  & @gawa

Both the workflows are working fine.

But when I am trying to report this output as a PDF file, the text is not getting wrapped. It is coming in a single line.

Is there a way to wrap the text in the same format in the PDF output.

Have attached the PDF output file without wrapping. 

I need a PDF output file with text wrapped 

[caltang]

Try this:

If the above solved your need, kindly like & mark as accepted solution so that you may help others find the solution more quickly + to close the thread as is. Thanks!

Best regards,
Calvin Tang
https://www.linkedin.com/in/calvintangkw/

[gawa]

@Gsiva3 

You can refer to this thread for rendering table with multiple lines. 

https://community.alteryx.com/t5/Alteryx-Designer-Desktop-Discussions/How-to-Render-a-Table-with-Mul...

[flying008]

Hi, @Gsiva3 

FYI.

	Input
	Data
	11111111,22222222,33333333
	11111111,22222222,33333333,44444444,55555555,66666666
	11111111,22222222,33333333,44444444,55555555,66666666,77777777,88888888,99999999
	12345678
	12345678,87654321
	Output
RecordID	Data
1	11111111,22222222,33333333
2	11111111,22222222,33333333,
	44444444,55555555,66666666
3	11111111,22222222,33333333,
	44444444,55555555,66666666,
	77777777,88888888,99999999
4	12345678
5	12345678,87654321