Advent of Code is back! Unwrap daily challenges to sharpen your Alteryx skills and earn badges along the way! Learn more now.

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