Forum Discussion

Cyrilbrd's avatar
Cyrilbrd
Icon for Helper IV rankHelper IV
6 years ago
Solved

Text.Remove

Given a series of model code such as: BONH-P-M-16 CAN-BL-A17 88-R-AC-19 Said column also contain blanks. New calculated column need to return the following: BONH-P-M CAN-BL-A 88-R-AC Present...
Need Help
  • ImkeF's avatar
    ImkeF
    6 years ago

    Hi Cyrilbrd 

    if you want to do this via the UI, you add a custom column and paste in this formula:

     

    Text.TrimEnd([product_name], {"0".."9"} & {"-"})

     

     

Cyrilbrd's avatar
Cyrilbrd
Icon for Helper IV rankHelper IV
6 years ago

Sorry but I feel you misunderstood my question.

How do I apply your solution?

Once in Power Query Editor, what shall I do? 

Insert a Column?

Thanks.

 

ImkeF's avatar
ImkeF
Icon for Community Champion rankCommunity Champion
6 years ago

Hi Cyrilbrd 

if you want to do this via the UI, you add a custom column and paste in this formula:

 

Text.TrimEnd([product_name], {"0".."9"} & {"-"})