Results 1 to 2 of 2

Thread: Need help

  1. #1
    Join Date
    Aug 2003

    Unanswered: Need help


    I am looking for a way to parse the results of a search.

    Say I search a table for all records containg 'xyz'. I find all records containing the text, then transfer them to a new table.

    However, I want to be able to display the records in the new table as just 'xyz', i.e. when I copy the records over, the whole record is copied such as: '.... .... .... xyz ...', I want the records to appear as just 'xyz'

    Can think of a way of doing this, maybe some VBA code to trim all the copied records to just 'xyz'??

    Any help would be great, cheers!

  2. #2
    Join Date
    Dec 2002
    Préverenges, Switzerland
    sure you can extract a string along the lines of
    extract = mid$("abcxyzdef", instring(1, "abcxyzdef", "xyz"), Len("xyz"))

    but you know "xyz" before you start, so why bother?

    confused.... izy

Posting Permissions

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