Empty Fields Issue

[ProspectComm]

I am having an odd problem as of late. In my data I have a column titled Newsletter with some of the cells with an Astrix in them a most empty. When I choose suppress if empty I get {Newsletter} in the empty fields where data is "missing". This has worked in the past? Any ideas what I may have done incorrectly? It also appears if I compose the job?

 

Rick

[rpaterick]

Is it possible to attach the file here? Just a sample of the art/data?

[ProspectComm]

Files Attached

12110 Envelope.zip

[step]

That field is literally not populated for some records. Specifically, 81-95, 560-575, 656 and 657. You need to go into the data and add a trailing comma to the end of those records in order to "populate" the field with no blank.

[esmith]

The problem is in your data. If you look at record #80 (line 81) for example, the record is missing a comma after the Listname value so FP thinks that the field is missing and throws an "error" in the form of "{Newsletter}".

 

Records that correctly have a trailing comma (or a comma-asterisk) preview/compose fine.

 

EDIT: The Clemson ninja strikes again!

[rpaterick]

This rule worked:

 

return Field("Newsletter");

[Dan Korn]

This is a long-standing issue with Microsoft Excel and how it saves CSV files:

http://google.com/search?q=excel+csv+missing+fields

http://support.microsoft.com/?kbid=77295

 

I'll also remind everyone to please search the forum before posting a new question. If you search for "Excel missing," you will see that this question has come up several times:

http://forums.printable.com/showthread.php?t=707

 

This kind of thing is yet another reason not to use Excel as a database:

http://forums.printable.com/showthre...=5289#post5289

 

However, the workaround in FusionPro is to create a rule with the same name as the field, as rpaterick suggests.

[ProspectComm]

Thank you for all the input, Dan my apologies, I did search, but apparently I didn't use the right word phrasing in my search.