testing for corruption

[Bob Stockler]

Scott Nelson wrote (on Thu, Jan 31, 2008 at 07:33:54PM -0800):

| We had a file get corrupted while changing the map, even though all the 
| keys were restructured successfully.  The suspected culprit is a posting 
| report that is a cron job, but we are still looking into it.   To assist 
| in repairing the fields affected, I want to test each record and the 
| fields by detecting the garbage graphic characters that appear in the 
| fields.  I seem to remember that this can be done with ascii or chr 
| codes and a range to see if the values are not 0-9 or a-z. 

It seems to me that this would be most easily done from an Alien
filePro file whose real file was the target "key" file.  Then you
could get the first 20 characters of each record on the screen,
and going through the file in record number order, could see the
first instance of any record-length discrepency.

Bob

-- 
Bob Stockler +-+ bob at trebor.iglou.com +-+ http://members.iglou.com/trebor