Google "find field with numbers range filemaker"
https://www.google.com/search?q=find+field+with+numbers+range+filemakerFinding ranges of informationYou can find ranges of information, such as all records that contain a field value that is greater or less than a number, or between two particular dates. A range is different based on the data type:•Numbers: least to greatest•Dates, times, and timestamps: earliest to latest•Text: first to last word, based on the order of words (not the sort order). A word can be a single character; for example, a find on a field for <M would return every record that contains a word less than M in the field’s index order.
Google "find and replace filemaker"
To find and replace data:
1. In Browse, Find, or Layout mode, choose Edit menu> Find/Replace> Find/Replace
Note You can search for data in any type of field except container fields. Although you can search for data in fields that are viewable but not modifiable, you can't replace data in them.
Home > Reference > Script steps reference > Editing script steps > Perform Find/Replace
Perform Find/ReplacePurpose Finds/replaces data according to the options in the Specify Find/Replace 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 Specify Find/Replace dialog box, where you can set search options and the type of find/replace operation to be performed.CompatibilityThis script step is:•not supported in web publishing•not supported in a FileMaker Server scheduled scriptOriginated in FileMaker Pro 6.0 or earlierExamplesPerform Find/Replace ["Houston"; "Dallas"; Replace & Find]
Thanks for your response David. I did utilize all online resources I could find, and with the links you provided, was able to get it to work.
Thanks again :)
There's also Replace Field Contents--an option that may be a better one to use for what you describe here.