Convert HTML column to plain/formatted text in Power BI

I need to conver HTML column in plain text. I've watched some tutorials and added a custom column with the following coding in Power Query: Html.Table([HTML text],{{"Plain text",":root"}}) This does...

Need Help

Tips and Tricks

Sahir_Maharaj

Super User

2 years ago

Hello sardo,

Can you please try the following:

1. Before converting HTML to text, you should replace or remove null values to prevent errors during the conversion process (Use the "Replace Values" in Power Query)

2. Extract text from the HTML using M code

let
    HtmlToText = (html as text) as text =>
    let
        // Replace HTML tags with empty strings
        Step1 = Text.Replace(html, "<", " <"),
        Step2 = Text.Split(Step1, "<"),
        Step3 = List.Transform(Step2, each if Text.StartsWith(_, "/") or Text.Contains(_, ">") then "" else _),
        TextResult = Text.Trim(Text.Combine(Step3, ""))
    in
        TextResult
in
    HtmlToText

3. Use the custom function you've defined by referencing your HTML column: HtmlToText([YourHtmlColumnName])

Note: If your conversion results in a table, you might need to expand it. Hope this helps.