Forum Discussion
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 characters.
In Excel I can create a formula that will extract from the left all the characters until it finds the first number. That doesnt seem to work the same in Power BI. Anyone know how to do this?
Thanks in advance!
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"})
1 Reply
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"})