Extract text from one field to another
Hi, is it possible to extract text from one field to another based on a specific word or string? I have been playing around with the right function but I am not getting the results I need. As an example I would like to extract the data in bold type for each question. So couldn't you have a formula that would look for "in the appeal:" and give the result "W123456789"?
1) Please enter the ID at the top of your letter in the appeal:
W1234567890
2) On a scale of 1-5 how satisfied are you :
With the time it took to resolve the appeal once you submitted it to the appeals department: Not at all Satisfied with the time it took
That you were treated fairly?: Not at all Satisfied that I was treated fairly
That the response you received was clear and easy to understand?: Not at all Satisfied was easy to understand
With your choices of how to correspond with us about your appeal?: Not at all Satisfied with my choices
------------------------------
John Kelley
------------------------------
1) Please enter the ID at the top of your letter in the appeal:
W1234567890
2) On a scale of 1-5 how satisfied are you :
With the time it took to resolve the appeal once you submitted it to the appeals department: Not at all Satisfied with the time it took
That you were treated fairly?: Not at all Satisfied that I was treated fairly
That the response you received was clear and easy to understand?: Not at all Satisfied was easy to understand
With your choices of how to correspond with us about your appeal?: Not at all Satisfied with my choices
------------------------------
John Kelley
------------------------------
