Formatting Number/String Help Needed...

[e-roq777]

Hello Friends,

I am using ASP VBScript and i am trying to format a number/string. I am
trying to get this:
5982749259825982

to look like this:
598-7492598-5982

I tried a Mid function but I keep getting a Type mismatch 'Mid' error.
Here's my code:

Dim strMyNumber
strMyNumber = "5982749259825982 "

If Len(strMyNumber) >= 8 Then
Mid(strMyNumber, 4, 1) = "-"
Mid(strMyNumber, 12, 1) = "-"
End If

Thanks for any help. :)

[Joe Makowiec]

On 01 Apr 2005 in macromedia.dreamweaver.appdev, e-roq777 wrote:

> Hello Friends,
>
> I am using ASP VBScript and i am trying to format a number/string.
> I am trying to get this:
> 5982749259825982
>
> to look like this:
> 598-7492598-5982
>
> I tried a Mid function but I keep getting a Type mismatch 'Mid'
> error. Here's my code:
>
> Dim strMyNumber
> strMyNumber = "5982749259825982 "
>
> If Len(strMyNumber) >= 8 Then
> Mid(strMyNumber, 4, 1) = "-"
> Mid(strMyNumber, 12, 1) = "-"
> End If

Offhand, I'd guess that VBScript is assuming that strMyNumber is an
integer. Try casting as a string (cStr):

strMyNumber = cStr(5982749259825982)

or

mid(cStr(strMyNumber),4,1) = ...

--
Joe Makowiec
[url]http://makowiec.net/[/url]
Email: [url]http://makowiec.net/email.php[/url]