HP3000-L Archives

September 2005, Week 3

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:
Roy Brown <[log in to unmask]>
Reply To:
Roy Brown <[log in to unmask]>
Date:
Sun, 18 Sep 2005 22:42:18 -0500
Content-Type:
text/plain
Parts/Attachments:
text/plain (29 lines)
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 *

ATOM RSS1 RSS2