Matt,
A further suggested refinement:
Find only the Jim records by using "=Jim" or, even better "==Jim" (without
the quotes). Doing a plain "Jim" find will also find "Jimson" and "Jim Bob",
if you should have these names on your list. Adding the "=" prefix will
force an exact match on that one word, which would exclude a "Jimson",
although not a "Jim Bob". The "==" forces an exact match on the entire
field, which would eliminate the "Jim Bob" as well. Note that the double
equal sign will not work on FMP v4 files when hosted on FMPServer v3.
For a small list, this may be overkill. But in a larger list that isn't
easily skimmed for errors, it's easy to turn a "Jimson" into a "James" or
other similar unintended results. It's worthwhile to occasionally go back to
the FileMaker User Manual and review finding procedures. Knowing how to do
exact finds can save much time and embarrassment when dealing with a large
list.
Holly also mentioned placing the cursor into the field. This must be done to
enable Replace, Cut, Copy, Paste, etc. Otherwise these commands are grayed
out. Unlike Set Field, these commands will only work with the cursor in the
field to be modified, even in a script. New users often find this confusing,
as a previously working command may unexpectedly be grayed out.
FWIW,
Gary Bogue
> Subject: Re: Find and Replace
> From: "Holly Ross" <[EMAIL PROTECTED]>
> Date: Tue, 17 Jul 2001 16:42:32 -0400
> X-Message-Number: 13
>
> Matt -
>
> Carl's right about the command to use, but here's some more detailed
> instructions.
>
> 1. Do a find for all records that have the info you want to change (i.e.
> all
> records with first name = Jim)
> 2. Working with the found set, change the value in the field of the first
> record to the new value (i.e. James)
> 3. Make sure your cursor is still in the field that you just changed
> 4. Then go ahead and choose the replace command. Should work.
>
> Holly Ross
> Consultant
> TechRocks
> mailto:[EMAIL PROTECTED]
> p) 212.812.4293
> http://www.techrocks.org
>
> > -----Original Message-----
> > From: Matt Grosso [mailto:[EMAIL PROTECTED]]
> > Sent: Tuesday, July 17, 2001 4:13 PM
> > To: TechRocks Support
> > Subject: [support] Re: Find and Replace
> >
> >
> > Ok, now I see both of those commands (one under the "scripts" menu and
> one
> > under the "records" menu) but when I click on the one under the
> "scripts"
> > menu it does nothing (I mean it, nothing) and when I go to the "records"
> > menu, it is faded out. What's the deal? I have Filemaker Pro v.5
> >
> > thanks for your help
> >
> > Matt Grosso
> >
> > -----Original Message-----
> > From: Carl Paulsen [mailto:[EMAIL PROTECTED]]
> > Sent: Tuesday, July 17, 2001 2:01 PM
> > To: TechRocks Support
> > Subject: [support] Re: Find and Replace
> >
> >
> > Yes. There are two ways to do this. If you're using the runtime
> > version (i.e. you don't have Filemaker), there is a script to do this in
> > the Scripts menu item at the top of the screen (FM Replace Command). If
> > you're using Filemaker, you can do this through the scripts menu above
> > or through the Filemaker menu command (under the Records menu in v.5.0
> > and above, can't recall which it's under with v.4).
> >
> > Be careful when using this function (especially with value lists),
> > however, because once it's done it can't be undone except with another
> > replace.
> >
> > Carl
> >
> >
> > Matt Grosso wrote:
> > >
> > > My question is a simple one, is there a way to do a find and
> > replace style
> > > function in ebase? To claify: let's say that I have 300 entries named
> > > "Jim" but now I want them all to be called "James." Is there a way to
> do
> > > this without having to go through each record and change them all one
> by
> > > one? (please say yes)
> > >
> > > Matt Grosso
>
------------------
Reminder to each recipient: To change your list account preferences, go to
http://email.sparklist.com/scripts/lyris.pl?enter=support and enter the email address
you used to subscribe to the ebase support list:: [email protected]
To unsubscribe send a blank email to [EMAIL PROTECTED]
---------------------------------------------------------------------
ebase - Relationship Management for Nonprofits, http://www.ebase.org
---------------------------------------------------------------------
