string formatting

[Guest]

hey all,
how do i take a string like "123456789"
and format it like this: "123-45-6789"

thanks,
rodchar

 

[Homer J Simpson]

how do i take a string like "123456789"
and format it like this: "123-45-6789"

Should be something like Format$("123456789", "###-##-####")

Note that if this is a SSN it is a string, not a number.

 

[Steve_Black]

Try Format("123456789","@@@-@@-@@@@")

 

[Homer J Simpson]

Try Format("123456789","@@@-@@-@@@@")

That works in VB6 but they've dumped it in VB .Net. It's an SOB to find the
replacement.

 

[Homer J Simpson]

hey all,
how do i take a string like "123456789"
and format it like this: "123-45-6789"

Dim S As String = "123456789"
If Len(S) = 9 Then S = Mid(S, 1, 3) & "-" & Mid(S, 4, 2) & "-" & Mid(S, 6,
4)

 

[Guest]

thanks everyone.