Forum Discussion

kenchan's avatar
kenchan
Frequent Visitor
4 years ago
Solved

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 the...
Need Help
  • v-kkf-msft's avatar
    v-kkf-msft
    4 years ago

    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.

     

v-kkf-msft's avatar
v-kkf-msft
Community Support
4 years ago

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.