Hi,
You need start and end position to get the name.
Something like
SUBSTRC($f$, STRSTR($f$, "Manager: ") + LENGTHC("Manager: "), STRSTR($f$,
"Manager: ") - 1)
The -1 at the end might need to be changed to 2, depending on if your system
uses CR+LF or just LF for "carriage return".
Let us knw how it works out.
Best Regards - Misi, RRR AB, http://www.rrr.se (ARSList MVP 2011)
Ask the Remedy Licensing Experts (Best R.O.I. Award at WWRUG10/11/12/13):
* RRR|License - Not enough Remedy licenses? Save money by optimizing.
* RRR|Log - Performance issues or elusive bugs? Analyze your Remedy logs.
Find these products, and many free tools and utilities, at http://rrr.se.
> Hello,
>
> I am trying to use Functions to parse out the manager's name from a character
> field that will always have the same format (see below) but, of course, the
> manager's name will be different in each case.
>
> Locations: 2 JSQ
> Manager: Dowling, John
> Title: Contingent Worker
>
> Note that there is a carriage return after the name and before "Title".
>
> Can anyone give me the Set Fields actions that would do this?
>
> Thanks.
> Carol
>
> _______________________________________________________________________________
> UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
> "Where the Answers Are, and have been for 20 years"
>
_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
"Where the Answers Are, and have been for 20 years"
