Breaking a sentence in to multiple columns by fixed length without breaking words

[IMSL]

Hi everyone,

Is there any solution in Alteryx to breaking a text field in to multiple fields by fixed length, without breaking words.

Lets say this is the text field:

"Alteryx is an American computer software company based in Irvine, California, with a development center in Broomfield, Colorado. The company's products are used for data science and analytics."

I want to break it in to multiple fields and each field has 20 characters length.

I used RegEx as showing the picture and I got these:

First outcome field: "Alteryx is an Americ"

Second outcome field: "an computer software"

...

I dont want American breaks in to "Americ" and "an"

[ShankerV]

@IMSL 

One way of doing this.,

[ShankerV · Accepted solution]

Hi @IMSL 

Wanted to have as Columns as per your requirement.

Here is the output to have in columns.

[HomesickSurfer]

Hi @ShankerV I like this!

[IMSL]

Thanks @ShankerV for the help :)