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.

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.

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 )

     )

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.