>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.
>
>Michelle L. Jones
>Information Manager
>PennFuture
>212 Locust St., Ste. 410
>Harrisburg, PA 17101
>[EMAIL PROTECTED]
>www.pennfuture.org
Michelle,
There was a more elegant solution using Excel than the one I can offer.
I had the same problem: it would be better to open your names file in
Microsoft Word before you import into ebase (I used v5.1 for Mac),
select all, choose BBb button, select Title Case, and if your file
isn't overly long (after a long wait without any signal anything is
going on), you'll get lower case names, streets, etc. with initial
capital letters.
If you have already imported the all caps version of names into
ebase, you can import the same, edited file again. When they are all
identified as dupes, choose Set All to Update, select the items you
want updated and import again.
You will have to edit Mcqueen to McQueen, etc
Have a backup handy before trying anything..
Henry Bookout
North Fork Environmental Council
Mattituck, NY 11952
------------------
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
---------------------------------------------------------------------
