Configuring Structured Text Filter

Official translation unavailable. Translate this page with Google:

Structured Text Filter

To learn more about filters in general, see section Understanding Filters.

Use this filter whenever you receive a structured text file. These are the text files in which the fields are identified by one of the following methods:

  • Fields are delimited by a character: Usual delimiter characters are comma or semicolon. CSV (comma separated values) is a typical example of a delimited file.

  • Fields contain fixed number of characters: In other words, fields are defined by fixed-width columns.

For examples of structured text data, see section Text Database.

Defining Fields

For structured text files, the definition of fields is very straightforward. There are two options:

  • Delimiter defines the fields: In this case, you have a delimiting character, such as comma or semicolon separating the fields. You just have to define the field names in the same order as they appear in the data received by a trigger.

  • Fixed-width fields: In this case, define the field names in the same order as they appear in the data received by a trigger, and define the number of characters the field would occupy. That many characters are going to be read from the data for this field.

UUID-c4da307f-9e87-8427-2a17-cb8cd383bd9a.png

Enabling Dynamic Structure

Structured Text filter has the ability to automatically identify fields and their values within the received data. This eliminates the need for manual variable-to-field mapping.