Functions for Import Map Expressions
You can create expressions using one or more source data columns and map them to master data attributes. For example, the Long Description attribute in Master Data may include information from the Item and Description columns of the Source Data.
The functions used to create expressions can be of type String, Math, Generic, and Calendar.
String Functions
The string functions available for creating expressions are listed in the following table.
Name |
Description |
Expression |
Example |
---|---|---|---|
|
Converts a string value to a date value with the date format matching the date format in the context. |
|
If Attribute1 = 10-31-1997, format = MM-dd-yyyy Depending on locale: |
|
Converts a string value to a time stamp value with the time stamp format matching the import map time stamp format. |
|
If Attribute1 = 2000.01.31 12:01:01, format = yyyy.MM.dd hh:mm:ss Depending on locale: |
|
Concatenates the specified character strings. |
|
If Attribute1 = Item, Attribute2 = Description
|
|
Returns the length, in number of characters, of a specified string. The length excludes blank characters. |
|
If Attribute1 = Item
|
|
Splits character string at the specified delimiter and returns the specified part of the string. Delimiter can be any regular expression or special character. |
|
If Attribute1 =
|
|
Creates a new string of specified length, starting from the specified character number in the original string. |
|
If Attribute1 =
|
|
Inserts a specified character string into the specified location in another character string. |
|
If Attribute1 =
|
|
Inserts a newline character at the end of the specified string. |
|
If Attribute1 = Item, Attribute2 = Description
|
|
Converts a character string to uppercase. |
|
If Attribute1 =
|
|
Converts a character string to lowercase. |
|
If Attribute1 =
|
Math Functions
The math functions available for creating expressions are listed in the following table.
Name |
Description |
Expression |
Example |
---|---|---|---|
|
Returns a pseudo-random number between 0 and 1. |
|
If Attribute1 = 25
|
|
Rounds a numeric expression to n digits of precision. |
|
If Attribute1 = 10.45
|
Generic Functions
The generic functions available for creating expressions are listed in the following table.
Name |
Description |
Expression |
Example |
---|---|---|---|
|
Returns the value of expression2 if the value of expression1 is blank, else returns the value of expression1. |
|
If Attribute1 = blank, Attribute2 = Item, Attribute3 = Description
|
|
Returns the value of expression3 if the value of expression1 equals value of expression2, else returns the value of expression4. |
|
If Attribute1 = Item, Attribute2 = Item, Attribute3 = Match, Attribute4 = No Match
|
|
Converts an object to its string representation. |
|
If Attribute1 = 4
|
|
Returns the value of custom object attribute corresponding to the specified custom object attribute and expression. |
|
If
|
getCategory |
Returns the category corresponding to the specified From category in the given catalog mapping. |
|
where, |
getItemClass |
Returns the item class corresponding to the specified From Category in the given catalog mapping. |
|
where, |
Calendar Functions
The calendar functions available for creating expressions are listed in the following table.
Name |
Description |
Expression |
Example |
---|---|---|---|
|
Returns the current date. |
|
01/17/2017 |
|
Returns the current date and time. |
|
01/17/2017 10:30:45 AM |
|
Returns the name of the day for a specified date. |
|
If Attribute1 = 01/17/2000
|
|
Returns the number of the day of the month for a specified date. |
|
If Attribute1 = 01/17/2017
|
|
Returns the number of the day of the week for a specified date. |
|
If Attribute1 = 01/17/2017
|
|
Returns the number of the day in the year for a specified date. |
|
If Attribute1 = 01/17/2017
|
|
Returns the number of the month for a specified date. |
|
If Attribute1 = 01/17/2017
|
|
Returns the year for a specified date. |
|
If Attribute 1 = 01/17/2017
|