Skip to main content

substring

1. Description​

The Substring Calculation Type is used to extract a portion of a field based on specified starting and ending positions or a specified length.

2. Screen Configuration​

substring_image

Here the substring from position 2 to 4 are assigned to GLCode.Suppose ProductCode ="PA01CD", then "A01" will be assigned to GLCode

Click ⬇️ to download the sample data.

3. Required Fields​

  • name: Output Field Name.
  • data_type: Output Field Type. Possible values are: "String(max)".
  • derivation
    • derivation_type: The calculation type used to derive this output field, which for substring is "SUBSTRING".
    • req_fields
      • name: Field name from the input metadata / output config to fetch for the output field.
      • start_position: Starting position of the portion of the field. Possible Values : any numberic value greater than 0
      • end_position: Ending position of the portion of the field. Possible Values : any numeric values less than the length of field and greater than starting position or -1.