Viz Multichannel

Version 4.1 | Published May 27, 2019 ©

Merging Fields

The correct format for merging (joining) fields is:

freetext<at:var at:name="FIELDNAMEfreetext" />FIELDNAMEfreetext…

where free-text can be empty (FIELDNAME@FIELDNAME).

Example:@Hour:@Minute:@Second

The mapping is divided into two: one for each field reading its values, and one for concatenating (merging) them.

IMPORTANT! The merging field must be located in the table after its parts-fields.

Example 1 for fixed width Any Text import type

  • StartHour= $L(1,2)

  • StartMin= $L(3,4)

  • StartSecond= $L(5,6)

  • Begin= @StartHour:StartSecond

Example 2 for delimited Any Text import type

  • StartHour= $L(4)

  • StartMin= $L(5)

  • StartSecond= $L(6)

  • Begin= @StartHour:StartSecond

Example 3 for Any XML import type

This example shows time read in a format HH-MM-SS-FF from an entry /begin_time/time/.

  • TheStartTime= /begin_time/time/

  • StartHour= &(TheStartTime,”-”,1,1)

  • StartMin= &(TheStartTime,”-”,2,1)

  • StartSecond= &(TheStartTime,”-”,3,1)

  • StartFrame= &(TheStartTime,”-”,4,1)

  • Begin= @StartHour:@StartMin:@StartSecond:@StartFrame