Subject: | |
From: | |
Reply To: | |
Date: | Tue, 14 Dec 2004 10:19:32 -0500 |
Content-Type: | text/plain |
Parts/Attachments: |
|
|
Kim Borgman wrote:
>Any way to easily find via query or supertool, a numeric field in IMAGE with
>garbage in it ?
>
>
>
One method I like to use to pick out the 'junk' entries is to use the
Query Total / Count
feature. (See example below) This will create a histogram sorted on the
item of interest
with a frequency count. Most of the time the 'junk' will come to the top
or the bottom
of the sort. You can specify a ,DEC to override the default and switch
to descending mode.
Cordially,
Mike Hornsby
Beechglen Development Inc.
513-922-0509
F all image-item
USING SERIAL READ
849752 ENTRIES QUALIFIED
>r
>>s1,image-item
>>t1,image-item,10
>>t1,image-item,20,count
>>end
* To join/leave the list, search archives, change list settings, *
* etc., please visit http://raven.utc.edu/archives/hp3000-l.html *
|
|
|