1 Reply Latest reply on Apr 17, 2013 1:57 PM by Tracy Rodgers

    Text pulled from Access database has RTF tags, need help removing

    Johnny Carter

      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.