Mask or format rule for email

[[email protected]]

Has anyone every done a custom mask for an email? An example of what I'm looking for is as follows:

[email protected]

What I'm trying to do is making sure that the "@" sign is present and the "us.dka.com" is in the right format. Maybe a Mask is the wrong thing. Potentially a script that would validate would be the better way to go.

Thanks,

Ryland

[G Gabriel]

Re: Mask or format rule for email

Maybe a Mask is the wrong thing.

It is.

Potentially a script that would validate would be the better way to go.

Not necessarily a script but a regex expression. This was discussed in details in another thread. I will see if I can locate it.

This one.

[G Gabriel]

Re: Mask or format rule for email

You might not even need a regex expression if all you want is to confirm that it ends with: @us.dka.com"

x="[email protected]"
?right(x,11)="@us.dka.com"
= .T.

[[email protected]]

Re: Mask or format rule for email

Thanks...I found one of the earlier posts that you pointed me to, and it is doing the trick... the format that appears to work fine is:


' Regex expression got this right
?regex_match("[email protected]","\b[A-Z0-9a-z._%-]+@[A-Z0-9a-z._%-]+\.[A-Za-z]{2,4}\b")
= .F.

so I changed my variables to match the example with a conditional variable names "user" and it working great.


if regex_match(user,"\b[A-Z0-9a-z._%-]+@[A-Z0-9a-z._%-]+\.[A-Za-z]{2,4}\b")= .F.
msgbox("Invalid email Format - Please Re-enter")
end
end if

Thanks, Ryland

[Scott Emerick]

Re: Mask or format rule for email

Hey Guys,

Maybe I am being too simple here or misunderstanding what was needed, but if all you want to do is make sure a email address is properly formatted why not just use A5_EMAIL_VALID()?

The A5_EMAIL_VALID() function determines if an email address is properly formatted. It does not validate the address itself.

Scott

[[email protected]]

Re: Mask or format rule for email

Hi Scott,

I tried that earlier, but since I have additional periods in between the first name , middle initial, and last name, as well as after the @ that function wasn't working for me. This last set if code checks for them and seems to be ok for now. Thanks, Ryland

[Scott Emerick]

Re: Mask or format rule for email

Hummmmm .. the function seems to work fine for me.

x = "[email protected]"
?a5_email_valid(x)
= .T.

?a5_email_valid("[email protected]")
= .T.

Maybe there was something else going on that made it not work ... In any case, if your happy with what you have then thats what counts.

Scott

[G Gabriel]

Re: Mask or format rule for email

if all you want to do is make sure a email address is properly formatted why not just use A5_EMAIL_VALID()?

Scott

He wants to validate a specific domain not just validate the email.

[CALocklin]

Re: Mask or format rule for email

Maybe I am being too simple here or misunderstanding what was needed, but if all you want to do is make sure a email address is properly formatted why not just use A5_EMAIL_VALID()?

FYI: Careful about assuming too much with A5_Email_valid(). All it really checks is that there is an @ sign and a period after the @ sign but not at the end of the email address. According to A5_Email_valid(), these are all acceptable:
Freddy#[email protected]
[email protected]
[email protected]
Freddy.*@somewhere.xqr
[email protected]

Even the regex method won't catch the ones with a period on either side of the @ sign. (I don't think that's allowed but haven't been able to verify it. I certainly don't recall ever seeing anything like that.) Maybe someone knows (a) if a period is allowed on either side or the @ sign or (b) how to fix the regex() method to reject it?

I'm not very good with the regex() command but adding this seems to work for rejecting the period before the @ sign:
regex_match("[email protected]","\b[A-Z0-9a-z._%-]+[A-Z0-9a-z]+@+[A-Z0-9a-z._%-]+\.[A-Za-z]{2,4}\b")
But I can't figure out how to check for it after the @ sign and still allow a one letter address like "x.com". (I think that's legal???)

Since I already had to build my own UDF, I don't need a regex() solution but it might be useful for others. Unfortunately, I came here to find a method I could use in A5v5 but neither of these - regex() or A5_email_valid() - works in that version so I had to write my own UDF.