Got it - that worked - now I can do a NULL replace!!! But - yes, I totally hear you - there may be further ramifications or complications in doing this. Will have to see. Regards, Kurt Wendt Senior Systems Analyst
Tel. +1-212-747-9100 www.GlobeTax.com -----Original Message----- From: ProfoxTech [mailto:[email protected]] On Behalf Of Fernando D. Bozzo Sent: Tuesday, June 14, 2016 4:59 PM To: [email protected] Subject: Re: A Blank Value for a Number? Ok, got it. About the NULL values in DBFs, to actually allow using them you need to explicitly select "NULL" option when defining a field, because if not, then you can't insert NULLs. Try "*MODIFY test*" in command Window and you will see that option at the right of the field definition. What I don't know is if later you will have errors because using NULLs with numbers 2016-06-14 22:50 GMT+02:00 Kurt Wendt <[email protected]>: > Fenando - thanks for your input. However, the problem is a little > deeper - and, yes - the request is kinda crazy indeed! > > If in the Temp file there is a Zero - then, when these other 2 > additional Excel files are generated during the process - it > generates data lines based upon a Zero - as the Zero is actually the > Tax Rate field. That's why they want the Tax Rate field as blank for > certain records where the Share counts are Zero. > > Regards, > Kurt Wendt > Senior Systems Analyst > > > Tel. +1-212-747-9100 > www.GlobeTax.com > > > -----Original Message----- > From: ProfoxTech [mailto:[email protected]] On Behalf Of > Fernando D. Bozzo > Sent: Tuesday, June 14, 2016 4:45 PM > To: [email protected] > Subject: Re: A Blank Value for a Number? > > Hi Kurt: > > I see that Management stupidity is not only here ;-) > > I think that you are trying to solve from the "Data" side something > that belong to the "Interface". In other words, the only thing they > want is to "not see" a zero, right? > > So what if you format the cells in a way that the mask applied does > not show the value when it is zero? > > I see 2 options: > > 1) Use a "Conditional Format" to make the foreground white when the > value is zero > > 2) If you search on the Office help for "hide zero" (I have the > Spanish version), you can found a setting applied for a specific > worksheet on which zero values can be hidden. > > I try to traduce the instructions I've found: > > - Click the rounded "Office" menu at top-left > - Select "Excel Options" at the bottom > - Select "Advanced" > - Look for "Options for this sheet" at the middle of the scrolling > - Uncheck "Show zero in cells that have a value of zero" > > > Best Regards.- > > > > 2016-06-14 22:02 GMT+02:00 Kurt Wendt <[email protected]>: > > > 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... > > > > Kurt Wendt > > Senior Systems Analyst > > [GlobeTax_SecondaryLogo_TwoColor_Lo]<https://www.globetax.com/> > > One New York Plaza - 34th Floor > > New York, NY 10004-1936, USA > > Tel. +1-212-747-9100 > > Direct +1-212-405-8246 > > www.GlobeTax.com<https://www.globetax.com/> > > > > GlobeTax does not provide or offer, and this is not, tax, investment > > or legal advice. This email and any attachments hereto is intended > > only for use by the addressee(s) and may contain confidential > > information. If you are not the intended recipient of this email, > > please immediately notify the sender at +1-212-747-9100 and > > permanently delete the original and any copies of this email. > > > > > > > > --- StripMime Report -- processed MIME parts --- multipart/related > > multipart/alternative > > text/plain (text body -- kept) > > text/html > > image/png > > --- > > [excessive quoting removed by server] _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/80838f1ca795b14ea1af48659f35166f2bd...@drexch02.corp.globetax.com ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
