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 have received an interesting question via the contact page but unfortunately the sender did not enter his/her the email address correctly. I will post here the question and its response:
Is there an easy way to extract multiple values from an email, but then process into Excel or a database ONLY the last parsed value for each field?

From your example, the email body is this:

Temperature: 21.1
Temperature: 22.3
Temperature: 19.1

--end--


As an action, write to database only 19.9?

Thanks,

My answer was the following:
Hello,

Yes, you have to create a separate parser that extracts only the last field. For example, with a expression match email parser you can use the following regular expression:

(Temperature.*\r\n)*Temperature:(?'last_temp'.*)
Attachments
1.jpg
building the regular expression in Expresso
2.jpg
Creating an expression match email parser in Email&Parser