在 Power BI 中将 HTML 表转换为纯文本 [英] Convert HTML Table to plain Text in Power BI

问题描述

我是 Power BI 的初学者.我必须创建一个包含共享点数据的报告.我已将数据导入数据集.但是，某些列的文本带有 html 表格标签或样式，如下所示 -

I am a beginner in power BI. I have to create a report with share point data. I have imported the data into dataset. However, some columns have text with html table tags or style like below -

<div class="ExternalClass5DA0D04953B047459697675F266FEABF">
   <p>​</p>
   <table width="395" border="0" cellspacing="0" cellpadding="0" style="width&#58;296pt;">
  <tbody>
     <tr height="115" style="height&#58;86.4pt;">
        <td width="395" height="115" class="xl64" style="width&#58;296pt;height&#58;86.4pt;">
        I am working on issue. I shall update the progress.&#160;<br>
        </td>
     </tr>
  </tbody>
   </table>
   <p><br></p>
</div>

但我只想显示纯文本，即我正在处理问题.我将更新进度."

But I would like to show the plain text only which is "I am working on issue. I shall update the progress."

推荐答案

从此社区线程，你可以找到一个方便的功能 用于剥离所有 HTML 标签:

From this community thread, you can find a handy function for stripping all the HTML tags:

这是核心逻辑(为了便于阅读，忽略文档元数据):

Here's the core logic (ignoring the documentation metadata for readability):

let func = (HTML) =>
    let 
        Check = if Value.Is(Value.FromText(HTML), type text) then HTML else "",
        Source = Text.From(Check),
        SplitAny = Text.SplitAny(Source,"<>"),
        ListAlternate = List.Alternate(SplitAny,1,1,1),
        ListSelect = List.Select(ListAlternate, each _<>""),
        TextCombine = Text.Combine(ListSelect, "")
    in
        TextCombine
 in 
    func

有了这个方便的代码，创建一个新的空白查询并将上面的代码粘贴到高级编辑器中，并为其命名，例如 TextFromHTML.

Having this handy bit of code, create a new blank query and paste the above code into the advanced editor and give it a name, say, TextFromHTML.

一旦定义了该函数，就可以在任何查询中使用它.例如，转换列 ColWithHTML 的步骤可能如下所示:

Once you have that function defined, you can use it in any of your queries. For example, here's what a step to transform the column ColWithHTML might look like:

Table.TransformColumns(#"Prior Step", {{"ColWithHTML", each TextFromHTML(_), type text}})

这篇关于在 Power BI 中将 HTML 表转换为纯文本的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！