Instr(String1: String, String2: String): Number
String position from start. Returns the position of the start of the first instance of String2 contained within String1. If String2 is not found in String1 or String1 is zero length, 0 is returned. If either argument is null, null is returned.
InstrRev function syntax has these named arguments:
Parameter |
Description |
String 1 |
Required. String to be searched for String 2. |
String 2 |
Required. String to search for in String 1. |
For example:
Instr("moonbeam", "beam")
Returns: 5