I have a worksheet that connects to an Access query where one of the fields has unfortunately been stored as rich text. When I display this field in Tableau I end up seeing tags like <div> Is there a way to remove these in Tableau or is there any sort of workaround? I've pulled similar things into Excel and there I wrote a macro to find and replace all the tags, but I don't know how to do similar in Tableau. I know Access has a function to make rich text into plain text and I tried using that, but found that it is incompatible with the engine windows uses to connect to Access. Any help would be appreciated.
One way this could be done would be to take an extract of the Access data source and create a calculated field using the Replace function similar to the following:
Replace([Dimension], "<div>", "")
Hope this helps!