Hi Dan,
Here is something that will return all the characters from the first
non blank character after !536870951!: to the line feed. As you all
ready know, you would have to change substr and strstr to substrc and
strstrc.
LTRIM(LEFT(SUBSTR($Text Body$, STRSTR($Text Body$, "!536870951!:") +
12, STRSTR($Text Body$, "!536870951!:") + 44), STRSTR(SUBSTR($Text
Body$, STRSTR($Text Body$, "!536870951!:") + 12, STRSTR($Text
Body$, "!536870951!:") + 44), "
")))
It's not pretty or elegant, but I hope it helps you,
Julie
At 12:58 PM 1/2/2007, you wrote:
**
Hi there,
I need to create certain requests from specific incoming emails.
I already created a new form in which I push the subject and mail
body from AR System Email Messages when a new mail comes in (if the
subject is containing a specific string).
Now I have the mail body field in my new form and I need to extract
specific values out of this to push it into a new request.
The mail body looks like this:
========================
text text text
text text
field 1: field value 1
field 2: field value 2
text text
field 3: field value 3
text
========================
So, how can I extract the "field value x" strings with a SetField action?
I guess it must work somehow in combination with SUBSTRC and STRSTRC
function, right?
Any help is really appreciated!
Thanks in advance.
Dan
PS: The field values can contain german umlaut characters. I hope
this is not a problem.
__20060125_______________________This posting was submitted with
HTML in it___
-------------------------------------------------------
Julie Rockwood
Los Alamos National Laboratory
IST-APPS3 BMC Technical Lead
(505) 667-9846
_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers
Are"
