Page 1 of 1
SSAN -first digit is zero
Posted: Sat Nov 03, 2001 2:12 pm
by a_rosenbaum_(Guest)
I have imported a spreadsheet file with a field of social security numbers.____Unfortunaely if the first number is zero it doies not show____Is there a formula to ad the zero if this condition exists.____Thank you
=> RE: SSAN -first digit is zero
Posted: Mon Nov 05, 2001 9:20 am
by kfleming
What data type does this field come in as in R&R?__The answer to the question depends on the datatype.______Kathleen__R&R Support
=> RE: SSAN -first digit is zero
Posted: Mon Nov 05, 2001 10:40 am
by John_McDonald_(Guest)
if the field is numeric ____if(field<100000000,"0"+str(field,8,0))____if the field is a character (assuming the field length is 9 characters)____if(left(field,1)=" ","0"+substr(field,2,8),field)____Hope that helps.____