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"} & {"-"})