Visual Basic comparing two .txt documents

[Mike Fedkiw]

I am asking this here because it seems like a lot of you do more then filepro. 

I have an inventory file (invy.txt) with about 22,000 records in it. each line in the (invy.txt) file contains data like the following. (VEND   UPC#   MFG#   DESCRIPTION  ETC...). I have another file that is just a list of image names with about 12000 items in it "images.txt". looks like this (VEN_UPC.JPG) example= "pen_55555.jpg".

 The programmer I hired to do this is attempting to build arrays for each letter in the alphabet on the (vend_upc) and load in the appropriate records from my invy.txt file. He is then looking into the array that matches the first letter of the image we are looking for from my (images.txt) file.

It is not very fast. I know nothing about visual basic programming but there has to be a faster way.  I have seen something about text searches that say they index the text file somehow. 

Any help is always appreciated

Thank You in Advance
Mike Fedko 




-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://mailman.celestial.com/pipermail/filepro-list/attachments/20071206/4e46110b/attachment.html