>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'.
To follow up, though: You can search for an ampersand by enclosing it
in quotes, as "&", to get FileMaker to recognize it as text, not an
operator.
Second, using compound names such as Joe & Elise is not good
practice, and that's why there are two names. It would be a good idea
to search these out and enter the names separately. Labels, letter
salutations, and similar functions will work more reliably.
>
>
>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
>> ---------------------------------------------------------------------
>
>Content-Type: text/x-vcard; charset=us-ascii;
> name="jennifer.vcf"
>Content-Transfer-Encoding: 7bit
>Content-Description: Card for Jennifer Silva
>Content-Disposition: attachment;
> filename="jennifer.vcf"
>
>Attachment converted: MacShaw:jennifer.vcf (TEXT/BOBO) (0004172A)
>Content-Type: text/plain; charset="us-ascii"
>Content-description: footer
>
>------------------
>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
>---------------------------------------------------------------------
--
--
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
---------------------------------------------------------------------
