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
@nobbsl
I am using RegEx to check if the first letter is number of letter.