7 Replies Latest reply: Jun 5, 2014 12:44 PM by Jacob Kean RSS

    String within string

    Nemanja Momic

      Hello all,

       

      I have a small problem.

      I'm pretty new with qlikview, and I'd appreciate your help.

      I have a values in table that is a path to a file.

      Ex: c:\qlikview\projects\testOne\some other files

            c:\qlikview\projects\testTwo\some other files

            c:\qlikview\projects\testFive\some other files

      I would like to extract the part between projects\ and \some other files.

      Because it is not always the same number of characters, i do not know how to do it.

       

      Please help