Hi,
I am trying to split this column in 24 additional columns.
010100000000000100100010
This column comes in a number of different sequences of 0's and 1's so regardless of the sequence each number needs its on column. The text to column doesn't work because I don't have a delimiter, and I'm not great with regex.
Thanks in advance.
Solved! Go to Solution.
Hi @IJH34,
My solution will work for column not a header.
If you need a help with a header as well we need to use data input tool and choose option that the first row contains data.
Hope this workflow will help you.
The dot in regex is like a joker 🙂
Hi @IJH34 ,
Here is a workflow for the task.
Input
Output additional 24 columns
Workflow
Hope this helps : )
If this helps please mark the post as solution.
Hi @IJH34 ,
Additional you can look at this weekly challenge.
Which used the same concept.
The first post this also has a explanation on how this is done.
A Regex tool in tokenise mode will act like a text to columns.
If you use and expression of [01] then it will look for either a 1 or a 0 and fill to each column (make sure to choose 24!)