Data Hub Mapping Functions
The mapping functions available inData Hub.
Mapping Functions
In addition toTemplate and Data Transformation Functions, the following mapping functions are included inData 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 specifiedpattern.
- pattern
- Format of the specifiedvalue. 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 specifiedpattern.
- pattern
- Format of the specifiedvalue. 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 specifiedkey in thedictionarystring.
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 returnEnglish.
documentLookup
Retrieves the value of the specifiedkey in the dictionary located at the specifieddictionaryURI.
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.