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
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
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.