Select a substring from a field. Note if length is a field, result will be padded with blanks
substr PAYHIST 4 9
substr TextField StartPosition Length
Name | Data Type | Input Type | Description | Optional | Default |
---|---|---|---|---|---|
TextField | Text | Field, Constant | Raw Data | No | |
StartPosition | Numeric | Field, Constant | Starting Position of string | No | |
Length | Numeric | Field, Constant | Length of string | Yes |
Type: Text
Extracted data