Advanced Search
Advanced Search
Advanced Search
Advanced Search
Advanced Search
Advanced Search
FileMaker Forumpublic

Using FileMaker Pro

 
This is a public Forum  publicRSS

Forum post

    STEVE MARTINO
    Find and Replace function
    Forum post posted May 12, 2012 by STEVE MARTINO, last edited May 17, 2012
    112 Views, 3 Comments
    Title:
    Find and Replace function
    Post:

    Hi, had question about the 'find & replace function'.  Without boring you with the details, how can I, (or can I), take a field with different numbers, and replace them with one specific number?  Is there a way, in the Find & Replace Panel, where I could put a wildcard in the 'find what', and the number I want to replace it with in the 'replace with'?  I tried a blank and that didnt work.

    As always, any help would be greatly appreciated

    Thanks

    Steve

    Answer

     

    • DavidAnders
      posted May 12, 2012 by DavidAnders  Permalink

      Google "find field with numbers range filemaker"
      https://www.google.com/search?q=find+field+with+numbers+range+filemaker

      Link #2
      http://www.filemaker.com/11help/html/find_sort.5.8.html

      Finding ranges of information
      You 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 index 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"
      https://www.google.com/search?q=find+and+replace+filemaker

      Link #1
      http://help.filemaker.com/app/answers/detail/a_id/1223/~/find-and-replace

      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.

      Link #2
      http://www.filemaker.com/11help/html/scripts_ref1.36.37.html

      Home       > Reference > Script steps reference > Editing script steps > Perform Find/Replace

      Perform Find/Replace

      Purpose 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.
      Compatibility
      This script step is:
       •
      not supported in web publishing
       •
      not supported in a FileMaker Server scheduled script
      Originated in   FileMaker Pro 6.0 or earlier
      Examples
      Perform Find/Replace ["Houston"; "Dallas"; Replace & Find]



    • STEVE MARTINO
      posted May 17, 2012 by STEVE MARTINO  Permalink

      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 :)

      Steve

    • PhilModJunk
      posted May 17, 2012 by PhilModJunk  Permalink

      There's also Replace Field Contents--an option that may be a better one to use for what you describe here.