Data Transformation Engine Type Designer Reference Guide

Chapter 4 - Type Properties Basic Type Properties
Record has a + infix delimiter and a ? release character. Set has an infix
delimiter of
,.
Data for Record might look like this:
1.54+front,high+Mark
If the data for the Area Field type (which is a component of Set) had a
+ and a ?,
the data for Record may look like this:
1.54+front?+back?,high+Mark
When the data for the entire Record is validated, the two active delimiters are
+
and
,. When the first ? is encountered, the next character is the + delimiter for
Record.
The
? is read as a release character, and the + following is interpreted as data.
The release character
? is not defined for the Set item type. Therefore, the ? in
Set does not apply to the
, delimiter of Set.
This data would be interpreted as follows:
Measure Field
1.54
Set
Area Field
Setting
Field
front+back
high
Name Field
Mark
If you want to release the
, in Set, assign a release character to the Set item
type.
If the data for Area Field included a
?, you would have an additional ? releasing
the (apparent) release character. The data would look like this:
1.54+front?+back??,high+Mark
Measure
N
ame
Set
Measure
Set
N
ame
Area
S
etting
Measure
Set
N
ame
Area
S
etting