Hi All,
I am getting an email in a mail box that contains information in the Body Field such as
First name:ac
Last name: ac
Date: 08/25.2008
Category Type: capillary
product1:
product2:
Title: Analyst
Organisation name: Semcor
Region: XYZ
Item Description: This is just a test information
Email ID of the person: xyz@gmail.com
and so on
I need to pass / map these fields in one of the Form that contain corresponding Fields in a separate database …called Information Log Database…(and the Log Form has the fields above before the “:”
I need to create an agent in the Mail Database , --that will be run , when new mail arrives for every document that comes in the mail with subject “Contact _Us” in the subject line to automatically create documents in the Information log Database and parse /map information in the body field to the Document in the Information Log Database…(Call Log)
How can I achieve this …
Please help
Thanks in advance,
ac ac
Subject: How can I parse / map information that is in the body Field of an email to Notes Form on a separate database—Please help
no need to repost
http://www-10.lotus.com/ldd/nd6forum.nsf/DateAllThreadedweb/9f2df56cecdf8d21852574b0004ca4f4?OpenDocument
Subject: How can I parse / map information that is in the body Field of an email to Notes Form on a separate database—Please help
As someone suggested, there are lots of answers if you search for parse and string.
Basically you will need to pull the Body contents into a string.
then you will need to parse out the information you want.
For example:
Firstname is between First name: and Last name:
so you would pull the text to the right of First name: and to the left of Last name: to get the firstname value.
They’d you’d get the Last name, which is between Last name: and Date:
so you would pull the text to the right of Last name: and to the left of Date: to get the firstname value.
What code have you written so far? If you post your code, people might be able to help you with your logic and Lotusscript.