How to break a long string in one col into 3 diff parts, each in its own new col?

[bkronk]

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

[Philip]

I'd use a RegEx.

If this doesn't answer your question, can you provide more information?

[BenMoss · Accepted 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

[bkronk]

Cool thanks for the example!

[bkronk]

Still getting the hang of the syntax, so this is definitely good to know - thanks!