PowerUp Description
The pwrADDRESSPART PowerUp function returns the requested element from the address value.
PowerUp Syntax
pwrADDRESSPART(value, element)
The pwrADDRESSPART PowerUp function has the following arguments:
value – Required. This is the value from which element will be extracted.
element – Required. This specified the part of the address to be returned.
Return Value
pwrADDRESSPART will return a string that matches the requested element from the address value.
Remarks
The address elements that may be returned are listed below.
“pob” – Post Office Box (if present)
“street” – street address
“unit” – unit number (if present)
“city” – city
“state” – state
“zip” – zip code
Example
=pwrADDRESSPART("123 Main Street, Anytown, WA 99163", "city")
Will return the following:
Anytown
