2 replies to this topic

[vertigo262]

Anyone know why this does this?

Server Error in '/' Application.
Arithmetic operation resulted in an overflow.

# <asp:Label ID="Label4" runat="server" Font-Size="Medium" Text='<%# GetPhoneFormat(Eval("Phone")) %>' />
#
#
# Function GetPhoneFormat(ByVal Phone As String) As String
#
# Dim PhoneFormat As String
# If IsDBNull(Phone) Or IsNothing(Phone) Then
# PhoneFormat = " "
# Else
#
# Phone = CInt(Phone).ToString("(000) 000-0000")
# PhoneFormat = "<b>Phone:</b> " & Phone
#
# End If
#
#
# Return PhoneFormat
# End Function
#

[vertigo262]

Someone gave me some better code. works

Dim cleanNumber As String = Regex.Replace(Phone, "[^0-9]", "")
Dim PhoneFormat As String = "<b>Phone:</b> " & Regex.Replace(cleanNumber, "(\d{3})(\d{3})(\d{4})", "($1) $2-$3")

[Alexander]

Quote

Arithmetic operation resulted in an overflow.

A phone number such as 000-000-0000 will result in an integer larger than 2.7 billion, which is the maximum a 32 bit signed integer can display. Regex is much easier to check with this.