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

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

Book1.xlsx

Parse

Accepted answers

BenMoss

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

All comments

Philip

I'd use a RegEx.

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

Parse String.yxmd

BenMoss

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!

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15878

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703