String Cut¶

Overview¶

The String Cut operator cuts existing fields to generate new fields.

**Table 1** Operator parameter description¶
Parameter	Description	Type	Mandatory	Default Value
Fields to be cut	Information about a cut field: input field name: Names of input fields. Set this parameter to the names of fields generated in the previous conversion step. output field name: Names of output fields. start position: Cutting start position, starting from sequence 1. end position: Cutting end position. If the length of the cut string cannot be determined, you can set this parameter to -1, indicating the end of a string to be cut. output field type: Type of output fields. output field length: Field value length. If the actual field value is excessively long, the value is cut based on the configured length. When output field type is set to CHAR, spaces are added to the field value for supplement if the actual field value length is less than the configured length. When output field type is set to VARCHAR, no space is added to the field value for supplement if the actual field value length is less than the configured length.	map	Yes	None

start position and end position are used to cut the original fields and generate new fields.
If end position is set to -1, the end of a string is to be cut. In other cases, the value of end position must be greater than the value of start position.
If the value of start position or end position is greater than the length of the input field, the line will become dirty data.

Use the CSV File Input operator to generate fields A and B.

The following figure shows the source file.

abcd,product
FusionInsight,Bigdata

After configuring the String Cut operator, fields C and D are generated.

After cutting, the following fields are generated.

abcd,product,abc,prod
FusionInsight,Bigdata,Fus,Bigd

last updated: 2024-11-14 12:28 UTC - commit: 9d95be538b931742820cff066f12ce18f037ed96