2 text-parsing calculation questions

[Steven Cappiello]

Hi there,

could someone recommend how I should approach:

1. grabbing the email address that comes after the word "Requestors: " out of a field that has the following information:

Mon Oct 01 15:51:24 2007: Request 7897 was acted upon.

Transaction: Ticket created by [email protected]

Queue: cbio-faculty-search

Subject: rec letter for Dr. John Smith

Owner: Nobody

Requestors: [email protected]

Status: new

blah blah blah blah blah...

and

2. Grab the first name and last name out of a From field that contains the following?

"John Smith via RT"

many thanks in advance

[comment]

This should help you with your fist question:

http://www.fmforums.com/forum/showtopic.php?tid/172999

I am not sure there IS an answer to your second question, since every sender can call themselves whatever they want, e.g.

"John Smith via RT"

or

"Smith, John via RT"

or even

"PsychoKiller"

[Steven Cappiello]

Thanks comment! I think this answers the 2nd part too-- it's almost always going to be

"First name Last Name via RT" since RT is a system that is generating that email header.

I'll grab the first " and the text "via RT"..

figure out what is in the middle and then use leftwords and rightwords