Can the resident JavaScript gurus help with this?
I have a database that looks like this.
<FirstName1> <LastName1> <FirstName2> <LastName2>
1 Joseph Smith Jane *no
data*
2 Jane Jones *no data*
*no data*
3 Alice Wilson Gerald Green
*no data* means literally an empty field
I need to address these people as follows"
Joseph & Jane Smith <!-- concatenate FirstName1," & ", FirstName2,"
",LastName1 -->
Jane Jones <!-- concatenate FirstName1, " ",LastName1
-->
Alice Wilson & Gerald Green <!-- concatenate FirstName1," ",LastName1," &
",FirstName2," ",LastName2 -->
Example 1 - I need to test if LastName2 is empty OR THE SAME as LastName1,
in which case return result of { concatenate FirstName1," & ", FirstName2,"
",LastName1}
Example 2 - If BOTH FirstName2 and LastName2 are empty return result of {
concatenate FirstName1," ",LastName1}
Example 3 - if all fields are NON-EMPTY and if LastName1 AND LastName2 are
unique return result of { FirstName1," ",LastName1," & ",FirstName2,"
",LastName2}
Thanks for all responses,
Spencer
+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-
Calling all FP Web Users!
Do you have a question or lots of knowledge to share about FusionPro Web?
If so, join our Printable Web to Print Users' Forum today!
Send email to [EMAIL PROTECTED] to find out how!
+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-
--
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
--
