3 Replies Latest reply: Jul 22, 2012 11:39 AM by stephane jeanneteau RSS

    substring in qlikview?

      Hello,

       

      Is there a way to catch string in value of a field, like substr in SQL?

       

      I would like to catch et text between "from" and "to" of values from "type" field

       

      Example :

      Status Changes From Affected to resolved

      i would like only Affected, between from and To

       

      Load

        type as TYPE

      From

      [\\s-vm-qvw-01\SM7\activity_GCE_RS.qvd]

      (qvd) ;

       

       

      Any idea for helping me?

       

      stephane