str_pos
Returns the position of a substring within a string.
Syntax
str_pos(<haystack>, <needle>, <offset>)
| Parameter | Type | Description |
|---|---|---|
| haystack | Text | The Haystack string value. |
| needle | Text | The Needle string value. |
| offset | Integer | The Offset numeric value. |
Return values
Integer
Usage
Returns the position of '@' in the email address.
str_pos(orders.email, '@')