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'??