Documentation Center

Viz Multichannel User Guide

Version 4.2 | Published July 31, 2023 ©

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