Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Remove additional character in HTML

Hello All,   I have a column that is in HTML format. I would like to keep the column as HTML and display HTML in my report. But I have additional characters "&?". I want to remove this addition...
Need Help
  • Anonymous's avatar
    Anonymous
    5 years ago

    Made following change in the script and it worked.

     

     

    (HTML as text) =>
let
    Source = Text.From(HTML),
    SplitAny = Text.Split(Source,"amp;?"),
    ListAlternate = List.Alternate(SplitAny,1,1,1),
    ListSelect = List.Select(ListAlternate, each _<>"&"),
    TextCombine = Text.Combine(ListSelect, " ")
in
    TextCombine

     

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Anonymous hello I found the sample query in one of the posts. Would you be able to help me out?

v-deddai1-msft's avatar
v-deddai1-msft
Community Support
5 years ago

Hi Anonymous ,

 

Would you please try to use the following m-query?

 

(HTML as text) =>
let
    Source = Text.From(HTML),
    SplitAny = Text.SplitAny(Source,"<>"),
    ListAlternate = List.Alternate(SplitAny,1,1,1),
    ListSelect = List.Select(ListAlternate, each _<>""),
    TextCombine = Text.Combine(ListSelect, "")
in
    TextCombine

 

Please refer to the similiar post: https://social.technet.microsoft.com/Forums/office/en-US/b080d122-14f0-43bc-8a86-f50cdf1c32d8/removing-html-tags-when-source-is-sharepoint-list?forum=powerquery

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

 

Best Regards,

Dedmon Dai