FINDB(find_text, within_text, [start_number])
=FINDB("substring","The FINDB function finds the text substring in a string")
The FINDB function can be used to find the starting position of a substring in a string. For example, if you wanted to find the position of the word "substring" in the string "The FINDB function finds the text substring in a string", you would enter the preceding formula into a Sourcetable cell. This would return the number 19, because the word "substring" starts at the 19th character in the string.
=FINDB("s","The FINDB function finds the text substring in a string")
The FINDB function can also be used to find the position of a character in a string. For example, if you wanted to find the position of the letter "s" in the string "The FINDB function finds the text substring in a string", you would enter this example into a Sourcetable cell. This would return the number 3, because the letter "s" is the 3rd character in the string.
=FINDB("1","The FINDB function finds the text substring in a string")
The FINDB function can also be used to find the position of a number in a string. For example, if you wanted to find the position of the number "1" in the string "The FINDB function finds the text substring in a string", you would enter this example into a Sourcetable cell. This would return the number 8, because the number "1" is the 8th character in the string.
FINDB is a function used to locate a text sub-string within a longer text string, specifically for languages that use the double-byte character set.
FINDB("hello", "This is a sentence with the word hello")
FINDB("a", "This is a sentence")
FINDB("hello world", "This is a sentence with the words hello world")