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...
jcastr02Post Prodigy
Post ProdigyHello 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. |
lbendlin
Super User
Super UserThis 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.