Forum Discussion

Qrew Cadet

Re: Extract part of address from address field

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
------------------------------

2 Replies

MarkShnier__You
Qrew 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
  Qrew Cadet
  5 years ago
  thank you
  
  ------------------------------
  Jason Beaver
  ------------------------------