We have a Tableau dashboard and one of the data source is SharePoint List, in which one of the column is a Rich Text Field. When we are displaying that column, we are getting the html tags as well. I tried removing HTML tags using Regex “TRIM(REGEXP_REPLACE([Insights], '<.*?>',CHAR(10)))”, but we are loosing the complete format of the column.
4 answers
If you don't want to use REGEXP, use the REPLACE function multiple times and remove any tags that you don't need.
