4 Replies Latest reply: Jul 19, 2015 8:40 PM by arjun rao RSS

    Mid function along with index function

    Priyanka Pandey

      Hi Team,

       

      I am trying to split phone number column into 3 parts base on a delimiter '-'.

      I know that it's quite easy to resolve the above problem using subfield() function.

      But, I want to try the same using Index function.

      I have successfully achieved the leftmost and the rightmost column but i don't know what mistake i am doing in my logic to achieve the middle part of the phone number.

       

      I have attached my qvw file for your reference.

       

      Regards

      Priyanka