Remove String Word in PowerBI

[kenchan]

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

[v-kkf-msft · Accepted solution]

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.

[kenchan]

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

[kenchan]

Original Data	My expected outcome
ABC [cid:0.28869237......181230d22e3__inline__img__src]	ABC
xxxx [https://......?id=01570000001okLb&oid=00D300000000bzv]	xxxx