Table of Contents
Overview
This Custom Field returns the character index of the first instance of one string within another, or ‘-1’ if the first string does not contain the second.
Syntax
INDEXOF(‘SearchIn’, ‘SearchFor’,StartIndex)
INDEXOF(FIELDSTR(Description),‘A’, n)
| Element | Description |
|---|---|
| SearchIn | A string to search within. |
| SearchFor | A string to serach for. |
| StartIndex | The character index to start searching at. Default is 0. (Optional field.) |
Examples
INDEXOF(FIELDSTR(‘Manufacturer’), ‘Apple’)
|
Manufacturer |
INDEXOF(FIELDSTR(‘Manufacturer’), ‘Apple’) |
|
Apple iMac |
0 |
|
I like Apples |
7 |
|
Dell Computer |
-1 |
|
Apple iMac by Apple, Inc. |
0 |
INDEXOF(FIELDSTR(‘Manufacturer’), ‘Apple’, 3)
|
Manufacturer |
INDEXOF(FIELDSTR(‘Manufacturer’), ‘Apple’, 3) |
|
Apple iMac |
0 |
|
I like Apples |
7 |
|
Dell Computer |
-1 |
|
Apple iMac by Apple, Inc. |
14 |