TapeTrack Documentation

This page is read only. You can view the source, but not change it. Ask your administrator if you think this is wrong.
====== 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|

<notetip>See the notes for [[engine/import/addtranslation2|Add Translation2]].</note>

==== Example ====
Append L3 to each VOLUME field if the value of the MEDIA matches a pattern within a record of c:\data\LTO3Volumes.txt.

<code>
AddTranslation2FromFile(VOLUME, MEDIA, "c:\data\LTO3Volumes.txt", "*L3");
</code>

===== See Also =====

[[engine:import|Import Engine Functions]] \\
[[cli:sync_fields|Sync Engine Fields]] \\
[[cli:tmss10sync|TMSS10Sync]]

{{tag> import_engine sync_engine update_doco}}