Concatenating Fields

The correct format for concatenation is:

freetext@FIELDNAMEfreetext@FIELDNAMEfreetext… 

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

Example: @Hour:@Minute:@Second

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

Example 1 for fixed width Any Text import type
  • StartHour = $L(1,2)

  • StartMin = $L(3,4)

  • StartSecond = $L(5,6)

  • Begin = @StartHour:@StartMin@StartSecond

Example 2 for delimited Any Text import type
  • StartHour = $L(4)

  • StartMin = $L(5)

  • StartSecond = $L(6)

  • Begin = @StartHour:@StartMin@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

Note: The concatenating field must be located in the table after its parts-fields.