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