Locate starting position of sub-string in a field.
substrpos 'ABC' 'BC'
substrpos 'ABC' 'XY'
substrpos TextField 'string' (StartPosition)
| Name | Data Type | Input Type | Description | Optional | Default |
|---|---|---|---|---|---|
| TextField | Text | Field, Constant | Raw Data | No | |
| TextField | Text | Field, Constant | Search string | No | |
| StartPosition | Numeric | Field, Constant | Yes | 1 |
Type: Numeric
Location of string in each row