Formatting String ? [*RESOLVED*]

Hi !

How can format a string in the Social Security Format which is
999-99-9999

I have to show a SSN in the above format in a resulting ASP page, which is entered by a user.

Right now I use the follwing code in my .asp page

Code:

---

tempSSN = request.querystring("SSN")
<%
response.write(tempSsn)
%>

---

and SSN is displayed as 999999999.


Any help would be appreciated.

Thanks
Nandu

I don't believe VBScript has a Format function... But you could do it this way:

VB Code:

SSN = "999999999"
fSSN = mid(SSN, 1, 3) & "-" & mid(SSN, 4, 2) & "-" & mid(SSN, 7, 4)
 
response.write(fSSN)

Here's how I do it in PHP (which is about what RG posted, only that the first line pads a too-short SSN with 0)

Code:

---

function format_ssn($ssn)
{
        $ssnstring = sprintf("%010s", $ssn);
        $ssnstring = substr($ssnstring, 0, 4)."-".substr($ssnstring, 4, 2)."-".
                substr($ssnstring, 6, 2)."-".substr($ssnstring, 8, 2);
        return $ssnstring;
}

---

It works like a charm.

Thanks a lot guys.................:bigyello:


Nandu