14 Jun
2016
14 Jun
'16
8:28 p.m.
IIRC, Excel will treat .NULL. values as blanks, so if you have a temporary cursor cFoo with a numeric column nBar something like UPDATE cFoo SET nBar = .NULL. WHERE nBar IS NULL should do the trick.
hth,
dt
--
Dave Thayer
Denver, CO
On Tue, Jun 14, 2016 at 2:02 PM, Kurt Wendt Kurt_Wendt@globetax.com wrote:
> I know - it's a Crazy request. Trying to figure out the Easiest way to try and do this - and hoping to Avoid having to do more complicated solutions like Office Automation to manipulate an Excel file.
>
> So - here's the deal. This system I work on - it outputs this Excel file. And, in the past - if there are certain records that have a Zero in a particular column - they would Manually wipe out the Zero - and also blank out several of the other fields in that Row.
>
> But, the new request is to make those things happen automatically during process when the Excel file gets exported. So that they do NOT have to manually blank out certain fields. But, of course, therein lies the problem. For the other rows of data - this particular field is supposed to be a numeric value. And, AFAIK - there really is NO Way to have a DBF or Cursor that has a Numeric field - and yet have blank values in it.
>
> As such, I suspect the answer is that this can't be done - to have a numeric data field hold any kind of blank data. They even suggested just a Dash. But, again - I figured it's not possible. However, I figured for the hell of it - I would post here - in case someone had an interesting insight that I hadn't thought of...
>