In response to my own posting, I discovered that when using the Proper(First Name 1) command to capitalize the first letter of all first names, there were no problems encountered when I applied that to a field that read 'joe & elise'. The function returned the desired 'Joe & Elise'. Thanks All. Jennifer Silva wrote: > 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 > > --------------------------------------------------------------------- > > ------------------------------------------------------------------------ > ------------------ > 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 ---------------------------------------------------------------------
