Forum Discussion
Remove String Word in PowerBI
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.
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 |