Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

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

Separation of data in each cell

jaywalker12
7 - Meteor

Hi There,

 

Is there a way to just separate the data after the "F" in my column and put it into a new column? 

 

Many Thanks

3 REPLIES 3
apathetichell
18 - Pollux

TTC and regex parse attached.

TheOC
15 - Aurora
15 - Aurora

hey @jaywalker12 

If its consistently 5 digits after the F, we can just take the last 5 digits of the ID field:

TheOC_0-1620856237669.png


If it doesn't work like this, then i would suggest a single Regex tool, to grab all data after 'F':

TheOC_1-1620856323946.png


I've attached this as a workflow, i hope it helps!
TheOC


Bulien
vizAlter
12 - Quasar

Hi @jaywalker12 — Welcome to the Alteryx Community!

 

Try these solution:

 

1st method — If you just want to keep the string which is after the 1st "F" char, then use a "Text to Columns" tool and configure like below:

(FYI, 1st "F" char will act like a splitter, hence will be dropped)

vizAlter_0-1620859781272.png

 

2nd method — If you want to split the string when "F" char should be displayed with the left side string:

(\d+F)(.*)

vizAlter_3-1620860882520.png

 

 

3rd method — If you want to keep "F" letter with the right side string like below:

(\d+)(F.*)

vizAlter_4-1620861032349.png

 

Please mark this solved if it helps.

Labels