Remove numbers from the Text in Power BI

[Anonymous]

Hi,

I have one field in Power BI 'Manager_Name'. The data is in below format:

Manager_Name

Ali Erik (202682)

Organization (Lisa Anderson (205616)

Organization (Amy Wang (152237))

Cat Jack (On Leave)

I want to remove bracket and number from the filed. So the result should be as below:

Result

Ali Erik

Organization (Lisa Anderson

Organization (Amy Wang)

Cat Jack (On Leave)

I tried using below expression:

Text.Combine(List.RemoveItems(Text.ToList([Manager_name]),{"0".."9"})) 

but it can remove only numbers but not brackets "()".

I would appreciate any help on this.

Thanks,

Rinku

[CNENFRNL · Accepted solution]

Hi, @Anonymous , you might want to try

#"Added Custom" = Table.AddColumn(Source, "Custom", each Text.Replace(Text.Remove([Manager_Name], {"0".."9"}), "()", ""))

[Anonymous]

Hi @CNENFRNL ,

I just tried the same thing. It's working great. Thanks!

-Rinku

[amitchandak]

@Anonymous , refer if these can help. You may have get number and replce it with ""

https://eriksvensen.wordpress.com/2018/03/06/extraction-of-number-or-text-from-a-column-with-both-text-and-number-powerquery-powerbi/

https://radacad.com/remove-digits-or-keep-them-in-power-bi-using-power-query