Subset

Subset function extracts a specific part of data according to the user-specified rules.

About group identifies the function.

  • Name: function ID, initially defined by the function type.

  • Description: function's purpose and role as defined by the user.

Input data source defines the existing or newly added input data source (variable, function, or database record). The final (output) value is extracted from the selected input data source value.

Definition group offers two methods for extracting the data from the input data source.

Fixed length extracts a fixed number of characters from the input data source.

  • Offset: number of characters to be skipped from the beginning of the value.

  • Length: length of extracted value.

Example 34. Example:

Input value: ABCDE

Offset: 0

Length: 3

Subset value: ABC

Example 35. Example:

Input value: ABCDE

Offset: 2

Length: 3

Subset value: CDE

Delimited is used when extracting the data, separated by the user-specified delimiter.

  • Delimiter: character (comma by default) that separates input value fields.

  • Text qualifier: character that encloses the values within the fields (quotation mark by default).

Tip

If a text qualifier is used, the delimiter within the text qualifiers also belongs to the data value. Text qualifier can be left empty.

  • Field number:the field number that is extracted from the input data source.

Example 36. Example:

Input value: "A", "B", "C", "D"

Delimiter: ,

Text qualifiers: "

Field number: 3

Subset value: C