How to extract specific data (like address) from a text field in Zapier?

Great question @BradE! 🙂

Is the text provided in an email? If so, then you could forward those emails to an Email Parser mailbox and it would parse out the text in the email into separate fields that you could then select in your Zap. You can learn more about that here: Trigger Zaps from new parsed emails

If it’s not from an email then you could use a Formatter (Text > Extract Pattern) action to extract the text that appears between “Address:” and “Call regarding:”. See Extracting Text From in Between Specific Values for details on how to do that. 

Would either of those options work for your needs here?

Hi - thanks for your reply...so I managed to get the address extracted from the text.  See attached. 

However, my final question is how do I get the Address (i.e. street address, city, county) separated from the postcode.  The reason I need them separated into different variables for use later on in my Zap is because they are being entered into a CRM which takes the address on multiple lines and the postcode is a separate field. 

The thing that is confusing me is street address can be 1, 2, 3 or even 4 lines sometimes, so I need the code to be able to cope with variations in address length.  The postcode is always last in the string, so I did think of splitting the string by comma and pick from list to get the last line item.  This would presumably work for the postcode, but what about the rest of the address?

Any help is much appreciated!

Hi Troy,

Sorry, I wasn’t very clear in my question.  I would like to format the above example output like so:

$address variable:

5 Mercer Walk
London

$postcode variable:

WC2H 9QB

is this possible?

Is there a formatter utility to combine all of the line items except for the last line item (i.e. the postcode)

Hi Troy,

In my example i get 3 separate variables and you’re correct I can use each variable in my following Zaps.  This works fine. 

However, what if the address outputs 4 variables?  This will happen when the address has 4 lines, for example:

Street line1, street line 2, city, county, postcode

I see 🤔

Tricky or not possible?

My logic would go something like this:

• Step 1 - Extract address from text using split as per above
• Step 2 - Convert the address to line items
• Step 3 - Use choose from list (last item) to get the postcode

This is where I get stuck…

• Step 4 - Remove the postcode from Step 2 line items (how do I do this in formatter)
• Step 5 - Use line items to text using separator \n

Would this logic work?

Hi Troy,

I managed to get the Zap working as it should. The only issue is when I use the Formatter » Line item to text with the [:newline:] or [:return:] separators it puts in an extra space on the second and third items…what is the reasoning behind this? Is there any easy fix?

Hi,

Please see attached screenshots.

There is an extra space before London for some reason?