2 Replies Latest reply: May 24, 2014 10:37 PM by Rob Wunderlich RSS

    Cleaning up a data string with < > delimeters

    Ben Shreeve

      Hi,

       

      I'm trying to clean up data I'm getting from a forum db. The problem I'm having is that the body of the conversations include formatting tags. So in order to just leave the text parts I need to remove the tags. Fortunately all of the markup used is contained within < and >. How do I go about saying:

       

      Clean(Field, Delete text from '<' to '>')

       

      Is this possible?

       

      E.g. the follow is what I currently have:

       

      "anyone who has access to this forum should be on this list<br /><br /><br />Project Leader:<br /> Legacy<br /><br />Lead Artist:<br />"

       

      and I want to just reduce it to "anyone who has access to this forum should be on this list Project leader: Lead Artist:"

       

      UNLESS - there is a way to get Qlikview to actually use these tags and format these messages properly!

       

      Thanks!