Forum Discussion

AndreaPahor's avatar
AndreaPahor
Qrew Cadet
7 years ago

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 ...
Formulas and functions
JasonBeaver's avatar
JasonBeaver
Qrew Cadet
5 years ago
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
------------------------------
MarkShnier__You's avatar
MarkShnier__You
Icon for Qrew Legend rankQrew Legend
5 years ago
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
------------------------------
  • JasonBeaver's avatar
    JasonBeaver
    Qrew Cadet
    5 years ago
    thank you

    ------------------------------
    Jason Beaver
    ------------------------------