Mail ID using Regular Expression

[asisha]

Hi all,

Can we control the number of characters through the regular expression
For example i want only 7 characters in first part of the mail id(before @ symbol)

How can we write the regular expression for that?

regards,
asisha

[surya_7mar]

Code:

Length(Split("someone@domain.com", "@")(0)) = 7

[vIns]

Hi..
Since you have asked this under Regular expression...We can do as given below...

Code:

Set myReg = New RegExp
myReg.Global = True
myReg.IgnoreCase = True

myReg.Pattern = "[a-z0-9]{2,7}@gmail.com" ' Here i just assumed that before @ we can have 2 min chars and max 7 chars. If u need 'to have only 7 then wirte like {7}

'returns true as no of chars 4
msgbox myReg.Test("test@gmail.com")

'returns false. as 1 char
msgbox myReg.Test("t@gmail.com")