Extract number from string power bi

Question

How to extract only numbers from text in power bi?

I have the below table, and I need to create a new caclulated column to keep only numbers from string?

string and number	Result only number
Alex2020A1	20201
Sara2021A2	20212
Karlos2022A500	2022500

Answer 1

Power BI: How to Extract only numbers from String?

To remove all characters and show only numbers in a string in Power BI, you should do the following:

Steps

1. At the Home tab, click on "Edit Queries".

   

2. The Power Query Editor would be Opened.
3. From the left side, Select your table.

4. At the Add column tab, click on Custom Column.

   

5. Write the below formula based on your column name.

Using Text.Select()

You can use Text.Select() to extract only numbers from a string in Power BI

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

Using Text.Remove()

Also, You can use Text.Remove() to extract only numbers from a string in Power BI

= Text.Remove([String],{"A".."z"})

Output

---

Download

• Working with characters and numbers in Power BI.