Updated on 2022-12-02 GMT+08:00

Extract Fields

Overview

The Extract Fields separates an existing field by using delimiters to generate new fields.

Input and Output

  • Input: field to be separated
  • Output: new fields

Parameter Description

Table 1 Operator parameter description

Parameter

Description

Type

Mandatory

Default Value

Input field name

Name of a field to be separated. Set this parameter to the name of a field generated in the previous conversion step.

string

Yes

None

Delimiter

Delimiter.

string

Yes

None

Fields extracted

Fields generated after field separation. Multiple fields can be generated after field separation.

  • position: Position of fields generated after field separation.
  • output field name: Names of output fields.

map

Yes

None

Data Processing Rule

  • The value of the input field is separated by specified delimiters and the segments are assigned to the new fields.
  • If the number of field columns after separation is greater than the actual number allowed by the original data, the line will become dirty data.

Example

Use the CSV File Input operator to generate field A.

The following figure shows the source file.

Configure the Extract Fields operator, set Delimiter to blank space, and generate three fields B, C, and D.

After conversion, fields A, B, C, and D are generated, as shown in the following figure.