Data Transformation Engine Type Designer Reference Guide

Chapter 7 - Group Properties Specifying a Delimiter
Variable
Sometimes you do not know what delimiter is used in the data source, especially if
you receive that data from an outside source. However, you know all of the
possible values that the delimiter could be. You can create an item to represent
this delimiter and specify all of the possible values as restrictions of that item. The
value of the delimiter in the data is found.
To specify an item as a Variable Delimiter
1 In the Properties window for the delimited group, click in the Delimiter >
Item value field.
2 Press Alt and drag the item from the type tree window into the Item field.
Location
The Location property specifies the location of the delimiter with respect to the
components. The options are prefix (the delimiter appears before the component),
postfix (the delimiter appears after the component), and infix (the delimiter
appears between components).
The following table explains each option:
Property Description Example
Prefix Before each component.
Before each member of a component in a series.
*a*a*b*c
Postfix After each component.
After each member of a component in a series.
a*a*b*c*
Infix Between components.
Between members of a component in a series.
a*a*b*c
Specify a syntax item type as
a variable delimiter