Sub IsUnsignedInteger(s As String, allowNullString As Boolean) As Boolean
' Regex expression based on http://regexlib.com/Search.aspx?k=integer&AspxAutoDetectCookieSupport=1
If allowNullString And (s = "") Then
Return True
Else
Return IsNumber(s) And Regex.IsMatch("^\d+$", s)
End If
End Sub
Sub IsUnsignedDecimal(s As String, allowNullString As Boolean, decSep As String) As Boolean
Dim sep As String
If decSep.Trim = "" Then
sep = GetDecimalSeparator
Else
sep = decSep
End If
' Regex expression based on https://community.oracle.com/thread/429716
If allowNullString And (s = "") Then
Return True
Else
Return IsNumber(s) And Regex.IsMatch("^(\" & sep & "[0-9]+|[0-9]+(\" & sep & "[0-9]*)*)$", s)
End If
End Sub
Sub IsSignedInteger(s As String, allowNullString As Boolean) As Boolean
' Regex expression based on http://regexlib.com/Search.aspx?k=integer&AspxAutoDetectCookieSupport=1
If allowNullString And (s = "") Then
Return True
Else
Return IsNumber(s) And Regex.IsMatch("^(\+|-)?\d+$", s)
End If
End Sub
Sub IsSignedDecimal(s As String, allowNullString As Boolean, decSep As String) As Boolean
Dim sep As String
If decSep.Trim = "" Then
sep = GetDecimalSeparator
Else
sep = decSep
End If
' Regex expression based on https://community.oracle.com/thread/429716
' combined with http://regexlib.com/Search.aspx?k=integer&AspxAutoDetectCookieSupport=1
If allowNullString And (s = "") Then
Return True
Else
Return IsNumber(s) And Regex.IsMatch("^(\+|-)?(\" & sep & "[0-9]+|[0-9]+(\" & sep & "[0-9]*)*)$", s)
End If
End Sub
Sub GetDecimalSeparator As String
Return NumberFormat2(1.1, 1, 1, 1, False).SubString2(1, 2)
End Sub