+ Reply to Thread
Results 1 to 5 of 5

Email Validation - standard character set and modern TLDs

  1. #1
    Forum Contributor
    Join Date
    02-27-2007
    Posts
    152

    Email Validation - standard character set and modern TLDs

    I am looking for a formula that will help to validate that the email in a cell is a valid email...

    Valid emails would include the standard characters set - a-z, 1-9, and a few characters like the underscore and period...
    there would then need to be the @ symbol
    and then a domain name that is also standard characters
    and then the TLD... like .com .co.uk .training .condos .ca, etc...

    Has anyone created such a validation?

    Thanks in advance.

  2. #2
    Forum Expert tim201110's Avatar
    Join Date
    10-23-2011
    Location
    Russia
    MS-Off Ver
    2016
    Posts
    1,475

    Re: Email Validation - standard character set and modern TLDs

    Please Login or Register  to view this content.
    Attached Files Attached Files
    Ctrl+c then Ctrl+v can destroy everything

  3. #3
    Forum Contributor
    Join Date
    02-27-2007
    Posts
    152

    Re: Email Validation - standard character set and modern TLDs

    Thanks...

    Is there a way to restrict the pattern a bit further. For example I don't want to allow for the # symbol and it seems to address that rather strangely or the % or potentially others.

  4. #4
    Forum Contributor
    Join Date
    02-27-2007
    Posts
    152

    Re: Email Validation - standard character set and modern TLDs

    Ive got some weird emails that I need to filter out...

    Things like - test⌂@test.com
    first#last@test.com
    name%@test.com

    these are the problematic ones

  5. #5
    Forum Contributor
    Join Date
    02-27-2007
    Posts
    152

    Re: Email Validation - standard character set and modern TLDs

    Did anyone have any other thoughts??

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1