My address isn't parsing correctly?

Question

I can’t seem to figure this out regardless of how many templates or variations I create.

I simply using one line data and breaking it up to create an address

123 Main St., Happyville, TX 5555

{{address}}., {{city}}, {{state}] {{zip}}

I keep getting crazy results and it starts with the address part. It always feeds into the city and sometimes further.

1- Is there a way to fix it?

2-I am considering putting the data in google sheets first them manipulating the data with some formulas!! it’s exhausting

Thank you for any help you can provide.

Troy Tessalone · Accepted Answer

Hi @DV_AutomationGood question.Make sure you have a properly configured template.Notice the closing bracket.Notice the extra period before the comma.Other OptionsYou may want to try using a more robust email parser such as Mailparser: https://zapier.com/apps/mailparser/integrationsA Zap code step can be used to parse data:

DV_Automation · Answer

Sorry for the typo. It is correctly formatted in the app. I just typed it fast in the forum.I will check your link. Thank you

Useful links

Code of conduct

Using the Community

Community expectations

Useful links

Code of conduct

Using the Community

Community expectations

Sign up

Use your Zapier credentials

Log in to the Community

Use your Zapier credentials

Scanning file for viruses.

This file cannot be downloaded