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 view for the delimited group, click in the Delimiter > Item value field.
  2. Press Alt and drag the item from the schema editor into the Item field.