Results 1 to 3 of 3

Thread: Please help!!

  1. #1
    Join Date
    Nov 2002
    Posts
    5

    Unhappy Unanswered: Please help!!

    I have a question. One of my fields in my table is as follows:

    CONTACT _EMAIL_ADDRESS
    cat@abc.oxford.edu
    sam@abc.oxford.edu
    jones@abc.oxford.edu
    smith@abc.oxford.edu
    my.email@cambridge.com

    I am trying to get a list of the email host provider EXCLUDING extension (.com or .edu). i got it so its just abc.oxford.edu but my question is how do i just get that alone without .edu or .com??

    Can ne1 help me please??!!

  2. #2
    Join Date
    Sep 2002
    Location
    UK
    Posts
    5,171
    Provided Answers: 1

    Re: Please help!!

    Originally posted by Confused1
    I have a question. One of my fields in my table is as follows:

    CONTACT _EMAIL_ADDRESS
    cat@abc.oxford.edu
    sam@abc.oxford.edu
    jones@abc.oxford.edu
    smith@abc.oxford.edu
    my.email@cambridge.com

    I am trying to get a list of the email host provider EXCLUDING extension (.com or .edu). i got it so its just abc.oxford.edu but my question is how do i just get that alone without .edu or .com??

    Can ne1 help me please??!!
    I don't know about "ne1" (I do hate textese), but I can help

    You can use INSTR to get the position of the last '.' in the address:

    INSTR( address, '.', -1 )

    Then use SUBSTR to get the address up to just before that:

    SUBSTR( address, 1, INSTR( address, '.', -1 ) - 1 )

  3. #3
    Join Date
    Nov 2002
    Posts
    5

    Smile

    Thank you Tony for your help.


    It works!! :-)

Posting Permissions

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