Forum Discussion

MasterSonic's avatar
MasterSonic
Icon for Helper IV rankHelper IV
3 years ago
Solved

Struggling to remove ~DE and ~

Hi guys, I need some fresh idea, how to remove ~DE and ~ from the end the string please? Majority of column has ~DE, which is easy to do remove (text after delimiter) But after removing it I have ...
Need Help
  • AlienSx's avatar
    AlienSx
    3 years ago
    Text.TrimEnd( Text.Replace( your_string, "~DE", "" ), "~" )
MasterSonic's avatar
MasterSonic
Icon for Helper IV rankHelper IV
3 years ago

Hi guys,

resutls I am looking is this :
removing ~DE and ~(if last character only)

IDColumn
1triglyceride glue
2lututudu glue
3product 1
4produict 1~4



I will try with spliting perhaps

 

  • AlienSx's avatar
    AlienSx
    Icon for Super User rankSuper User
    3 years ago
    Text.TrimEnd( Text.Replace( your_string, "~DE", "" ), "~" )