How to check Email validation in regular expression

Hello Friends,

I am trying to check whether email id is valid or not.
I have a pattern and i want this in function
my pattern is :

Please Login or Register  to view this content.

I don't understand how to use in function.

Please suggest me.

Try like this:

Please Login or Register  to view this content.

To use as

Formula:

Please Login or Register  to view this content.

Not tested.

Hi
thanks KOKOSEK

i tried but got error #VALUE!

That's your pattern.
With:

Please Login or Register  to view this content.

works fine and I think validate correctly. But it simple checking. I guess that your pattern is not correct. I am not a Regexp expert.

This should suffice in 99.99%.

Please Login or Register  to view this content.

hi bakerman2,
Your solution working fine.
but may I know whats wrong in my pattern because it is currently used in other software and its working fine.
I want this pattern to be used so that my result and software result will be same.

software script is as below:

Please Login or Register  to view this content.

[a-zA-Z0-9@]w+\.(com|net)

Thanks to reply dabaho
I just want to know what's wrong in above script which I posted.

Please suggest me
It's my great pleasure if Sir Jindon look in to the matter.

Thank you very much Jindon Sir with great explanation.

I am going to used Bakerman2 script.

And finally it's great time that you are still helping me and all of us on this forum.
I always follow you on this forum.
Wish you stay healthy and happy.

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.