RE: Email Internet Address Validation using Lotus Script Posted by Riyaz_77 Khan on 31.Jul.12 at 04:26 AM using a Web browser Category: Notes Client Release: All Releases Platform: Windows XP
Below function will help to validate email address in lotus script. This function return true if passed value is valid email address and return false if passed value is not valid email address. Just you need to call function in your code.
Function emailValidation( email As String)
Dim sFormulastr As String, vRetval As Variant
Dim username As String, domain As String
Dim domPart1 As String, domPart2 As String
Dim chkStr As String
emailValidation = False
sFormulastr = | @Left("| + email + |" ; "@")|
vRetval = Evaluate( sFormulastr )
username= Trim(vRetval(0) )
If username = "" Then
emailValidation = False
Exit Function
End If
sFormulastr = | @Right("| + email + |" ; "@")|
vRetval = Evaluate( sFormulastr )
domain= Trim(vRetval(0))
If domain = "" Then
emailValidation = False
Exit Function
End If
sFormulastr = | @Left("| + username + |" ; "@")|
vRetval = Evaluate( sFormulastr )
chkStr= vRetval(0)
If chkStr <> "" Then
emailValidation = False
Exit Function
End If
sFormulastr = | @Right("| + domain + |" ; "@")|
vRetval = Evaluate( sFormulastr )
chkStr= vRetval(0)
If chkStr <> "" Then
emailValidation = False
Exit Function
End If
sFormulastr = | @Left("| + domain + |" ; ".")|
vRetval = Evaluate( sFormulastr )
domPart1= vRetval(0)
If domPart1 = "" Then
emailValidation = False
Exit Function
End If
sFormulastr = | @Right("| + domain + |" ; ".")|
vRetval = Evaluate( sFormulastr )
domPart2= vRetval(0)
If domPart2 = "" Then
emailValidation = False
Exit Function
End If
sFormulastr = | @Left("| + domPart1 + |" ; ".")|
vRetval = Evaluate( sFormulastr )
chkStr= Trim(vRetval(0))
If chkStr <> "" Then
emailValidation = False
Exit Function
End If
sFormulastr = | @Right("| + domPart2 + |" ; ".")|
vRetval = Evaluate( sFormulastr )
chkStr= Trim(vRetval(0) )
If chkStr <> "" Then
emailValidation = False
Exit Function
End If
emailValidation = True
End Function
Email Internet Address Validation u... (Sarathbabu Rupa... 27.Jul.12)
. . RE: Email Internet Address Validati... (Wayne Gibbons 30.Jul.12)
. . . . RE: Email Internet Address Validati... (Riyaz_77 Khan 31.Jul.12)
. . . . . . RE: Email Internet Address Validati... (Sarathbabu Rupa... 31.Jul.12)
. . . . . . RE: Email Internet Address Validati... (Karl-Henry Mart... 13.Aug.12)
. . . . . . RE: Email Internet Address Validati... (Karl-Henry Mart... 13.Aug.12)
. . . . . . RE: Email Internet Address Validati... (Gabrielle R Cou... 24.Aug.12)
Document Options
Search this forum
Sign In or Register
Member Tools
RSS Feeds
Resources
Lotus Support
Wikis
Lotus Forums