Advent of Code is now back for a limited time only! Complete as many challenges as you can to earn those badges you may have missed in December. Learn more about how to participate here!
Start Free Trial

Alteryx Designer Desktop Discussions

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

seperate numbers

maxse
6 - Meteoroid

How can i seperate this string into to columns:

 

123 & 456 into

 

column 1   column 2

123           456

maxse_1-1672948200598.png

 

maxse_0-1672948180197.png

 

2 REPLIES 2
Felipe_Ribeir0
16 - Nebula

Hi @maxse 

 

One way of doing this, for this you can avoid the complexity of regex using the text to columns tool

Felipe_Ribeir0_0-1672948391257.png

 

gautiergodard
13 - Pulsar

hey @maxse 

Here is one way to do it:

gautiergodard_0-1672948565210.png

 

Labels
Top Solution Authors