Hello Chad,
Create an empty text rule and use the following logic with the field names
changed to reflect your current data.
Be sure to check the box for "Treat return strings as tagged text".
var Name2 = ''
var name = Field("FName")+Field("LName")
var spliced_name = name.split(" ") //space character is our delimiter.
spliced_name is an array
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;
-Alex
-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Monday, May 07, 2007 8:29 AM
To: FusionPro Users Forum
Subject: [fusionpro] PURL Creation Rule
I have a question on creating a rule that will return a purl based on
First and Last name.
For example. If I have 2 fields (FName) and (LName) or (John) and (Doe) I
want to return johndoe
I know that I can do a simple rule that says
return ToLower(Field("FName")) + ToLower(Field("Lname"))
and this will give me the two concatenated fields to lower w/o any spaces,
but I am trying to create a complex rule that will prevent the names with
characters i.e. (E.J.)(O'Brian)(and even the trailing accidental spaces)
So basically I want to create a rule that will return
ejsmith and not e.j.smith or chrisobrian and not chriso'brian
Any thoughts would be greatly appreciated.
Thanks-
--
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
--
--
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
--
