Hi All,
I need to build an automation that checks on an outlook email inbox, for a series of proforma submissions.
The submissions are in the body of the email text and at the bottom is the persons name and address; which I need to be able to parse out and report on. eg: # of responses in total, by location
These are proforma submissions so the information is at a similar location.
What would be the best functions to do this?
Welcome to the Make community!
Your question is unclear. Could you provide some screenshots to demonstrate what you are referring to?
Hey Samliew,
Thanks for the chance to clarify. The context is a large community comment period for a project.
One type of submission will be from an action group, that is using a ‘proforma’ email, that all their members will submit to the client. Because it is a proforma email, we don’t need to grab anything content off the email other than the persons name and location. This text is in the body of the email and not an attachment.
Once this data is in an excel sheet; I can see up the analysis on another tab
Please see the attached examples.
You can use a Text Parser “Match Pattern” module with this Pattern (regular expression):
Yours sincerely,\s+(?<name>[^\n]+)\s+(?<email>[^\n]+)\s+(?<address>[^\n]+?(?<postcode>\d+))
Proof https://regex101.com/r/vKVmOt
Global match must be set to NO!For more information, see Text Parser in the Make Help Center:
Match Pattern
The Match pattern module enables you to find and extract string elements matching a search pattern from a given text. The search pattern is a regular expression (aka regex or regexp), which is a sequence of characters in which each character is either a metacharacter, having a special meaning, or a regular character that has a literal meaning.
- The complete list of metacharacters can be found on the MDN web docs website.
- For a tutorial on how to create regular expressions, we recommend the RegexOne website.
- For an easy, quick regex generator, try the Regular Expressions generator.
- For experimenting with regular expressions, we recommend the regular expressions 101 website. Just make sure to tick the ECMAScript (JavaScript) FLAVOR in the left panel.
Hope this helps!
