Overriding Record or Field Delimiters at Runtime

You can override record and field delimiters of Text Schema during process flow execution. This can be done using process flow variables.

Field delimiters separate data fields. Record delimiters separate groups of fields. For example, consider the following data in the Text Schema with comma as a delimiter between fields, and an end-of-line indicator as a delimiter between records. 

John, 33

Smith, 45

You want to override field delimiter (,) and record delimiter (end-of-line) with a hyphen ( - ) and vertical bar ( | ). For this, you need to create a process flow variable in the Process Designer. To override the record separator, create a variable name in the following format and assign the value vertical bar ( | ). 

Service.<Text_Schema_Name>.recordSeparator

To override the field separator, create a variable name in the following format and assign the value hyphen ( - ).

Service.<Text_Schema_Name>.fieldSeparator

You can override the record and field delimiters of Text Schema only.

To create a process flow variable:

1. In the Process Designer, click Process Flow Variables tab in the bottom pane.

2. Click   in the panel.

   

3. On the Process flow variable entry window, type the name and value of the record separator in the Variable name and Variable value.

   

   Similarly, create a process flow variable for the field separator.

4. Click Ok.

   This creates a variable and is added to the list in the Process Flow Variables tab.