Results 1 to 2 of 2
  1. 09-11-2016, 10:22 AM #1
    jmuirman1
    jmuirman1 is offline Advanced Beginner
    Windows 10 Access 2016
    Join Date
    Aug 2016
    Posts
    84

    How to eliminate partial data in field

    I accidentally turned text field into hyperlink - when I changed back again it added "mailto" text...

    I need to get rid of everything to the right of #

    What is in table/query field: john.doe@abc.com#mailto:john.doe@abc.com#



    what I want: john.doe@abc.com

    Thanks,

    John
    Reply With Quote Reply With Quote
  2. 09-11-2016, 10:37 AM #2
    ItsMe's Avatar
    ItsMe
    ItsMe is offline Sometimes Helpful
    Windows 8 Access 2013
    Join Date
    Aug 2013
    Posts
    7,862
    Maybe something like this?
    https://www.accessforums.net/showthr...265#post226265
    Reply With Quote Reply With Quote
Please reply to this thread with any new information or opinions.
« Previous Thread | Next Thread »

Similar Threads

  1. Need help creating a data query to eliminate irrelevent data
    By suprdave in forum Queries
    Replies: 6
    Last Post: 01-18-2016, 12:57 PM
  2. How to Eliminate a Comma in Name Fields, if Field has Only One Name? i.e. Aerosmith, Cher, etc.
    By tatihulot in forum Access
    Replies: 1
    Last Post: 02-27-2015, 11:29 AM
  3. Custom report based on partial data from a field
    By Degs29 in forum Reports
    Replies: 2
    Last Post: 05-31-2013, 01:29 PM
  4. Eliminate Multiple Data - not simple DIstinct way!!
    By r4echer87 in forum Queries
    Replies: 1
    Last Post: 08-11-2011, 07:36 AM
  5. Eliminate redundant data from Pick Box?
    By jsbdiver in forum Forms
    Replies: 5
    Last Post: 06-14-2010, 04:04 PM

Posting Permissions

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

Forum Rules

Other Forums: Microsoft Office Forums