FINDB

Description: Finds one text string within another text string, and returns the number of the starting position of Find_text, from the leftmost character of Within_text. FINDB is case sensitive and cannot include wildcard characters. This function is for use with double-byte characters.

FINDB is intended for use with languages that use the double-byte character set (DBCS). FINDB counts each double-byte character as 2 when you have enabled the editing of a language that supports DBCS and then set it as the default language. Otherwise, FINDB counts each character as 1.

Syntax: FINDB(Find_text, Within_text, [Start_num])

Find_text is the text you want to find.
Within_text is the text containing the text you want to find.
Start_num specifies the character at which to start the search. The first character in Within_text is character number 1. If you omit Start_num, it is assumed to be 1.

Remarks:

FINDB is case sensitive and doesn't allow wildcard characters. If you don't want to do a case sensitive search or use wildcard characters, you can use the SEARCHB function.
If Find_text does not appear in Within_text, FINDB returns the #VALUE! error value.
Start_num must be greater than 0.
Start_num must be less than or equal to the length of Within_text.

Example:

In the following example, FINDB returns 3 because each character is counted by its bytes; the first character has 2 bytes, so the second character begins at byte 3.

FINDB("", "") = 3