Subject: | |
From: | |
Reply To: | |
Date: | Sun, 18 Sep 2005 22:42:18 -0500 |
Content-Type: | text/plain |
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 *
|
|
|