Thanks Walt!Yes, you are right about the PhD's. I inherited the data formatted that way. Once I figured out the calculation, it worked like a charm!
[EMAIL PROTECTED] www.rmbl.org ----- Original Message ----- From: Walt Daniels <[EMAIL PROTECTED]> To: TechRocks Support <[EMAIL PROTECTED]> Sent: Monday, November 12, 2001 5:56 PM Subject: [support] Re: Salutations > > > 1 (The field Salutation Line does what you're looking for) > > Using the Salutation line mostly worked fine, as long as there wasn't > > anything odd in the Salutation field to begin with. Many of our > > members are > > PhD's and for some reason alot of the Salutation fields are filled with > > 'Dr.' ( import problem). Is there a way to clean this up in one > > fell swoop. > > Can I do a search to bring up all the Salutation fields that have 'Dr.' > > written in them and then delete that word from all of the records at once? > > > Yes this is fairly straight forward. Do a find for Dr. in the salutation > field to get a found set of the problem cases. Then do an FMPreplace on the > field using a computation that keeps everything but the first four > characters. You might want to put Dr. in the prefix field of all of those > records. My experience is that for most purposes PhD's don't regularly use > the Dr. (me for instance) while medical doctors almost always do. > > > ------------------ > 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 ---------------------------------------------------------------------
