Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Remove numbers from the Text in Power BI

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

Need Help
  • CNENFRNL's avatar
    CNENFRNL
    5 years ago

    Hi, Anonymous , you might want to try

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

3 Replies