email parsing automation

Email Parser

Extract data from emails and automate your workflow

The forum is now read only. Please, go to the the main Email Parser website if you need help.
Need help configuring the program? Have any questions regarding its use?
I want to extract words in the "Subject" or "Body" of an incoming email and use them as parser fields as follows:

First word becomes field M0
Second word becomes field M1
Third word becomes field M2
Fourth word becomes field M3
The rest of the words become field M4

After extraction I want to insert these fields into a MySQl database table

How do I do this?
Hello,

The best way to do so is to create a regular expression parser and then a MySQL action:
mysql_insert_example.jpg
mysql_insert_example.jpg (9.17KiB)Viewed 4482 times
The regular expression parser looks like this:
example_regexp_parser.jpg
See the attached configuration file. Drag and drop this file on the Email&Parser left panel to load this example.

If you have any other questions feel free to post again.
Attachments
example configuration file
(5.14KiB)Downloaded 590 times
When I drag and drop the example file into the left panel I get the following error message:

"Cannot load EmailAndParser configuration from the file C:\Users\PC\AppData\Local\Temp\822\Setting.xml. Check that the file can be accessed and no other process is using it.

There is an error in XML document (19,6)"
It works! And the example seems to work to.
Thanks a lot
I have a challenge with the example RegEx parser
It does not extract email addresses or web addresses when they are in positions M0, M1, M2 or M3.

I want to be able extract email addresses or web addresses as well. Please advise.
Try the attached settings file. I have updated the regular expression to match also email addresses and urls. In the first post I thought you neeeded only to match "normal" words.

For those curious about the regular expressions used:
(?'M0'[^\s]+)\s+(?'M1'[^\s]+)\s+(?'M2'[^\s]+)\s+(?'M3'[^\s]+)\s+(?'M4'.*)
If, for example, we receive the following text:
aaa@aaa.es http://fdsafdsafdsafdsa.com word4 word5 fgdfgd gfsdfgsd gfsdgfsd gfsdgfsd
The result is:

Parsing email....
1 value found for the field M0.
1 value found for the field M1.
1 value found for the field M2.
1 value found for the field M3.
1 value found for the field M4.


The email parser produced the following results:
M0: aaa@aaa.es
M1: http://fdsafdsafdsafdsa.com
M2: word4
M3: word5
M4: fgdfgd gfsdfgsd gfsdgfsd gfsdgfsd
Attachments
(4.22KiB)Downloaded 587 times