Function

Find(findText, withinText) findText withinText Find(findText, withinText, startNumber) findText withinText startNumber

---

Use

The Find() function returns the starting location of a given text substring inside of a text value.

Find() is case sensitive. The Search() function works similarly, but it is not case sensitive.

You can also start the search at a specified character by providing a start number. This will skip over the part of the text value before the start number.

Examples

• Find("C", "ABCDEFG")  = 3
• Find("c", "ABCabc")  = 6
• Find("morning", "Good morning! Do you wish me a good morning?")  = 6
• Find("morning", "Good morning! Do you wish me a good morning?", 10)  = 37

 

 

---