Content-Type: |
text/plain;charset=us-ascii;format=flowed |
Sender: |
|
Subject: |
|
From: |
|
Date: |
Sun, 18 Sep 2005 22:42:18 -0500 |
In-Reply-To: |
|
MIME-Version: |
1.0 |
Reply-To: |
|
Parts/Attachments: |
|
|
In message
<[log in to unmask]>, Robert
Mills <[log in to unmask]> writes
>I have a dataset that holds an X8 item. The item should only contain
>spaces or a number but there are 4 entries that contain something else.
>If have tried doing a FIND MATCH but have been unable to get it to work.
>Any suggestions on the pattern to use?
Try:
NOT MATCHING "{b,d}{b,d}{b,d}{b,d}{b,d}{b,d}{b,d}{b,d}"
i.e. it is not the case that every position is either a digit or a
space.
Possibly:
NOT MATCHING "b*d*"
will suffice, if the legitimate values in your field are either spaces,
or numbers with leading spaces.
--
Roy Brown 'Have nothing in your houses that you do not know to be
Kelmscott Ltd useful, or believe to be beautiful' William Morris
* To join/leave the list, search archives, change list settings, *
* etc., please visit http://raven.utc.edu/archives/hp3000-l.html *
|
|
|