This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
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.