Google Apps Script API
Preparing search index...
google-apps-script-events
GoogleAppsScript
Spreadsheet
TextFinder
Interface TextFinder
Find or replace text within a range, sheet or spreadsheet. Can also specify search options.
interface
TextFinder
{
findAll
()
:
GoogleAppsScript
.
Spreadsheet
.
Range
[]
;
findNext
()
:
GoogleAppsScript
.
Spreadsheet
.
Range
;
findPrevious
()
:
GoogleAppsScript
.
Spreadsheet
.
Range
;
getCurrentMatch
()
:
GoogleAppsScript
.
Spreadsheet
.
Range
;
ignoreDiacritics
(
ignoreDiacritics
:
boolean
)
:
TextFinder
;
matchCase
(
matchCase
:
boolean
)
:
TextFinder
;
matchEntireCell
(
matchEntireCell
:
boolean
)
:
TextFinder
;
matchFormulaText
(
matchFormulaText
:
boolean
)
:
TextFinder
;
replaceAllWith
(
replaceText
:
string
)
:
number
;
replaceWith
(
replaceText
:
string
)
:
number
;
startFrom
(
startRange
:
GoogleAppsScript
.
Spreadsheet
.
Range
)
:
TextFinder
;
useRegularExpression
(
useRegEx
:
boolean
)
:
TextFinder
;
}
Index
Methods
find
All
find
Next
find
Previous
get
Current
Match
ignore
Diacritics
match
Case
match
Entire
Cell
match
Formula
Text
replace
All
With
replace
With
start
From
use
Regular
Expression
Methods
find
All
findAll
()
:
GoogleAppsScript
.
Spreadsheet
.
Range
[]
Returns
GoogleAppsScript
.
Spreadsheet
.
Range
[]
find
Next
findNext
()
:
GoogleAppsScript
.
Spreadsheet
.
Range
Returns
GoogleAppsScript
.
Spreadsheet
.
Range
find
Previous
findPrevious
()
:
GoogleAppsScript
.
Spreadsheet
.
Range
Returns
GoogleAppsScript
.
Spreadsheet
.
Range
get
Current
Match
getCurrentMatch
()
:
GoogleAppsScript
.
Spreadsheet
.
Range
Returns
GoogleAppsScript
.
Spreadsheet
.
Range
ignore
Diacritics
ignoreDiacritics
(
ignoreDiacritics
:
boolean
)
:
TextFinder
Parameters
ignoreDiacritics
:
boolean
Returns
TextFinder
match
Case
matchCase
(
matchCase
:
boolean
)
:
TextFinder
Parameters
matchCase
:
boolean
Returns
TextFinder
match
Entire
Cell
matchEntireCell
(
matchEntireCell
:
boolean
)
:
TextFinder
Parameters
matchEntireCell
:
boolean
Returns
TextFinder
match
Formula
Text
matchFormulaText
(
matchFormulaText
:
boolean
)
:
TextFinder
Parameters
matchFormulaText
:
boolean
Returns
TextFinder
replace
All
With
replaceAllWith
(
replaceText
:
string
)
:
number
Parameters
replaceText
:
string
Returns
number
replace
With
replaceWith
(
replaceText
:
string
)
:
number
Parameters
replaceText
:
string
Returns
number
start
From
startFrom
(
startRange
:
GoogleAppsScript
.
Spreadsheet
.
Range
)
:
TextFinder
Parameters
startRange
:
GoogleAppsScript
.
Spreadsheet
.
Range
Returns
TextFinder
use
Regular
Expression
useRegularExpression
(
useRegEx
:
boolean
)
:
TextFinder
Parameters
useRegEx
:
boolean
Returns
TextFinder
Settings
Member Visibility
Protected
Inherited
External
Theme
OS
Light
Dark
On This Page
Methods
find
All
find
Next
find
Previous
get
Current
Match
ignore
Diacritics
match
Case
match
Entire
Cell
match
Formula
Text
replace
All
With
replace
With
start
From
use
Regular
Expression
Google Apps Script API
Loading...
Find or replace text within a range, sheet or spreadsheet. Can also specify search options.