jbullydawg Posted April 24, 2007 Share Posted April 24, 2007 This might be a bizarre question but I'll try it out nonetheless: I have a layout we print quite a bit. The primary key is the SSN but we've slowly been moving to a new system where it's a 9 digit number but begins with a 9. So, new identifiers look like this 9xx-xxx-xxx. Is there a way when printing the form to control whether or not the SSN prints or not? If the field contains the new identifier (9xx-xxx-xxx) we want it to print but if it doesn't we would prefer it not print at all. thanks. Link to comment Share on other sites More sharing options...
Raybaudi Posted April 24, 2007 Share Posted April 24, 2007 Hi create a new calculation field, SSNtoPrint: Case( lenght(SSN) = 9 and Left(SSN;1) = 9 ; SSN ) and put this field in the form to print. Link to comment Share on other sites More sharing options...
mr_vodka Posted April 24, 2007 Share Posted April 24, 2007 Length in not going to really help you in this case since even if you use a filter for numbers, the difference can be just the location of the dash or typos. Try this instead: Let ( [ f= SSN; x= Substitute ( f; [0;"^"]; [1;"^"]; [2;"^"]; [3;"^"]; [4;"^"]; [5;"^"]; [6;"^"]; [7;"^"]; [8;"^"]; [9;"^"] ) ]; Case ( x = "^^^-^^^-^^^" and Left (f; 1) =9; f ) ) Link to comment Share on other sites More sharing options...
comment Posted April 25, 2007 Share Posted April 25, 2007 It would have been better to enter the new ID number into a separate field. In any case, it seems that a string that begins with "9" cannot be a valid SSN, so Case ( Left ( SSN ; 1 ) = "9" ; SSN ) should suffice. Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 6211 days old. Please don't post here. Open a new topic instead.
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now