Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Remove HTML tags from columns

Hello, I want to remove the HTML tags from my text columns, I tried multiple solutions on the community forum but even when I get something working I get an error in my custom column. The error is "...
  • AlB's avatar
    AlB
    3 years ago

    Anonymous 

    You were almost there. I believe there's only a simple error in your code for the custom column. You had:

     

    Html.Table([[Column1]], {{"ExtractedText",":root"}})

     

     with  [[Column1]] where you only need one set of [ ]:

     

    Html.Table([Column1], {{"ExtractedText",":root"}})

     

    That is why PQ was interpreting as a record

    See it at work in the attached file (Table1, I've left your original query untouched)

    Please accept the solution when done and consider giving a thumbs up if posts are helpful. 

    Contact me privately for support with any larger-scale BI needs, tutoring, etc.