====== 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);''

^ Variable ^ Type ^ Description ^ Min Length ^ Max Length ^
|field| String | The field to be translated.|1|128|
|field2| String | The field to be compared using the filter.|1|128|
|filter| String | A filter 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>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.</note>

<notetip>Although an AddTranslation2 is functionally equivalent to a [[engine:import:addtranslation|AddTranslation]] with the same field and field2
values, [[engine:import:addtranslation|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.</note>



===== Example =====

Append L3 to each VOLUME field value of USER1 is HCART3.

<code>
AddTranslation2(VOLUME, USER1, "HCART3", "*L3");
</code>

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

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

{{tag> import_engine sync_engine}}