5 Replies Latest reply on Aug 10, 2016 12:44 PM by philipHPG

    Calculation field that get words and information between two characters

    egbaumier

      I need a calculation field that can get all words, letters or numbers between two characters in a text field.

       

      For example,

       

      Register (1)  

      05:00:01 AM - John Doe - Start Up! Plan20

      Calculation Field should get all information between both "-". It means = John Doe

       

      Register (2)

      11:20:01 AM - John Davis Stuart - retrofit, call back key account

      Calculation Field should get all information between both "-". It means = John Davis Stuart

       

      Is there any suggestion how to do it?

       

      Regards,

       

      Edison