This is very easy to do, not in EXCEL, but ACCESS. Create
a new database. When you see the new database window,
right click in it and select link (I do not recommend
import). When the link dialog box opens make
sure "delimited" is selected and click next. Select OTHER
and put the ~ character in the text box. If the first row
has the field names make sure the "Use First Row As Field
Names" check box is checked; then click finished. I know,
this will bring in the whole file and you only need some
records. Click Queries under OBJECTS in the left portion
of the DB window. Select NEW. Select the table you just
linked then click ADD then CLOSE that dialog box. Now
let's say you know you want all the records where field3
is greater than 100. double the * character then double
click field3. In the lower portion of the query dialog
UNCHECK the Show box for field3 an put, in the CRITERIA
row under field3 >100. If it's text you are looking for
use Right(), Left() and Mid() for a particular string of
characters. For more information on right/left/mid look
them up in the Help file. Then click the red ! in the
tool bar.
HTH, Marty
