Franklin,
Assuming that Campaign 1 is fill first, then next Campaign 2 and finally
Campaign 3 in succession only as they are needed, you could do it like this....
var listOut = "";
if (Field("Campaign 1") != "")
listOut += Field(Campaign 1");
if (Field("Campaign 2") != "")
listOut += ", " + Field(Campaign 2");
if (Field("Campaign 3") != "")
listOut += ", " + Field(Campaign 3");
return listOut;
This will add the commas to the output only if Campaign 2 and 3 are used. The
problem become a bit more complex if you also need to account for the situation
of Campaing 1 is not used, but Campaign 2 OR 3 are filled... i.e.
Campaign 2, Campaign 3
or
Campaign 2
or
Campaign 3
---
David A. Sweet
Web Designer/Graphic Designer
HKM Direct Market Communications
A DirectConnectGroup Company
No virus found in this outgoing message.
Checked by AVG Free Edition.
Version: 7.5.503 / Virus Database: 269.15.9/1090 - Release Date: 10/24/2007
8:48 AM
+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-
FusionPro 5.0 Now Available!
Variable text on a curve and soft drop-shadows for variable text
LIMITED TIME upgrade offer of $299 per license for current customers:
http://fusionpro.printable.com/store/upgrade
New licenses available for $599 each at:
http://fusionpro.printable.com/store/
All FusionPro 5.0 customers to receive FusionPro 5.1 with
Adobe Acrobat 8 and InDesign CS3 support when released for FREE.
+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-
--
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
--
