Extract part of address from address field
Can I extract data from an address field so that I can format the address when printing it on a letter? Example Address field: 3300 North Brook Place, Boise, ID 83710 United States ...
Forum Discussion
If you look at the address field properties, you will see that it is really made up of 6 fields, and each has its own field name and Field ID#, so "yes" is the answer to your question.
Post back if you need help with the actual formula.
Post back if you need help with the actual formula.
How do I extract the Zip Code subfield from the address field. I want to use this value in another formula. Basically, I want to make another field the value of the Zip Code subfield.
------------------------------
Jason Beaver
------------------------------
------------------------------
Jason Beaver
------------------------------
- MarkShnier__You
Qrew Legend
The field name for that subfield is listed on the field properties of the [Address field]. One of mine looks like this
31 Address: Street 1 32 Address: Street 2 33 Address: City 34 Address: State/Region 35 Address: Postal Code 36 Address: Country
So my formula would just be
[Address: Postal Code]
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------- thank you
------------------------------
Jason Beaver
------------------------------
