I have a column of number strings that I would like to break into separate parts, each in its own unique column Each set of numbers that constitute the entire string represent different facets of an item that's identified by the entire string.
For example 8097645834 could break down to something like this:
809 for department
764 for division
5834 for subgroup
Solved! Go to Solution.
Philips answer is definitely the way to go with this, though if you fancy learning about the string functions available in alteryx then you could create three formulas.
Part 1: left([Field],3)
Part 2: Substring([Field],3,3)
Part 3: right([Field,4)
Ben
Cool thanks for the example!
Still getting the hang of the syntax, so this is definitely good to know - thanks!