Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Splitting Grouped Numbers into Individual Numbers

tomtingley
8 - Asteroid

Hi,

 

I'm trying to split the attached numbers up individually.

So, at the moment, I have 1014161929LUCKYSTARS0210

I've used the lottery numbers as an example.

 

I want it to look like this:

10 14 16 19 29 02 10

 

If anyone could help, that would be amazing.

I've attached the file to help.

2 REPLIES 2
ShankerV
17 - Castor

Hi @tomtingley 

 

One way of doing this.

 

ShankerV_0-1681747594347.png

\u+

 

ShankerV_1-1681747655434.png

 

Input was:

ShankerV_0-1681747643965.png

 

Many thanks

Shanker V

nagakavyasri
12 - Quasar

If the output includes space:

 

nagakavyasri_0-1681749209188.png

 

Labels