Separation of data in each cell

[jaywalker12]

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

[apathetichell]

TTC and regex parse attached.

[TheOC]

hey @jaywalker12 

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

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

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

[vizAlter]

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)

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

(\d+F)(.*)

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

(\d+)(F.*)

Please mark this solved if it helps.