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.
Post here if you experience problems or get unexpected errors.
I need help writing an expression that can pull the required data into fields based on the text arriving in different patterns.


Name: JAMES, 1ST LT LABRON - Four values(last_name, title_1, title_2, first_name)


Name: KNOTS, PFC DON - Three values(last_name, title_1, first_name)


Name: BUILDER, BOB - Two Values(last_name, first_name)
Hi,

For the first name and last name you have to use the rules you see in the screenshots that I have attached.

And for the titles I think we would need to know first which are the words we can find in those places. Something like this:

title_1: 1ST, 2ND...
title_2: LT, PFC, SGT...

With that info creating a rule to capture them is very easy, something like this (it is a regular expression)

(1ST|2ND)

and

(LT|PFC|SGT)

I hope it helps
Attachments
parsing_fitst_name.png
parsing_last_name.png