LOCATIONTOADDRESS

Takes a location string (either XML, lat;long, or address) and returns the address component as a string. Reverse geocodes as necessary.

Syntax

= LOCATIONTOADDRESS (location)

Parameters:

location

String containing the location in any of 3 formats: an XML location string, a latitude and longitude separated by a semicolon, or a street address.

 

Return Type

String

Returns the address component as a string.

 

Examples

Example

Returns

= LOCATIONTOADDRESS(GetBrowserLocation())

Returns address component as a string.

= LOCATIONTOADDRESS("2870 Zaker Rd, San Jose CA")

 

Returns address component as a string.

= LOCATIONTOADDRESS("37.23;-121.55")

 

Returns address component as a string.