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¶
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.
| 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.
