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