how to extract a value no numeric as alphanumeric ?

Question

hi,&nbsp;I look for a function for desktop and/or query&nbsp;My goal is to extract a value no numeric to get in a new column as a type.&nbsp;For instance&nbsp;&nbsp;Number&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;New column ( as Type)INC000&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; INCDMND00032&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;DMNDPRJ4444&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; PRJ&nbsp;How to do it ?&nbsp;Thank you in advance for your return and your help .Sincerely

gordonlilj · Accepted Answer

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

Forum Discussion

how to extract a value no numeric as alphanumeric ?

2 Replies

Related content

Extract Alphanumeric Value from String

Numeric Sorting of Alphanumeric

Extract alphanumeric words from a Power Query text string

Convert alphanumeric to numeric

Pulling numeric-only values from a alphanumeric field