Text Parsing and content mapping

Use Case: When a person rejects their assigned role at a meeting an email is sent. The format of the email is the same every time.

FirstName LastName (theiremail@example.com) will not be able to fill the NameOfRole role at the Month DD, YYYY meeting.

From what I understand the following RegEx would capture the data.

^(.*) \((.*)\) will not be able to fill the (.*) role at the (.*) meeting\.$

The question for me is then how do I get this data to map out correctly?
I plan to use the Watch Emails function to scan for emails coming in with “Rejected” in the subject line. The first sentence of that email would be what you see above.

I then plan to take the data and put it into another application via their API. What I don’t quite get is how to get the fields (FirstName, LastName, Email, Name of Role, Month, DD, YYYY) mapped correctly. I’ve set up scenarios before where I do mapping so I know that it’s a matter of selecting the data from the first step and mapping it in the second step. (Or whichever steps they turn out to be.) But how will make determine the data that needs to be mapped? Will each Expression above generate a new field that can be mapped?

Hello @SyncGroup,

Please use the Text Parser Match Pattern module.
image

2 Likes

Thank you, Donald.

This was what I needed to know.

1 Like