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.