>This was in a past digest, but I am now having the same problem and
>can't figure
>out how to use the Proper(text) function, which solution was offered. I have
>already uploaded a list into ebase that was in all caps. I'd like to
>convert it
>to lower case in ebase if possible. I've read the FM manual and help but can't
>figure it out. It seems like that function is for when you create a new field,
>not for use in an existing field?
>
>Can anyone shed any light on how this function works? Much appreciated.
>
The Proper() function can be used in an existing field containing
data by using FileMaker's Replace command.
- select the set of records to work on (if it's all of them, the Find
All button will do it)
- select the menu item Scripts>FMPro REPLACE Command
- in the dialog box click the bottom button, Calculated Replace
- The calculation for a text field called FieldName would be Proper(FieldName)
The Replace command is dangerous since it changes the value of fields
in a lot of records, so back up your file set before working on it.
You'll probably have to edit the data later, because it will change
MCFALL to Mcfall instead of McFall, for example.
--
Dave Shaw Northwest Classics, Inc
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
---------------------------------------------------------------------
