Rob is right on. The fact that you see this at record 16 is not a coincidence. This is a known issue with Microsoft Excel: http://support.microsoft.com/default.aspx?scid=77295
I realize this may sound like I'm blaming Microsoft for what appears to be an issue in FusionPro, but if you do a Google Groups search for "Excel missing commas", you will see that this issue hits users of a lot of different data-driven applications. Unlike an actual database, Excel does not make a distinction between a missing field and a field which happens to contain an empty value. Therefore, it doesn't ensure that all the field delimiters are present for each record when you export to a CSV or tab-delimited file. So, caveat emptor with using Excel as a database. You can do what that Microsoft article suggests to make Excel output all the field delimiters. Or you can use Rob's suggestion with the Edit Flat File Data dialog. Another workaround in FusionPro is to create a rule with the same name as the field which simply returns the field. Yet another is to use the "Suppress if containing empty variables" feature in the Paragraph Settings. Dan P.S. NO NEED TO SHOUT +-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+- 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 --
