Re: Cleaning up garbage in packed numeric fields?? -- MIDRANGE-L

Subject: Re: Cleaning up garbage in packed numeric fields??
From: Douglas Handy <dhandy@xxxxxxxxx>
Date: Fri, 12 Aug 2005 12:20:28 -0400
List-archive: <http://archive.midrange.com/midrange-l>
List-help: <mailto:midrange-l-request@midrange.com?subject=help>
List-id: Midrange Systems Technical Discussion <midrange-l.midrange.com>
List-post: <mailto:midrange-l@midrange.com>
List-subscribe: <http://lists.midrange.com/mailman/listinfo/midrange-l>, <mailto:midrange-l-request@midrange.com?subject=subscribe>
List-unsubscribe: <http://lists.midrange.com/mailman/listinfo/midrange-l>, <mailto:midrange-l-request@midrange.com?subject=unsubscribe>

David,

> BRILLIANT!  

While FixNbr() can "fix" bad numeric data, I think the real question
is why the data is bad in the first place.  How can you be sure that
the "fix" by substituting invalid zone and digit nibbles really gives
you the value you should have?

You may be just treating a symptom and hiding a larger problem.  I
think you need to examine what creates the data (if this is under your
control).

IMHO

Doug

As an Amazon Associate we earn from qualifying purchases.

Follow-Ups:

Re: Cleaning up garbage in packed numeric fields?? , Barbara Morris
Resetting DST Password , Cletus Robinson

This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.