Specifies rules for how text that was imported from an external file is transformed to a supported value that can be mapped to the specified field in Microsoft Dynamics NAV.
The following table desctribes the transformation rules.
| Transformation Rule | Description |
|---|---|
ALPHANUMERIC_ONLY | Removes any non-alphanumeric characters from the input text. |
DK_DECIMAL_FORMAT | Makes sure that the input decimal number (as text) is in Danish format (comma as decimal separator). |
FOURTH_TO_SIXTH_CHAR | Outputs only the fourth, fifth, and sixth character of the input text. |
LOWERCASE TITLECASE | Lowercases the input text. |
TITLECASE | Titlecases the input text. |
TRIM | Uppercases the input text. |
UPPERCASE | Trims the leading and trailing spaces from the input text. |
YYYYMMDD_Date | Makes sure that the input date (as text) is output in YYYYMMDD format. |