Split to Columns

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.

Datasets

Regex

Accepted answers

Emil_Kos

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 🙂

Tokenize.yxmd

All comments

Emil_Kos

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 🙂

Tokenize.yxmd

atcodedog05

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.

Number Split.yxmd

atcodedog05

Hi @IJH34 ,

Additional you can look at this weekly challenge.

https://community.alteryx.com/t5/Weekly-Challenge/Challenge-234-Spell-It-Out-For-Me-Part-1/td-p/636318

Which used the same concept.

The first post this also has a explanation on how this is done.

jdunkerley79

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!)

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703