Carol, I assume all text is hold by one field. This can be done several way. There are no correct answer.
Step 1) Use REPLACE and replace the text "Manager:" with a control character. # is a good control character. Step 2) Find the position of the control character. Step 3) Use REPLACE and replace the text "Title:" with the control character. Step 4) Find the position of the control character. Step 5) Use positions found in step 2 and 4, then use RIGHT and LEFT and parse out the Managers Name. If you also want to the Location and the Tile stripped out I would have made a guide and made a loop and worked my way down from the top. Regards, Terje -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[email protected]] On Behalf Of Carol Carnevali Sent: Wednesday, November 27, 2013 2:02 PM To: [email protected] Subject: How to Parse a variable character string 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"
