Instalink Scripting Documentation

Dates

Adjust by Timezone
Current date
Current timestamp
Day of Month
Day of Week (number)
Day of Week (text)
Month (number)
Month (text)
Months ago
Truncate date to day
Truncate date to hour
Truncate date to minute
Truncate date to month
Truncate date to year
Year
Years ago

Encoding

Base 64 Decode
Base 64 Encode
CSV Decode
CSV Encode
JSON Decode
JSON Encode
URI Decode
URI Encode
X12 Decode
X12 Encode
XML Decode

Lists

Aggregate Array
Aggregate Array By Group
All But First Item in List
All But Last Item in List
Array To Map
Combine Two Arrays Without Duplicates
Count of Items in List
Each Item in List as List
Extract Part of Array
Filter List by Matches
Filter List by Non-Matches
Filter List: Unique
Filter List: Unique By Key
First Item in List
Flatten List
Flatten List Recursively
Get Common Items In Arrays
Get Item In List At Index
Group Array By Value
Join List Into Text
Last Item in List
List Append
List Contains Value
List Get Index
List Sort By Key
Pluck Values from List Items
Random Item in List
Randomize List
Remove Index From List
Removes Items From Array In Other Arrays
Reverse List
Set Item In List At Index
Sort List
Transpose List of Lists

Logic

And
Equal to
Exists
Greater Than
Greater Than or Equal
Less Than
Less Than or Equal
Match
Not equal to
Or
Xor

Maps

Map Get
Map Has Key
Map Keys
Map Pairs
Map Size
Map Values
Map With Entry
Map Without Entry
Merge Maps

Math

Absolute value
Add
Cube Root
Divide
Divide (whole number)
Exponent
Multiply
Negate
Random Number
Random Whole Number
Remainder
Round down
Round number
Round towards zero
Round up
Square Root
Subtract

Other

Lookup

Presets

ISO Country
ISO Subdivision

Text

Append Text
Capitalize words
Concatenate Text
Create Hash
Create HMAC Signature
Left trim text
Lower case
Prepend Text
Replace Text
Right trim text
Search Text
Split Text Into Lines
Split Text Into Words
Sub Text
Text Contains
Text length
Text split
Trim text
Upper case

Type Conversions

As Is
Boolean
Date
Date to String
List
Map
Number
Number to Fixed Decimal String
Text
Timestamp
Whole Number

ISO Subdivision | ISO_SUBDIVISION

Syntax

ISO_SUBDIVISION( [value], [country], [returnType = "CODE"] )

Parameters

value
The input TEXT that will be converted to or from a subdivision code. If it is not a TEXT value, an empty TEXT value will be returned.

country
The input TEXT that will be converted to or from a country code. The country code is required as subdivision codes are not unique across different countries. If it is not a TEXT value, an empty TEXT value will be returned.

returnType optional
Determines whether or not to convert from or to a subdivision code. "CODE" will convert the input to a subdivision code. "NAME" will return the full subdivision name from a subdivision code. Defaults to "CODE" if omitted.

Return Value

A TEXT value. Will be the abbreviated subdivision code when returnType is set to "CODE". Will be the full subdivision name when returnType is set to "NAME". Will always return an empty TEXT value if either the country or the subdivision value is not found.

Description

Takes a TEXT input and converts it into a the standard subdivision code abbreviation. A subdivision code represents the geopolitical ara designations of a country. Depending on the country, this may include states, provinces, counties, etc. Can also be used to validate subdivision codes or subdivision names.

Examples

Convert a state name into an ISO code.
ISO_SUBDIVISION("Texas", "US")
# returns "TX"
The country value is required
ISO_SUBDIVISION("Texas")
# returns "" because the country code was omitted
Works with the country name
ISO_SUBDIVISION("Texas", "United States")
# returns "TX"
Check to see if a subdivision code is valid for a specific country
ISO_SUBDIVISION("TX", "US")
# returns "TX"
ISO_SUBDIVISION("XX", "US")
#returns "" because there is no "XX" subdivision code for the United States.
Get the full subdivision name from the subdivision code.
ISO_SUBDIVISION("TX", "US", "NAME")
# returns "Texas"
Returns an empty TEXT value if either the value of VALUE or COUNTRY is a non string value or is omitted
ISO_SUBDIVISION(null, null)
# returns ""
ISO_SUBDIVISION("Texas", null)
# returns ""
ISO_SUBDIVISION(null, "US")
# returns ""
ISO_SUBDIVISION(20, "US")
# returns ""
Handles 3 character country codes
ISO_SUBDIVISION("Texas", "USA")
# returns "TX"
Handles 3 character subdivision codes
ISO_SUBDIVISION("North Yorkshire", "GB")
# returns "NYK"
ISO_SUBDIVISION("NYK", "GB", "NAME")
# returns "North Yorkshire"