Forum Discussion

revansh's avatar
revansh
Helper IV
9 years ago

Split Alphanumeric

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 ...
Need Help
Eric_Zhang's avatar
Eric_Zhang
Microsoft Employee
9 years ago

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