Add mask to string value 2

[Hueby]

Hi,

I have a string datatype that is a SSN number.

I simply want to add a mask to that string like XXX-XX-XXXX.

Do I put this under the Display String in the format window...?

Not sure where and how to do this. Thanks!

 

[synapsevampire]

You can use a formula of:

picture({table.field},"xxx-xx-xxxx"

-k

 

[rosemaryl]

Dear Hueby,

Do you mean that you want to format the field so that it takes 9 digit number and formats it as xxx-xxx-xxxx or
do you mean you want to not show any of the digits and change it to show xxx-xxx-xxxx?

I am going to assume you want the former ...

Picture ({customer.SSN},"xxx-xxx-xxxx")

regards,

ro



Rosemary Lieberman
rosemary-at-microflo.com,

http://www.microflo.com

Microflo provides expert consulting on MagicTSD and Crystal Reports.

You will get answers more quickly if you read this before posting: faq149-3762

 

[Hueby]

Thank you to both of you.. that is exactly what I was trying to accomplish.