Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. chexsp

    STRING TRIM

    ok... basically I am building a query using Access. One of my fields has all the information, but in one full string (like the example I first posted in the topic). I am trying to extract each string piece individually(ie.NAME, ADDRESS, CODE, etc.) so, using the ACCESS Query Design builder...
  2. chexsp

    STRING TRIM

    oh.... nevermind I think I got it... instead of using "="...I use "ADDRESS=" DUH! sorry... thanks guys.
  3. chexsp

    STRING TRIM

    Sorry bout that. I should've mentioned that... Each in its own field. But, when it comes time to trimming the second field (ie. ADDRESS, according to my example), how will an Instr function work...if their are multiples of ";" and "=". won't it just keep outputing the first string inbetween...
  4. chexsp

    STRING TRIM

    Sorry guys...but I am confused. Is the Instr function supposed to work? My problem isn't trimming the first string (ie. NAME=MIKE). My problem is trimming the other strings after the first one... ie. "[ IGOTTOTRIMTHIS ]: NAME=MARK;ADDRESS=777 STREET;CODE=88"
  5. chexsp

    STRING TRIM

    I may have another idea. using a byVal function may work on the field. name:byVal("NAME=",[fieldname]) However, Access recognizes that this is a VB function, and it does not understand. Is there a way to import VB functions to Access?
  6. chexsp

    STRING TRIM

    Ya, unfortunatly they varry in size. I am attempting the Right() and Left(), but for some reason my query is coming out blank. Where could I check for the Right/Left trim tips?
  7. chexsp

    STRING TRIM

    I am in need of help. I need to trim multiple strings from a field in a Access database table. ie. "[ IGOTTOTRIMTHIS ]: NAME=MARK;ADDRESS=777 STREET;CODE=88" How would I just extract "MARK" using the proper SQL statement?
  8. chexsp

    ACCESS Multi-trim

    I am in need of help. I need to trim multiple strings from a field in a Access database table. ie. "[ IGOTTOTRIMTHIS ]: NAME=MARK;ADDRESS=777 STREET;CODE=88" How would I just extract "MARK" using the proper SQL statement?

Part and Inventory Search

Back
Top