Differences

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

--- engine:import:addtranslation2fromfile [2018/08/14 22:24] – dcumming
+++ engine:import:addtranslation2fromfile [2025/01/21 22:07] (current) – external edit 127.0.0.1
@@ Line 1: / Line 1: @@
-addtranslation2fromfile
+====== AddTranslation2FromFile ======
-==== 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 ====
+===== Phase =====
 This instruction is used by the TapeTrack Import Engine.
-==== Syntax ====
+===== Syntax =====
-**AddTranslation2FromFile**//(field, field2, filterfile, translation);//
+''AddTranslation2FromFile(field, field2, filterfile, translation);''
-//string field;//\\
-//string field2;//\\
-//string filterfile;//\\
-//string translation;//\\
-|field| The field to be translated.|
+^ Variable ^ Type ^ Description ^ Min Length ^ Max Length ^
-|field2| The field to be compared.|
+|field| String | The field to be translated.|1|128|
-|filterfile| A file containing filter values to compare against the current field value.
+|field2| String | The field to be compared.|1|128|
-|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 ("*").|
+|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 section for [[engine/import/addtranslation2|Add Translation2]].</note>
+<notetip>See the notes for [[engine/import/addtranslation2|Add Translation2]].</note>
 ==== Example ====
-**AddTranslation2FromFile: Append L3 to each VOLUME field if the value of the MEDIA matches a pattern within a record of c:\data\LTO3Volumes.txt.**
+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");|
+<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}}