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: tSTREET], ]CITY], ]STATE] EZIP]
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 ,i:space:])
You want to return each as a separate fields
That would return 3 fields
Then for the returned data point that has the tSTATE] TZIP] use a Formatter > Text > Split (by a space like this h: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: ,L:space:]
@Troy Tessalone NICE! Worked like a charm! Thank you very much!