Data Hub Mapping Functions
The mapping functions available in Data Hub.
Mapping Functions
In addition to Template and Data Transformation Functions, the following mapping functions are included in Data Hub.
parseDate
Converts the specified date string, parsed according to the specified pattern, to the ISO 8601 format.
parseDate( value, pattern )
- value
- String containing the date in the specified pattern.
- pattern
- Format of the specified value. Valid formats are: "MM/dd/yyyy", "dd/MM/yyyy", "MM-dd-yyyy", "MM.dd.yyyy", "dd.MM.yyyy", "yyyyMMdd", "yyyy/MM/dd", "Mon dd, yyyy", "dd Mon yyyy", and "dd-Mon-yyyy".
parseDateTime
Converts the specified date-and-time string, parsed according to the specified pattern, to the ISO 8601 format.
parseDateTime( value, pattern )
- value
- String containing the date and time in the specified pattern.
- pattern
- Format of the specified value. Valid formats are: "yyyyMMddThhmmss", "dd/MM/yyyy-hh:mm:ss", "dd/MM/yyyy hh:mm:ss", "yyyy/MM/dd-hh:mm:ss" , "yyyy/MM/dd hh:mm:ss".
memoryLookup
Retrieves the value of the specified key in the dictionarystring.
memoryLookup( key, dictionarystring )
- key
- Word or phrase to look up in the dictionary.
- dictionarystring
- String representing a JSON object that defines an array of key-value pairs.
Example: memoryLookup( "en", '{"en": "English", "fr": "French", "sp": "Spanish"}' )
would return English.
documentLookup
Retrieves the value of the specified key in the dictionary located at the specified dictionaryURI.
documentLookup( key, dictionaryURI )
- key
- Word or phrase to look up in the dictionary.
- dictionaryURI
- URI to a document containing a JSON object that defines an array of key-value pairs.