:"How the SEARCHB function finds the specified byte position in table text"-Table skills免费ppt模版下载-道格办公

"How the SEARCHB function finds the specified byte position in table text"

```html

Picture and text skills
Case

The SEARCHB function can find a text string (find_text) within other text strings (within_text) and return the starting position number of find_text.

This result is based on the number of bytes used per character, starting from start_num.

This function works with double-byte characters. You can also use FINDB to find text strings within other text strings.

Grammar

SEARCHB(find_text, within_text, start_num)

Find_text The text to find. Wildcard characters can be used in find_text, including question mark (?) and asterisk (*).

A question mark can match any single character, and an asterisk can match any sequence of characters.

If you want to find a real question mark or asterisk, type a tilde (~) before the character.

Within_text The text within which find_text is to be found.

Start_num within_text The number of characters to start searching for.

Description

SEARCHB is not case-sensitive when searching text.

SEARCHB is similar to FIND and FINDB, but FIND and FINDB are case-sensitive.

If find_text is not found, the error value #VALUE! is returned.

If start_num is omitted, it is assumed to be 1.

If start_num is not greater than 0 (zero) or greater than within_text, the error value #VALUE! is returned.

Articles are uploaded by users and are for non-commercial browsing only. Posted by: Lomu, please indicate the source: https://www.daogebangong.com/en/articles/detail/SEARCHB-han-shu-zai-biao-ge-wen-ben-zhong-cha-zhao-zhi-ding-zi-jie-wei-zhi-de-fang-fa.html