engine:import:addtranslation2fromfile
Table of Contents
AddTranslation2FromFile
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.
Phase
This instruction is used by the TapeTrack Import Engine.
Syntax
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 |
See the notes for Add Translation2.
Example
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");
See Also
engine/import/addtranslation2fromfile.txt · Last modified: 2021/07/22 02:40 by scunliffe