英文:
Web Query missing css elements in the table
问题
我在使用网络查询NCSL免责选民表(<https://www.ncsl.org/elections-and-campaigns/table-2-excuses-to-vote-absentee>)。该表使用此元素来标记我想显示为true的单元格:
<td>
<ul>
<li>::before
&nbsp;</li>
</ul>
</td>
当我查询时,无法将这些单元格视为包含任何内容。我漏掉了什么?
英文:
I using a web query on the NCSL Excuse Absentee Voting Table (<https://www.ncsl.org/elections-and-campaigns/table-2-excuses-to-vote-absentee>). The table uses this element to mark cells that I would like to show as true:
<td>
<ul>
<li>::before
&nbsp;</li>
</ul>
</td>
When I query this I cannot get it to read those cells as having anything in them. What am I missing?
答案1
得分: 1
这似乎有效。在处理之前,将项目符号替换为XXX。
let Source = Web.Contents("https://www.ncsl.org/elections-and-campaigns/table-2-excuses-to-vote-absentee"),
Source1 = Text.Combine(Lines.FromBinary(Source, null, null, 65001)),
Source2 = Text.Replace(Source1, "<ul><li> </li></ul>", "XXX"),
Source3 = Web.Page(Source2){0}[Data]
in Source3
英文:
This seems to work. Replaces the bullet with XXX before processing
let Source = Web.Contents("https://www.ncsl.org/elections-and-campaigns/table-2-excuses-to-vote-absentee"),
Source1= Text.Combine(Lines.FromBinary(Source, null, null, 65001)),
Source2=Text.Replace(Source1,"<ul><li>&nbsp;</li></ul>","XXX"),
Source3=Web.Page(Source2){0}[Data]
in Source3
通过集体智慧和协作来改善编程学习和解决问题的方式。致力于成为全球开发者共同参与的知识库,让每个人都能够通过互相帮助和分享经验来进步。
评论