FINDB

Formulas / FINDB
Find the starting position of text within a parent string in languages using the double-byte character set.
=FINDB(find_text, within_text, [start_number])
  • find_text - required, text to find
  • within_text - required, longer text to find the text in
  • start_number - [OPTIONAL] starting position in within_text

Examples

  • =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.


Summary

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.

  • The FINDB function returns the starting position of a sub-string within a parent string.
  • The FINDB function is used with languages that use the double-byte character set.

Frequently Asked Questions

What is the FINDB Function?
The FINDB function is used to find a text string within another text string when working with languages that use the double-byte character set (DBCS). It's similar to the FIND function, which is used with languages that use the single-byte character set (SBCS).
What does FINDB do?
FINDB returns the position of the first text string within the second text string. It is useful when searching for specific characters or phrases within a larger string of text.
How do I use the FINDB function?
Using the FINDB function is fairly straightforward. You need to provide two arguments to the function: the text string you're searching for, and the text string you're searching in. The function will then return the position of the first text string within the second string.
What are some examples of using FINDB?
  • Searching for the word "hello" within a sentence: FINDB("hello", "This is a sentence with the word hello")
  • Searching for a specific character within a string: FINDB("a", "This is a sentence")
  • Searching for multiple words within a sentence: FINDB("hello world", "This is a sentence with the words hello world")

Related Functions

Sourcetable Logo

Work smarter

Al is here to help. Leverage the latest models to
analyze spreadsheets, enrich data, and create reports.

Drop CSV