2 Replies Latest reply: Oct 20, 2016 3:06 AM by Josephinet Tedesco RSS

    Parsing in Qlikview - is this possible?

    Josephinet Tedesco

      Hi All

      I have a field which looks like this:

       

      John(TeamRed)Smith
      John(TeamBlue)Smith
      Barry(TeamRed)Jones
      Barry(TeamBlue)Jones

       

      I need the data between the parenthesis - In Excel I would use Text to Columns - is there a way to do this in Qlikview?

       

      Failing this how could I do this in SQL?

       

      I would prefer not to take the column/data out to Excel and do the work there.

       

      Jo