:"In-depth analysis of the FINDB function: pinpointing the first occurrence of a specific byte value in the text"-Table skills免费ppt模版下载-道格办公
投稿
  1. JustNewsHome
  2. Table skills
  3. "In-depth analysis of the FINDB function: pinpointing the first occurrence of a specific byte value in the text"

"In-depth analysis of the FINDB function: pinpointing the first occurrence of a specific byte value in the text"

Author: daogeziyuan • • Table skills • Views 930
```html
  • Picture and text skills
  • Case

Used to find a text string (find_text) within another text string (within_text) and returns the starting position number of find_text based on the number of bytes used per character, starting from the first character of within_text.

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

Syntax FINDB(find_text,within_text,start_num)

Find_text is the text to find. Within_text is the text containing the text to be found. Start_num specifies the character to start the search.

The first character in within_text is character number 1. If start_num is omitted, it is assumed to be 1.

Wildcard characters cannot be included in Find_text.

If there is no find_text in within_text, FINDB returns the #VALUE! error value.

If start_num is not greater than 0, FINDB returns the #VALUE! error value.

If start_num is greater than the length of within_text, FINDB returns the #VALUE! error value.

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/shen-ru-jie-xi-FINDB-han-shu-jing-zhun-ding-wei-wen-ben-zhong-te-ding-zi-jie-zhi-shou-ci-chu-xian-wei-zhi.html

Like (810)
Reward 支付宝扫一扫 支付宝扫一扫
Lomu RPG饼干 Columnist
48 196
single-end

Related Suggestion