Nov 12, 2021 02:16 PM
I am trying to find a formula that will extract a customers name and address from a body of text and create new single line text fields with this data. The data is coming into airtable via an email automation, and the body of the text data coming in is always consistent in format, with four pieces of data that change, the name, address, market, and URL for the customer. There are other keywords within the body that could be used to identify the before and after for the desired text - but the left, right, and mid formula’s will not work because each body will have varying lengths based on the customers info.
Nov 12, 2021 03:43 PM
Welcome to the community, @Alex_Graham!
However, it seems like there might be an easier way. I’ve never used this tool before, but it looks like MailParser.io offers an easy way to parse emails and then send that information onto other apps such as Airtable using Zapier or Integromat:
If you go down this path, I would highly recommend using Integromat over Zapier because Integromat is much easier & more powerful & significantly cheaper than Zapier.
It also looks like Integromat offers a native MailParser trigger:
Nov 12, 2021 08:56 PM
Welcome to the Airtable community!
I agree with Scott that REGEX is the way to go. Since you only need to find a single occurrence of each piece of data per record, this can probably be done with Airtable REGEX formula functions. However, I recommend experimenting with an online REGEX tester first, and then making any adjustments to the formula to fit Airtable’s REGEX syntax.
Nov 15, 2021 06:17 AM
Thank you for this info!