Removing brackets and numbers included in brackets

[atin]

Remove numbers & brackets

Hi All

Please can you tell me how to remove the numbers that are embedded in a bracket including the brackets as well 

e.g Looking at a country & its population, the data set has the following numbers 

1.  India 1,040,000,000[1]
2. Cyprus 835,000[9]
3. Madagascar 18,606,000[3]

how do I remove these numbers including the brackets in power bi, whilst not using R

I am only interested in the population numbers.

Many thanks 

[Pascal_KTeam]

Hi

In Power Query Designer you can select the value column and go to "Transform" - "Extract" - "Text Before Delimiter" and then add "[" as delimiter         

[Anonymous]

At the top of the column where it says ABC, click and select number and see what affect that has on the result?

If that data has the [6] as part of the text, then that maybe related to an footnote, and you will need to strip it out, maybe using the SUBSTITUTE command?

[ammcleod · Accepted solution]

Hi @atin ,

In the Query Editor, you could highlight the column "Population 2000 estimate" and Split the Column by Delimiter. Make the Delimiter "[" and the column should be split by the start of the Bracket. 

From there you can go ahead and delete the second column that holds the rest of the Bracket and the number inside. 

Let me know if this works for you!