DriveWorks Solo 17: Find [send feedback...]


FIND( [ Find Text], [ Within Text], [ Start Number] )

Find Text is the string of text to be found.

Within Text is the string, within which Find Text is to be located.

Start Number is the number of the character in the Within Text, where the search will start from.

The FIND function, when calculated, searches the Within Text, from the specified Start Number, for the first occurence of the Find Text string.

The FIND function returns the starting position of the first character of the occurence, found in the Within Text.

The FIND function is the same as the SEARCH function, but the FIND function performs a case sensitive search.



FIND(ProductCodeComboBoxReturn, ProductTextBoxReturn, 1)Starting it's search at the first character of the ProductTextBoxReturn, the FIND function searches through the return value from the ProductTextBox, looking for the return value from the ProductCodeComboBox.

Example Outcomes

ProductCodeComboBoxReturn Value

ProductTextBoxReturn Value

Start Number

Result of the FIND function

"C786""Castor C786"18
"MB9187""MB9187Metal Bracket MB9187"11
"MB9187""MB9187Metal Bracket MB9187"221
"c786""C786Castor c786"112

Table of Contents