Hi,
I wonder if someone can help me with this.
I have 1 value which I fetch from my access DB, which needs to be compared to hundreds/thousands of files in my server. But what I need to do is search for the file in my server which is almost identical to the value I got from my DB.
Example:
The value from the DB will be : OCRCC661600A058341DS9OTM00
The file I need to find will be : OCRCC661600A058341DS9OTM00DS9OTM0000.tif
As you can see it is identical until the characters M00, then the characters change. The tricky part is, the value in the DB might be 2 characters longer or 1 character shorter, or 4 shorter/3 Longer. It varies. But I would like to search for the file, up to the amount of characters that the value from the db has. Does this make sense?
If not please feel free to ask for additional information.
Thank you in advance.
...
Go to the complete details ...