HP3000-L Archives

March 2000, Week 1

HP3000-L@RAVEN.UTC.EDU

Options: Use Monospaced Font
Show Text Part by Default
Show All Mail Headers

Message: [<< First] [< Prev] [Next >] [Last >>]
Topic: [<< First] [< Prev] [Next >] [Last >>]
Author: [<< First] [< Prev] [Next >] [Last >>]

Print Reply
Subject:
From:
Tim Ericson <[log in to unmask]>
Reply To:
Tim Ericson <[log in to unmask]>
Date:
Tue, 7 Mar 2000 10:14:58 -0800
Content-Type:
text/plain
Parts/Attachments:
text/plain (34 lines)
Hi,

> The records I'm looking for have the following info:
>
> First Field:  bytes 1-6 = "UPSRED"  bytes 7-22 are blank
> bytes 23-26 = "nnnnn"  ( I need to find all records with UPSRED)
>
> Second Field:  bytes 1-2 = "10"  byte 3 = "n" (0 thru 9)
> byte 4 is blank
>
> How do I search for all records with UPSRED and a numeric string
> in 23-26  in field 1 and 10n in bytes 1-3 of field number 2.

You could try:

F FIELD1 IB "UPSRED                0000",&
"UPSRED                9999" AND FIELD2 IB "100 ","109 "

IB is 'In Between', and inclusive (the arguments are returned, too)

HTH!

 +-------------------------------------------------------------------+
  My mind is my own, as are my ideas and opinions.
  My heart, body, and soul, however, all belong to others.       Tim.
 +-------------------------------------------------------------------+
  Tim Ericson            tericson      DenKor Dental Management Corp.
  Sr. Systems Analyst     at denkor    503-526-4440 (my direct number)
    (& Systems Manager)     dot com         http://www.denkor.com
  Programming HP3000s since 1983!      Quality dental care since 1970!
 +-------------------------------------------------------------------+
  UDCs and Command Files:  http://www.denkor.com/hp3000/command_files
 +-------------------------------------------------------------------+

ATOM RSS1 RSS2