Overview
Grammar | INDEXOF(str1,index) | Returns the character in str1 at the position specified by index. |
Parameter 1 | str1 | Character string 1 |
Parameter 2 | index | Position of the returned character. |
Notes
The value of index starts from 0.
The INDEXOF function returns text-type data.
The function supports two parameters, between which the first is of any type and the second is a number.
Example
For example, if you want to filter out the Store Code field that end with 3, the INDEXOF function can be used.
Choose Filter > Add Formula, and enter INDEX(Store Code,6)="3", as shown in the following figure.
Note:
More examples:
| Formula | Result | Notes |
|---|---|---|
| INDEXOF("FineBI",0) | F | |
| INDEXOF("FineBI",2) | n | |
| INDEXOF("FineBI",5) | I | |
| INDEXOF(["a","b","c"], 1) | b |
