engine:import:addtranslation2
This is an old revision of the document!
Table of Contents
AddTranslation2
Translate the value of a field based upon the value of another field.
Phase
This instruction is used by the TapeTrack Import Engine.
Syntax
AddTranslation2(field, field2, filter, translation);
string field;
string field2;
string filter;
string translation;
All AddTranslation instructions add to the translation table which is processed in the sequence in which
the AddTranslations are coded in the definition file. Once a translation match is found for the target field
no further translations will occur for that field within that record.
Although an AddTranslation2 is functionally equivalent to a AddTranslation with the same field and field2
values, AddTranslation entries are processed first, and then AddTranslation2 entries are processed a 2nd
time. This allows you to translate the value of the field2 comparison field first, and then translate the value
of the field based upon the translated value of field2.
| field | The field to be translated. |
| field2 | The field to be compared using the filter. |
| filter | A filter to compare against the current field value. |
| translation | The new value of the field. This can either be a new literal value, or the original value with a prefix or suffix. To represent the current value use an asterisk (“*”). |
Example
Append L3 to each VOLUME field value of USER1 is HCART3.
| AddTranslation2(VOLUME, USER1, “HCART3”, “*L3”); |
engine/import/addtranslation2.1582513194.txt.gz · Last modified: 2025/01/21 22:07 (external edit)