AnsweredAssumed Answered

Calculation field that get words and information between two characters

Question asked by egbaumier on Aug 10, 2016
Latest reply on Aug 10, 2016 by philipHPG

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

Outcomes