Returns the continent name of the specified geolocation.
Sample usage
TOCONTINENT(Subcontinent Code)
Syntax
TOCONTINENT(X [,input_format])
Parameters
X
- a text field or expression, or a geo field or expression.input_format
- format for text fieldX
. Optional ifX
is correctly configured as a geo field.
Input format
TOCONTINENT
accepts the following input formats if X
is a text field :
Examples
Example formula | Input | Output |
---|---|---|
TOCONTINENT(Subcontinent Code) |
143 | Asia |
TOCONTINENT(Country Data, 'COUNTRY_ISO_CODE') |
US-CA | Americas |