Translate the value of a field based upon the value of another field, where the other field value can be loaded multiple times using the contents of a file.
This instruction is used by the TapeTrack Import Engine.
AddTranslation2FromFile(field, field2, filterfile, translation);
| Variable | Type | Description | Min Length | Max Length |
|---|---|---|---|---|
| field | String | The field to be translated. | 1 | 128 |
| field2 | String | The field to be compared. | 1 | 128 |
| filterfile | String | A file containing filter values to compare against the current field value. | 1 | 256 |
| translation | String | 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 (“*”). | 1 | 256 |
Append L3 to each VOLUME field if the value of the MEDIA matches a pattern within a record of c:\data\LTO3Volumes.txt.
AddTranslation2FromFile(VOLUME, MEDIA, "c:\data\LTO3Volumes.txt", "*L3");