filters in 4D

Article View: comp.sys.mac.databases

Article #95

Back to comp.sys.mac.databases Previous Next

#95

From: yijean tsai
Date: Tue, 28 Jul 1992 14:28

10 lines
944 bytes

  
I have a student ID field of 10 characters long. The student ID is normally a
social security number except for the foreign student there is a "Z" appened 
to a 9-digit number. I set the filter as "!#&9###-##-####~"z;Z"#". 

The problem is that when I enter a social security number for this field, it
will automatically append the "#" (or whichever placeholder I use) to the end. 
How could I get rid of the "#" such that I can get the correct selection when I
use the social security number to search for data.

Technical Details

Message-ID: <1992Jul28.142858.22140@news.nd.edu>

Path: arc1-ca.pugleaf.net!sparky!uunet!spool.mu.edu!news.nd.edu!news

Show Full Headers

Complete Article Headers

Path: arc1-ca.pugleaf.net!sparky!uunet!spool.mu.edu!news.nd.edu!news
From: ytsai@darwin.helios.nd.edu (yijean tsai)
Newsgroups: comp.sys.mac.databases
Subject: filters in 4D
Message-ID: <1992Jul28.142858.22140@news.nd.edu>
Date: 28 Jul 92 14:28:58 GMT
Article-I.D.: news.1992Jul28.142858.22140
Sender: news@news.nd.edu (USENET News System)
Distribution: usa
Organization: University of Notre Dame, Notre Dame
Lines: 10