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 :
SUBCONTINENT_CODE, COUNTRY_ISO_CODE, REGION_ISO_CODE
Examples
Formula | Input | Output |
TOCONTINENT(Subcontinent Code) |
143 | Asia |
TOCONTINENT(Country Data, 'COUNTRY_ISO_CODE') |
US-CA | Americas |