Updated on 2024-11-29 GMT+08:00

String Operations

Overview

String Operations: configures generated fields to generate new fields through case conversion.

Input and Output

  • Input: fields whose case needs to be converted
  • Output: converted fields

Description

Table 1 Operator parameters

Parameter

Description

Type

Mandatory

Default Value

Fields to be processed

Information about fields for string case conversion:

  • input field name: Names of the input fields. Set this parameter to the names of the fields generated in the previous conversion step.
  • output field name: Names of the configured output fields.
  • Lower/Upper: Indicates whether to convert data to uppercase or lowercase characters.

map

Yes

None

Data Processing Rule

  • Converts the case of a string value.
  • If the input data is null, no conversion is required.

Example

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

The source file is as follows:

abcd,product
FusionInsight,Bigdata

After the String Operations operator is configured, two new fields C and D are generated.

After the conversion, four fields are generated in sequence:

abcd,product,ABCD,product
FusionInsight,Bigdata,FUSIONINSIGHT,bigdata