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