Forum Discussion
MasterSonic
Helper IV
Helper IVStruggling 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 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 |
Text.TrimEnd( Text.Replace( your_string, "~DE", "" ), "~" )
5 Replies
- Mahesh0016
Super User
MasterSonic you want remove or split if you split it will be blank but if you no need split column so you can delete.
- Mahesh0016
>Add Custom Column :
> Text.Select([Column],{"A".."z","0".."9"}) - AlienSx
this?
Text.Replace( Text.Replace( your_string, "~DE", "" ), "~", "" ) 
MasterSonicHi 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
Text.TrimEnd( Text.Replace( your_string, "~DE", "" ), "~" )
