LinkBack URL
About LinkBacks
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 :
I don't understand how to use in function.
Please Login or Register to view this content.
Please suggest me.
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 :
I don't understand how to use in function.Please Login or Register to view this content.
Please suggest me.
Regards,
MohanS
"Perfection is not attainable, but if we chase perfection we can catch excellence." - Vince Lombardi
You can simply say thanks by clicking "*Add Reputation" icon
Try like this:
To use asPlease Login or Register to view this content.Formula:
Please Login or Register to view this content.
Not tested.
Happy with my answer * Add Reputation.
If You are happy with solution, please use Thread tools and mark thread as SOLVED.
Hi
thanks KOKOSEK
i tried but got error #VALUE!
That's your pattern.
With:
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.Please Login or Register to view this content.
Last edited by KOKOSEK; 01-17-2020 at 06:17 AM.
This should suffice in 99.99%.
Please Login or Register to view this content.
Avoid using Select, Selection and Activate in your code. Use With ... End With instead.
You can show your appreciation for those that have helped you by clicking the * at the bottom left of any of their posts.
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)
"Presh Star Who has help you *For Add Reputation!! And mark case as Solve"
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.
Impossible to convert such pattern to Regular Expressions in vba.Originally Posted by mohan.r1980
R/E in vba only have limited functionalities/pattern matching, and one of them is negative look ahead.
Google and find the pattern and you will find none of them are perfect...
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.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks