Part of the complication is this. The Temp data file that holds the data - prior to it getting exported to Excel - it Also is used to update an MS SQL Table. That's why the numeric field has to really stay numeric.
Regards, Kurt Wendt Senior Systems Analyst Tel. +1-212-747-9100 www.GlobeTax.com -----Original Message----- From: ProfoxTech [mailto:[email protected]] On Behalf Of John Weller Sent: Tuesday, June 14, 2016 4:35 PM To: [email protected] Subject: RE: A Blank Value for a Number? WAG warning! Have an extra character field in the dbf/cursor. Scan the cursor and copy the contents of the numeric field into the character field if it is a number then delete the numeric field from the dbf/cursor or do a select from the cursor excluding the numeric field into another cursor which can then be copied to an Excel file. HTH John John Weller 01380 723235 07976 393631 > -----Original Message----- > From: ProfoxTech [mailto:[email protected]] On Behalf Of > Kurt Wendt > Sent: 14 June 2016 21:03 > To: [email protected] > Subject: A Blank Value for a Number? > > 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.
