Transformation Rule Table
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. |