How to add a new column after the original column reaches a set max of characters

[Vstang]

Hello,

I am trying to make a workflow where if my column called "Description" has over 30 characters the remaining characters go into a new column called Description 2 and once that column has over 30 characters the remaining characters go into a new column called Description 3. How would I do this?

[ShankerV]

Hi @Vstang 

One way of doing this.

(.{5})(.{5})(.{5})

Note: I have used 5 characters for the use case, please replace 5 with 30 in your scenario.

Many thanks

Shanker V

[ShankerV]

Hi @Vstang 

If your input data in not constant with 30 characters all over the samples, then the below can be applied.

(.{0,5})(.{0,5})(.{0,5})

Many thanks

Shanker V

[binu_acs]

@Vstang another regex function

[Vstang]

Hello ShankerV,

It doesn't seem to be working. I still have more then 30 characters which includes spaces in the description column and nothing in the new columns. I am including a screenshot of what I am creating in Alteryx and also what is showing up. 

[Vstang]

Hello,

Do I also need to include the record ID button or can I just do it with the just the RegEx?