Text to Column Split

[TomH1]

I am having issues using Text to Column in order to split consecutive digits into two columns to ultimately run a chart of accounts. Is there also a way I can assign these fields a title (I.E. 11 = Current Asset, 12 = Non-Current Asset etc)

From

Field 1

110002

111003

123003

124001

210011

221003

To

Field 1	Field 2
11	0002
11	1003
12	3003
12	4001
21	0011
22	1003

[MarqueeCrew · Accepted solution]

How about....

Left([field],2)

And

Right([field],4)

As formulas for your two fields.

Cheers,
Mark

[TomH1]

Thanks Mark, that worked well! Love your work.

Any idea how to now assign a title to consecutive digits? I.E. 11 = Current Assets, 12 = Non-Current Assets etc

Cheers,

Tom

[MarqueeCrew · Accepted solution]

It depends on how many values that there are.

Switch([field],”Unknown”,’11’,’Current Assets’,’12’,’Non-Current Assets)

If there are many values you can use a Find and Replace Tool.

https://community.alteryx.com/t5/Alteryx-Knowledge-Base/Tool-Mastery-Find-Replace/ta-p/47042

Cheers,

Mark

[JoshKushner]

You can use the select tool to rename the headers

Flow:

Select:

[JoshKushner]

Nevermind, misinterpreted the question. @MarqueeCrew is spot on with the switch.

[TomH1]

Thanks mate, that's worked well.

[azfersaeed]

@JoshKushner Select Tool is what I was looking for, thanks!