cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.

Text to Column Split

Meteor

hi community,
I need to split a text in more columns, but I need to split in more columns every have eleven characters. I think to use split to columns.
And if is possible I want to insert a column before each one of split with a progressive number. In attachment I insert example file.
Thank for your disponibility

Alteryx Certified Partner
Alteryx Certified Partner

@Ferrari,

 

I would recommend using a RegEx tool.  You can set a limit to the number of new fields to create and later remove empty fields.  In order to capture groups of any 8 characters, I would use the following Regular Expression:

(.{1,8})

This will literally search for the first 1 to 8 characters and continue until it hits the end of the data.

 

capture.png

 

If you do this for each field that you've got, then you are done.  In practice, I likely would think through how to apply this to the desired fields and decide whether to use many tools or to transpose the data.

 

Cheers,

Mark

Alteryx ACE & Top Community Contributor

Chaos reigns within. Repent, reflect and reboot. Order shall return.
Labels