Hi @art001 

It can be tricky to parse a full address into separate address fields.

Parsing a full address relies on very standardized data points and formatting.

e.g. Sometimes there’s a Street 2.

A Code step would be best for attempting this, otherwise you may need multiple Formatter steps.

Hi Troy,

Thank you for your input! I am new to Zapier, would you be able to tell me how can I figure out how to do it with code, or which steps I would need in formatter?

@art001 

Try these Zap steps…

Assuming the Full Address is in this EXACT format: [STREET], [CITY], [STATE] [ZIP]

Exampe: 1234 John Doe St, City, State Zip

NOTE: if there is a STREET 2, then this will NOT work as expected

First Formatter > Text > Split (by a comma and a space like this ,[:space:])

You want to return each as a separate fields

That would return 3 fields

Then for the returned data point that has the [STATE] [ZIP] use a Formatter > Text > Split (by a space like this [:space:])

Give that a try.

Sometimes the best way to learn is by testing!

@Troy Tessalone thank you vey much!

I played around and almost got it to work.

As you mentioned, it would have to be a Perfect Match 100% of the time ([STREET], [CITY], [STATE] [ZIP]) which almost is since Monday.com standardizes it.

The problem comes when we have multiple street names which would be separated by “Spaces”. For Example: “North Orange Park Ave.” Then in this case it would not work.

Nevertheless, it was a very helpful insight for me to use in other Zaps, thank you again!

@art001 

The problem comes when we have multiple street names which would be separated by “Spaces”. For Example: “North Orange Park Ave.” Then in this case it would not work.

The Formatter logic would work if you split by a comma and space together, not just by a comma and not just by a space.

Like such: ,[:space:]

@Troy Tessalone NICE! Worked like a charm! Thank you very much!