Results 1 to 2 of 2
  1. #1
    mchadwick is offline Advanced Beginner
    Windows 7 64bit Access 2010 64bit
    Join Date
    Sep 2011
    Posts
    71

    Extract Text

    I have an email address that contains a LANID "Jones, Bob (bjones@domain1.com)". I would like to extract the "bjones" out of the field and put it into another field by itself in another field in the same record.

    Field 1
    Name
    Jones, Bob (bjones@domain1.com)

    Field 2
    LANID
    bjones

    The information I want to extract (or text) is always the same, between the "(" and the "@". What can I do in a query?

  2. #2
    pbaldy's Avatar
    pbaldy is offline Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    22,640
    You can combine the InStr() function with the Mid() function and some creativity to peel out that portion.
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Extract text from a certain word to the right
    By webisti in forum Queries
    Replies: 4
    Last Post: 10-23-2014, 12:18 PM
  2. Replies: 1
    Last Post: 05-15-2013, 01:24 PM
  3. Extract Text Data
    By tmcrouse in forum Queries
    Replies: 5
    Last Post: 05-25-2010, 11:34 AM
  4. extract text from memo
    By lions1855 in forum Queries
    Replies: 2
    Last Post: 05-03-2010, 07:28 AM
  5. Extract text from middle of a field
    By AccessNubie in forum Access
    Replies: 3
    Last Post: 11-02-2009, 01:13 PM

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums