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

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