We are celebrating the 10-year anniversary of the Alteryx Community! Learn more and join in on the fun here.
Start Free Trial

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.

Formula to split accounting codes in one column into 2 columns

nobbsl
5 - Atom

Hi there, I'm very new to Alteryx and hoping someone can please  help me with a formula.

 

I have an excel spreadsheet with various accounting codes in 1 column (see attached).

 

I need to split the codes into 2 columns based on their leading character i.e. Codes starting with a letter be placed in a new column labelled "Project Code" and codes starting with a number be placed in another column labelled "Cost Centre".

Is anyone able to help me with a formula to do this please?

 

Thanking you in advance

1 REPLY 1
Qiu
21 - Polaris
21 - Polaris

@nobbsl 
I am using RegEx to check if the first letter is number of letter.

0123-nobbsl.png

Labels
Top Solution Authors