When configuring the data map for an Import Definition, you can optionally apply a data transformation to a field in the import file. The platform supports the following Data Transformations.
Case: Change the case of the value in this field to:
All upper case
All lower case
Proper Case (proper case is any text that is written with each of the first letters of every word being capitalized)
Numeric: Change the value in this field to:
Integer
Decimal
Boolean: Change the value in this field to a Boolean value.
Date: Format the value in this field using the select date / time format option.
Currency: Format the value in this field using the select currency option. To use this option, the "Contains Unescaped Double Quotes" option on the Origin Settings screen must be set to No.
Merge: Combine the value in this field with the value in one or more additional specified fields. Select the character to separate the values in the different fields (a space or a comma).
Split: Split the value in this field into one or more selected destination fields. Select the character that identifies where to perform the split (a space, a comma, or a semi-colon).
Substring: Load only a selected portion of the value in this field. Enter the start position and length of the portion that you wish to load.
Lookup: Select the desired Lookup table, the field to match against, the value to use if a match is found, and the value to use if no match is found.
Replace: Select the desired Lookup table, the field to match against, the value to use if a match is found, and whether or not you want to accept null values.
Groovy: Enter a Groovy expression.