Split Alphanumeric

[revansh]

Hi ,

Is there a dax function to separate alphanumeric values.

My Column:

A15

B20

A09

G33

output as 2 columns:

Col1    Col2

A         15

B         20

A         09

G         33

tHANKS

[Eric_Zhang]

@parry2k

Or a more compatible approach, the column should be in a "^[a-zA-Z]{1,}[0-9]{1,}$" regex pattern.

let
    Source = Table.FromRows({{"A15"},{"B20"},{"C09"},{"G33"},{"FE121"},{"ABC2"}},{"Column"}),
    FirstNumberPosition= Table.AddColumn(Source, "index", each Text.PositionOfAny([Column],{"0","1","2","3","4","5","6","7","8","9"})),
    addAlphabetsColumn= Table.AddColumn(FirstNumberPosition,"alphabets",each Text.Range([Column],0,[index])),
    addNumbersColumn= Table.AddColumn(addAlphabetsColumn,"numbers",each Text.Range([Column],[index]))
     
in
    addNumbersColumn

[parry2k]

Does length of your column is always the same and 1st character is alphabet, if that is the case then you can use right or left function, no?