The ability to join fields and store info in a Mapping Table for an import module and instantly re-use it to another mapped variable. By default, the variable begin_at is mapped up to be a merge of the Date- and Time-field, with a value-separator.

date = /date/

time = /time/

begin_at = @dateT@time

The text between joined fields can be of any size.

title = /title/

date = /date/

description = Video @title playing on @date

Fields with same the same starting name will have the longer field prioritized. In the following example, @titleid will be prioritized over @title"id".

title = /title/

titleid = /titleid/

description = DescriptionFor@titleidInPlaylist

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:@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