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
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:
This will literally search for the first 1 to 8 characters and continue until it hits the end of the data.
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.
Alteryx ACE & Top Community Contributor
Chaos reigns within. Repent, reflect and reboot. Order shall return.