Thanks for the help. That accomplished what I was trying to do. I tweaked
a couple of things to fit the database (see below for others who were
wondering). Can you explain this:

for (i=0;i<spliced_name.length;i++)
        {
        Name2 = Name2 + ToLower(Left(spliced_name[i],1)) +
ToLower(Mid(spliced_name[i],2,50)) + ""


I don't understand the for (i=0;i<spliced_name.length;i++) line at all.
I understand on the next line that you established your Name2 and your
spliced_name, but what is the ([i],1) and the ([i],2,50)?

I know that it works, but I would like to understand how it works.

Thanks-




var Name2 = ''
var name = Field("FName")+Field("Lname")

//space character is our delimiter. spliced_name is an array
var spliced_name = name.split(".") 
var spliced_name = name.split("'")
var spliced_name = name.split(" ")

for (i=0;i<spliced_name.length;i++)
        {
        Name2 = Name2 + ToLower(Left(spliced_name[i],1)) +
ToLower(Mid(spliced_name[i],2,50)) + ""
        }

return Name2;

--
Users of FusionPro Desktop have unlimited free email support. Contact Printable 
Support at [EMAIL PROTECTED] 
--
View FusionPro Knowledge Base, FusionPro Samples at
www.printable.com/vdp/desktop.htm

--
You are currently subscribed to fusionpro as: [EMAIL PROTECTED]
To unsubscribe send a blank email to [EMAIL PROTECTED]
--


--
Note:  All e-mail sent to or from this address will be received or otherwise 
recorded by the e-mail recipients of this forum. It is subject to archival, 
monitoring or review by, and/or disclosure to someone other than the recipient. 
Our privacy policy is posted on www.printplanet.com
--

Reply via email to