Forum Discussion
jcastr02
Post Prodigy
Post Prodigyexpanding custom column from Html column
I have an HTML Column that I'm trying to convert to text. I use the formula for custom column Html.Table([my column], {{"text", ":root"}})) I do have Blanks from the HTML Column When I cre...
lbendlin
Super User
Super UserPlease provide sample data that fully covers your issue.
Please show the expected outcome based on the sample data you provided.
jcastr02Hello lbendlin - see below I'm trying to convert the NeedtoKnow column to the expected outcome column - it seems the null values are causing issues (even though I replace null values with "".
Id LOB Subject NeedtoKnow Expected Outcome 248 Central Utility CRSM: Change Healthcare Cyber Security Issue null 249 Central Utility CRSM: Change Healthcare Cyber Security Issue null 250 Central Utility CRSM: Change Healthcare Cyber Security Issue null 251 Central Utility CRSM: Change Healthcare Cyber Security Issue null 252 Central Utility CRSM: Change Healthcare Cyber Security Issue null 253 Test This is a test of the communication application <div class="ExternalClass2A5FD88EB9564E91B94F781A7C0166CE"><p>This will be the need to know section.</p></div> This will be the need to know section 254 Test This is a test of the communication application <div class="ExternalClass9BE4188F1B224A2AB16E5580E9D5AA98"><p><span style="font-size:11pt;"><span><span style="font-size:15.0pt;">This will be the need to know section.</span></span></span></p></div> This will be the need to know section. 256 PCC REMINDER: SOP 2.10.1 Linking Buyout Profiles <div class="ExternalClassB797D798C5B44B18AB82CE2DB706A4E2"><p><span style="font-size:11pt;"><span>When acquires a competitor pharmacy, the patient profile/prescription records can be located in the “Buyout Search” tab in POWER.</span></span></p></div> When acquires a competitor pharmacy, the patient profile/prescription records can be located in the “Buyout Search” tab in POWER. 
ryan_mayumaybe you can try this in PQ
= Table.AddColumn(#"Promoted Headers", "Custom", each Text.BetweenDelimiters([NeedtoKnow],".",">",{0,RelativePosition.FromEnd},{0,RelativePosition.FromEnd}))
- lbendlin
This is bad HTML. As a minimum add a class tag to the inner span, and make the usage of span consistent.
You can use the HTML parser to get to the payload.