Forum Discussion

alfordtp's avatar
alfordtp
Frequent Visitor
8 years ago
Solved

Extract text until first number

I have a column that lists model numbers.  For example:   ABC24 XY34 QWERTY985 ID-25   As you can see, the number isnt always in the same spot, so its not as easy as saying grab the left 2 cha...
Need Help
  • Anonymous's avatar
    Anonymous
    8 years ago

    alfordtp In Power BI click on Edit Queries and then click on "Add Column" Tab and click "Custom Column" and then type the query below. The [data] can be replaced with your column name. [<col name>]

     

    =Text.Select([data],{"0".."9"})

     

     

    or you could find the first occurance of a number using the following code(this is also custom column in power query editor)

     

    =Text.PositionOfAny([data],{"0".."9"})

Anonymous's avatar
Anonymous
Not applicable
8 years ago

alfordtp In Power BI click on Edit Queries and then click on "Add Column" Tab and click "Custom Column" and then type the query below. The [data] can be replaced with your column name. [<col name>]

 

=Text.Select([data],{"0".."9"})

 

 

or you could find the first occurance of a number using the following code(this is also custom column in power query editor)

 

=Text.PositionOfAny([data],{"0".."9"})