Forum Discussion
Remove String Word in PowerBI
Hi Expert, this is Ken, a beginer of PowerBI.
I collect some email from HTML to text. However, there are a long of string or character which impact my analysis; I would like to remove it. Is there specific function which can help to to remove the String below?
Text Characters/String I would like to remove:
[cid:0.28869237......181230d22e3__inline__img__src]
[https://......?id=01570000001okLb&oid=00D300000000bzv]
[data:image/....]
B.R.
Ken
Hi kenchan ,
Please add the custom column in Power Query Editor.
= List.RemoveItems(List.Select(Splitter.SplitTextByAnyDelimiter({"[", "]"})([Original Data]), each not (Text.StartsWith(_, "cid",Comparer.OrdinalIgnoreCase) or Text.StartsWith(_, "https",Comparer.OrdinalIgnoreCase))), {"",null," ","#(lf)"})Then extract values from the list.
If the problem is still not resolved, please provide detailed error information or the expected result you expect. Let me know immediately, looking forward to your reply.
Best Regards,
Winniz
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
3 Replies
Add an example for easy understanding.
I want to remove the string. Sometimes, some cells may inlcude both 1 and 2 situation.
1. start with "[cid" and end with "]"
1. start with "[https" and end with "]"
Original Data My expected outcome ABC
[cid:0.28869237......181230d22e3__inline__img__src]
ABC xxxx [https://......?id=01570000001okLb&oid=00D300000000bzv]
xxx Original Data My expected outcome ABC
[cid:0.28869237......181230d22e3__inline__img__src]
ABC xxxx [https://......?id=01570000001okLb&oid=00D300000000bzv]
xxxx
Hi kenchan ,
Please add the custom column in Power Query Editor.
= List.RemoveItems(List.Select(Splitter.SplitTextByAnyDelimiter({"[", "]"})([Original Data]), each not (Text.StartsWith(_, "cid",Comparer.OrdinalIgnoreCase) or Text.StartsWith(_, "https",Comparer.OrdinalIgnoreCase))), {"",null," ","#(lf)"})Then extract values from the list.
If the problem is still not resolved, please provide detailed error information or the expected result you expect. Let me know immediately, looking forward to your reply.
Best Regards,
Winniz
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.