Exclude Null Data From Printing

Legacy Poster

• March 27, 2013 18:24

Hello,

 

I have a text file as a data source.  I don't want to print labels for "Misc" parts.  These Misc parts will have nulls in three other data fields.  I know how to do this in SQL but the SQL option isn't visible because I have a text file as a data source.  How do I specify in the Query not to print records that have a null value in a specific field?  I used a Not = as the operator and for the Criteria I tried entering "", null, <>, <Empty> but it doesn't exclude the null records, 

 

0

• 

  Ian Cummings

  Moderator

  ★ BarTender Hero ★

  • April 01, 2013 15:35

  BarTender doesn't currently support NULL values in a data source, so a VB script for example wouldn't be able to test for this condition in a data source.  Have you tried using an ODBC driver for text files in order to then run the SQL statement??

  0

Please sign in to leave a comment.