Perform Find/Replace
Purpose 
Finds/replaces data according to the options in the “Perform Find/Replace” Options dialog box.
Format 
Perform Find/Replace [No dialog; “<text to be found>”; ”<replacement text>”; Find Next/Replace & Find/Replace/Replace All]
Options 
 •
Perform without dialog prevents display of the Find/Replace Summary dialog box at the end of the find/replace operation. This option also prevents display of the confirmation dialog box when a Replace All operation is executed.
If you want the user to be able to enter find or replace criteria, use the Open Find/Replace script step.
 •
Specify displays the “Perform Find/Replace” Options dialog box, where you can set find options and the type of find/replace operation to be performed.
 •
For Perform, choose which action you want the find/replace to perform:
Find Next finds an instance of the find term.
Replace & Find finds an instance of the find term, then replaces the term and searches for the next instance when the script is run again.
Replace replaces highlighted text that matches the find term with the replace term. When using the Replace action, you may need to pair the Perform Find/Replace script step with the Select All script step.
Replace All finds and replaces all instances of the find term.
 •
Find what lets you specify the find term. Either type the term or click Specify to define a calculation.
 •
Replace with lets you specify text to replace instances of the find term. Either type the replacement text or click Specify to define a calculation.
 •
For Direction, select the direction you want the find/replace to search through records.
 •
Match case considers the find term’s case when performing the find.
 •
Match whole words only omits finds where the find term is embedded in another word.
 •
All records/requests finds within all records/requests in the found set.
 •
Current records/requests restricts the find to the current record/request.
 •
All fields finds within every field on the layout.
 •
Current field restricts the find to within the active field. You can use the Go to Field script step to select the field before the Find/Replace is performed.
Compatibility 
 
Where the script step runs 
Supported 
FileMaker Pro 
Yes 
FileMaker Server scheduled script 
No 
FileMaker Go 
No 
Custom Web Publishing 
No 
FileMaker WebDirect 
No 
Runtime solution 
Yes 
Originated in 
FileMaker Pro 6.0 or earlier
Example 1 
Replaces text in the Reorder Level field that matches the find criteria in all records without prompting the user.
Go to Field [Products::Reorder Level]
Perform Find/Replace [No dialog; 1; 3; Replace All]
Example 2 
Goes to the next occurrence of the product name in the Description field.
Show Custom Dialog ["Do you want to find the current product name in the Description field?"]
If [Get ( LastMessageChoice ) = 1]
Go to Field [Products::Description]
Perform Find/Replace [Products::Name; Find Next]
End If
Example 3 
Replaces specific terms in the current field with record data.
Show Custom Dialog ["Do you want to replace placeholder terms with record data?"]
If [Get ( LastMessageChoice ) = 1]
Perform Find/Replace [No dialog; "[NAME]"; Customers::Name; Replace All]
Perform Find/Replace [No dialog; "[COMPANY]"; Customers::Company; Replace All]
Perform Find/Replace [No dialog; "[ADDRESS]"; Customers::Address; Replace All]
End If
Related topics 
Substitute function
Script steps reference (alphabetical list)
Script steps reference (category list)
Finding and replacing data
Was this topic helpful? Send feedback.