Try: variable = "" if (Len(Field("Full Name")>0)) variable = variable + Field("Full Name") + " "; if (Len(Field("Delivery Address")>0)) variable = variable + Field("Delivery Address") + " "; if (Len(Field("City")>0)) variable = variable + Field("City") + " "; if (Len(Field("State")>0)) variable = variable + Field("State") + " "; if (Len(Field("ZIP+4")>0)) variable = variable + Field("ZIP+4") + " "; return variable
Add punctuation as needed. -----Original Message----- From: Nicola DosSantos [mailto:[EMAIL PROTECTED] Sent: Thursday, August 16, 2007 11:20 AM To: FusionPro Users Forum Subject: [fusionpro] Variable Optional Text and seperating characters - Multiple Combinations Hi Everyone, I have a variable template that has the following line of variable text: Field(CompanyName), Field(Address), Field(City), Field(State) Field(Zip) Every Field is optional. Therefore, there are a LOT of possible combinations that could exist. The comma and space or space only needs to exist between the fields and changes depending on the combination of fields used. If I apply the separating characters as either a prefix or suffix rule to each field individually when only one field is used there will be unwanted commas and spaces that will show up. Therefore I think I need to create one large rule that contains all the possible combinations. Unfortunately this Rule is very long and I'm not sure if I have in fact accounted for every possible combination. Does anyone know of an easier way to approach this?? Ant help would be appreciated! -- Nicola DosSantos Ambit Press / Minuteman Press of Cambridge Five Cambridge Center Cambridge, MA 02142 Tel: 617.876.3688 Fax: 617.876.3896 www.ambitpress.com Please send all jobs to [EMAIL PROTECTED] +-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+- 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 -- To unsubscribe send a blank email to [EMAIL PROTECTED] -- -- -- +-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+- 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 --