Thanks for the help about the find and replace. I have some follow up questions that pertain to my database (only about 2800 records). I see the potential pitfalls ahead of me with this replace... because Joe & Elise Smith were entered into the database as Jose & Elise in the FName field, the Proper(First Name 1) will yield Joe&elise or Joeelise. So my next thought is to investigate omitting entries with an '&' symbol in the FName field from the replace. Unfortunately the program(s) don't think a search for '&' in the FName field is valid. Any thoughts? Thanks again, Jenn Dave Shaw wrote: > >I have inherited a fairly new database that has some apparent quirks. > > > >I just tried to do my first solicitation mailling with the database and > >noticed that some > >of the names are printing in lower case (As in 'Dear joe'). One partial > >solution is to > >define names with the Title Case, but that has the residual problem of > >adddressing > >letters to two people with an extra capital : Dear Joe And Elise. > > > >The names do not appear in lower case in the individual records. > > If the names are in proper case in the fields on the data entry > screen, but print in lower case, it's possible that the layout you > are printing has the field formatted as lower case. However, I note > that above you mention that "some" of the names are printing in lower > case. If some of the names are printing in proper case, then format > on the layout isn't the problem. > > > > >Reading through the old email files leads me to believe that there is a > >functions that > >can do replaces, but I did not find a description of that function. I did > >see a warning to > >be careful doing replaces, and am fortunate to have a copy of our database > >to work > >with before I try it on the real thing. > > > > The FileMaker Replace command is what you are looking for. In ebase, > call it with the script of that name. This command enables you to > replace the value of a specific field in all the records in the found > set. You can replace it with data, a serial number, or a calculated > result (which is what you want to do here). You'd replace the value > of First Name 1, for example, with Proper(First Name 1), which will > turn joe into Joe. Further, it will replace Joe with Joe, so you > won't damage names entered properly. Caution, though, because it > would turn de Forest into De Forest, and LeMond into Lemond. > > More detail in the FileMaker manual - look in the index for Replace, > and Functions. > -- > -- > Dave Shaw H4 Consulting > tel: 206-954-7526 fax: 206-625-1338 > > ------------------ > 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 > ---------------------------------------------------------------------
begin:vcard n:Silva;Jennifer tel;fax:(919) 620-9099 tel;work:(919) 620-9099 x-mozilla-html:FALSE url:www.enoriver.org org:Eno River Association adr:;;4419 Guess Road;Durham;NC;27712; version:2.1 email;internet:[EMAIL PROTECTED] title:Development Associate x-mozilla-cpt:;1 fn:Jennifer Silva end:vcard
------------------ 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 ---------------------------------------------------------------------
