3 Replies Latest reply: May 15, 2014 10:12 AM by DJS _ RSS

    Export To Excel - Blank Fields

    DJS _

      I recently upgraded from version 9 to version 11 and I'm now having difficulties with the Excel files that I'm exporting.  It appears that blank fields aren't really blank fields?


      When using the vlookup command a value of 0 (zero) will be returned when the lookup references a field that is blank.  However, now it actually returns nothing (blank) indicating that there something in the field ... like a space?


      If I go to the cell that the lookup is referencing and hit the delete key the vlookup then updates and returns a 0 (zero) as expected.


      I don't have this issue when exporting from version 9.


      Any help would be appreciated.



        • Export To Excel - Blank Fields
          DJS _

          The COUNTA function returns the same result.  The blank fields are being counted.  This should be easy for some of you to confirm.



            • Export To Excel - Blank Fields
              Olly Bond

              Hello DJS,


              A blank field that actually contains a NULL value is handled differently. You can overcome this in two ways:


              - In the Summary, select the Options > View to show Null values as 0^or as " ", and then export to CSV format. Excel should read this correctly as a zero or space as desired.


              - In the Options > Export settings, check the version of the Excel export driver that you're using.


              Hope this helps,