SpreadJS Overview
Getting Started
JavaScript Frameworks
Best Practices
Features
SpreadJS Designer
SpreadJS Designer VSCode Plugin
Tutorials
SpreadJS Designer Component
SpreadJS Collaboration Server
Touch Support
Formula Reference
- Formula Overview
- Formula Functions
  - Barcode Functions
  - Compatibility Functions
  - Database Functions
  - Date and Time Functions
  - Engineering Functions
  - Financial Functions
  - Information Functions
  - Logical Functions
  - Lookup and Reference Functions
  - Math and Trigonometric Functions
  - Statistical Functions
  - Sparkline Functions
  - Text Functions
    - ARRAYTOTEXT
    - ASC
    - BAHTTEXT
    - CHAR
    - CLEAN
    - CODE
    - CONCAT
    - CONCATENATE
    - DBCS
    - DOLLAR
    - FIND
    - FINDB
    - FIXED
    - JIS
    - LEFT
    - LEFTB
    - LEN
    - LENB
    - LOWER
    - MID
    - MIDB
    - PROPER
    - REPLACE
    - REPLACEB
    - REPT
    - RIGHT
    - RIGHTB
    - SEARCH
    - SEARCHB
    - SJS.ENDWITH
    - SJS.STARTWITH
    - SUBSTITUTE
    - T
    - TEXT
    - TEXTAFTER
    - TEXTBEFORE
    - TEXTJOIN
    - TEXTSPLIT
    - TRIM
    - UNICHAR
    - UNICODE
    - UPPER
    - VALUE
    - VALUETOTEXT
  - Web Functions
  - RegEx Functions
  - ReportSheet Functions
  - What-If Analysis Functions
  - Other Functions
Import and Export Reference
Events
API Documentation
Release Notes

SEARCHB

This function searches one text value within another and returns the text value’s position in the text you searched.

Syntax

SEARCHB(find_text, within_text, [start_num])

Arguments

This function has the following arguments:

Argument	Description
find_text	The text that you want to find.
within_text	The text in which you want to search for find_text.
start_num	[Optional] The byte position in within_text at which to start the search. The first byte is position 1. If omitted, the search starts from the first byte.

Argument

Description

find_text

The text that you want to find.

within_text

The text in which you want to search for find_text.

start_num

[Optional] The byte position in within_text at which to start the search. The first byte is position 1.

If omitted, the search starts from the first byte.

Remarks

SEARCHB counts each double-byte character as 2 bytes when a language that supports a double-byte character set (DBCS) is used. Otherwise, SEARCHB behaves in the same way as SEARCH.
The function is not case-sensitive. Use the FINDB function to perform a case-sensitive search.
You can use the question mark (?) and asterisk (*) wildcard characters in find_text. A question mark matches any single character, and an asterisk matches any sequence of characters.
To search for an actual question mark or asterisk, type a tilde (~) before the character.
If find_text is not found, the function returns the #VALUE! error.
If start_num is less than or equal to 0 or greater than the byte length of within_text, the function returns the #VALUE! error.

Examples

activeSheet.setFormula(0, 0, '=SEARCHB("MOB","MOBILE")');// 1
activeSheet.setFormula(0, 0, '=SEARCHB("B","MOBILE")');// 3
activeSheet.setFormula(1, 0, '=SEARCHB("B","MOBILE",4)');// #VALUE!