Differences

This shows you the differences between two versions of the page.

--- engine:import:addtranslation2 [2018/08/14 22:14] – created dcumming
+++ engine:import:addtranslation2 [2025/01/21 22:07] (current) – external edit 127.0.0.1
@@ Line 1: / Line 1: @@
-addtranslation2
+====== AddTranslation2 ======
-==== AddTranslation2 ====
 Translate the value of a field based upon the value of another field.
-==== Phase ====
+===== Phase =====
 This instruction is used by the TapeTrack Import Engine.
-==== Syntax ====
+===== Syntax =====
-**AddTranslation2**//(field, field2, filter, translation);//
+''AddTranslation2(field, field2, filter, translation);''
-//string field;//\\
-//string field2;//\\
+^ Variable ^ Type ^ Description ^ Min Length ^ Max Length ^
-//string filter;//\\
+|field| String | The field to be translated.|1|128|
-//string translation;//\\
+|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
@@ Line 17: / Line 18: @@
 no further translations will occur for that field within that record.</note>
-<notetip>Although an AddTranslation2 is functionally equivalent to a AddTranslation with the same field and field2
+<notetip>Although an AddTranslation2 is functionally equivalent to a [[engine:import:addtranslation|AddTranslation]] with the same field and field2
-values, AddTranslation entries are processed first, and then AddTranslation2 entries are processed a 2nd
+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>
-|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 ====
-**AddTranslation2: Append L3 to each VOLUME field value of USER1 is HCART3.**
-|AddTranslation2(VOLUME, USER1, "HCART3", "*L3");|
+===== 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}}