Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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 |
Solved! Go to Solution.
Text.TrimEnd( Text.Replace( your_string, "~DE", "" ), "~" )
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
Text.TrimEnd( Text.Replace( your_string, "~DE", "" ), "~" )
this?
Text.Replace( Text.Replace( your_string, "~DE", "" ), "~", "" )
>Add Custom Column :
> Text.Select([Column],{"A".."z","0".."9"})
@MasterSonic you want remove or split if you split it will be blank but if you no need split column so you can delete.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.