STRPOS
Returns the starting position of the first instance of a given substring within a string.
Syntax
Arguments
STRING
STRING
Type: string
A sequence of characters to search.
SUBSTRING
SUBSTRING
Type: string
The substring to search for.
Returns
Type: bigint
Returns the starting position of the first instance of SUBSTRING
in STRING
.
Positions start from 1
. If no instance is found, 0
is returned.
Examples
STRING | SUBSTRING | Output |
---|---|---|
All happy families are alike | all | 0 |
All happy families are alike | All | 1 |
All happy families are alike | are | 20 |
All happy families are alike |
| 1 |
|
| 1 |
| word | 0 |
| word |
|
Transformation job example
SQL
Query result
lower_firstname | name_strpos |
---|---|
peter | 0 |
brittany | 6 |
christina | 9 |
Last updated