Padding Zeros

jmss66 · July 31st, 2003, 12:54 PM

How can I pad zeros to a string of numbers?

I have a user entering a SSN. If a user's SSN begins with a zero, the variable I store it in is droping the zero entered. I was thinking of checking the length of the variable and if it is not = 9 then I will pad it with zeros. What is the code for padding zeros. I do not have my reference books with me here so I was hoping someone can help me on this.

Thanks,
Judy

kilika · July 31st, 2003, 12:58 PM

Right("000000000" & strSSN ,9)

The variable strSSN would contain your SSN. Just make sure it is stored as text in the variable and not a number as numbers with drop leading zeros

Chris

jmss66 · July 31st, 2003, 01:09 PM

It worked. Thanks for the help.

Judy

piercewashington · October 13th, 2005, 12:22 PM

In Oracle 9i, I found this statement worked

LPAD(strSSN, 9, '0')

it left pads the string with zeros to ensure the length is 9.

cforsyth · October 9th, 2007, 01:31 AM

This is the function I prefer:

Code:

Function PadZero(strIn, lngPad)
    If Len(strIn) < lngPad Then strIn = Right(String(lngPad+1,"0") & strIn, lngPad)
    PadZero = strIn
End Function

To use:

Code:

Response.Write(PadZero(1,3))

orizg · January 28th, 2008, 07:38 PM

A solution for VB.NET:

Dim MyNumber As Integer = 472

TxtFormattedNumber.Text = MyNumber.ToString().PadLeft(5, "0")

FYI, you should take a look to String object's PadLeft and PadRight methods.