Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

how to extract a value no numeric as alphanumeric ?

hi,   I look for a function for desktop and/or query   My goal is to extract a value no numeric to get in a new column as a type.  For instance    Number                                   New ...
Need Help
  • Gordonlilj's avatar
    Gordonlilj
    6 years ago

    Hi,

     

    You could try using the split function in power query. Perhaps by non-digit to digit would work in your case

     

     

Gordonlilj's avatar
Gordonlilj
Solution Sage
6 years ago

Hi,

 

You could try using the split function in power query. Perhaps by non-digit to digit would work in your case