Remove HTML Tags from Column with Null Values

[walker21]

How do I extract the plain text from columns in HTML and exclude null values? I have a column that has a mix of plain text, HTML, and null values.

I tried using "Html.Table([ColumnName] , {{"text",":root"}})" but when it hits a null value, it breaks everything. 

[Chatticha]

' try Html.Table([Column] , {{"text",":root"}}) otherwise null '

[sinigagliafeder]

Hello @walker21 ,
I don't know if you still need assistance but I have a workaround if you need.
Simply replace the null value with NA in the column and then create another column using this formula "Html.Table([ColumnName] , {{"text",":root"}})". 

In this way you will not get the error message 😉