I have written a small database program using access and VB to store all the movies I have along with their location, format, director, cast etc. I also have a text file full of names of movies and I want to be able to search through this list for a specific set of words or a word. Basically, I have set my program to automatically enter the file name of a movie when I select it, but the name often contains lots of other words and characters that aren't relevant, so i want the program to compare each word in the file name with the names of the movies in my text file and suggest possibilities.
For example, If the file name is Pulp_Fiction xvd hjkhj stero.avi, it should suggest Pulp Fiction
I hope I have explained well enough. Please ask if I haven't been clear.