4 Replies Latest reply on Aug 14, 2017 6:28 AM by Imran Azam

    need help pulling out a  lenth of words from a long lenth of text

    Imran Azam

      Hi guys

       

      I need to create a calculation field that would pick out the text between first dash ( / )and the second  full stop (.) ( so after the first dash and before the second full stop)

       

      I have a long list of text and for each one I need to pull out a certain length as shown below

       

      for example

       

      from: /aa/aaas3/9/ROOT/testing.worksheet.2.1-1-89876532145615263  I want to a calculation field that would get this:  testing.worksheet.7.2

       

      The mid function  wont work as all the texts  length is different , I can only define the search by the fifth dash and  before the second .

       

      can anyone help

       

      if I don't make any sense I am sorry