Dear Ernie,
You can find any character you want by using the Clean, $findclean and
$clean feature. The first issue to deal with is to re-define the
item-number as a byte type in order to use the function.
The following shows how to find the fields with "invalid" zoned-decimal
characters. Remember that zoned fields use characters to indicate the
sign, it's likely that you don't have negative Item numbers but they are
valid.
get somedataset
def item-x,item-number,byte
{Setup what characters to look valid characters are 0-9, JKLMNOPQRST,
ABCDEFGHI and the curly braces }
{ so Clean characters should be not the above }
clean "^0:^47","^58:^64","^85:^122","^126:^255"
if $findclean(item-x)
ext item-x
list st
xeq
Note the clean command defines the "decimal" characters to look for.
See the online manual for more information on the clean feature.
Neil
On 2014-09-18, 21:10, Olav Kappert wrote:
> Null are not numbers. Try to use a byte string to compare (like < "a" or > "z") or something like that.
>
> Olav.
> ---- "Newton wrote:
>> Greetings,
>>
>> I am cleaning up our databases for the inevitable move to MS SQL.
>>
>> One thing I've encountered is that Suprtool does not like null characters where there should be numbers.
>>
>> I know that I have invalid characters, (non-numeric), in a field called ITEM-NUMBER. But when I try
>> to find those records, Suprtool chokes and abruptly stops the search.
>>
>> Here's what I get...
>>
>>> IF ITEM-NUMBER < 0 OR ITEM-NUMBER > 9999
>>> X
>> Error: Illegal ascii digit encountered. Please check all data sources
>>
>> Input record number: 1
>> Is there a way to run Suprtool to help it find these records?
>>
>> Query finds them just fine, but Query doesn't have to ability to do what I want to do.
>>
>> Thanks,
>>
>> Ernie
>>
>> ________________________________
>>
>> This message, including any attachments, is intended solely for the use of the named recipient(s) and may contain confidential and/or privileged information. Any unauthorized review, use, disclosure or distribution of this communication(s) is expressly prohibited. If you are not the intended recipient, please contact the sender by reply e-mail and destroy any and all copies of the original message.
>>
>> * To join/leave the list, search archives, change list settings, *
>> * etc., please visit http://raven.utc.edu/archives/hp3000-l.html *
> * To join/leave the list, search archives, change list settings, *
> * etc., please visit http://raven.utc.edu/archives/hp3000-l.html *
* To join/leave the list, search archives, change list settings, *
* etc., please visit http://raven.utc.edu/archives/hp3000-l.html *
|