Struggling to remove ~DE and ~

[MasterSonic]

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 few rows like 3 (example below), that are blank after that process.

Can I ask you for some idea how to process that please?

ID	Column
1	triglyceride glue~DE
2	lututudu glue~DE
3	product 1~
4	produict 1~4

[MasterSonic]

Hi guys,

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

ID	Column
1	triglyceride glue
2	lututudu glue
3	product 1
4	produict 1~4

I will try with spliting perhaps

[AlienSx · Accepted solution]

Text.TrimEnd( Text.Replace( your_string, "~DE", "" ), "~" )

[AlienSx]

this? 

Text.Replace( Text.Replace( your_string, "~DE", "" ), "~", "" )

[Mahesh0016]

>Add Custom Column :
  > Text.Select([Column],{"A".."z","0".."9"})

[Mahesh0016]

@MasterSonic  you want remove or split if you split it will be blank but if you no need split column so you can delete.