I need a script that would scan product names and match them onto the XLS file with the Cat No. and barcodes.
Please do look at file attached “[url removed, login to view]”
[url removed, login to view] has a column of Product Names. It will take this data and match products onto the file “[url removed, login to view]”.
When it does find a match of a product name, it will take extra data from [url removed, login to view] file such as CAT NO. and Barcode No. and place them into the required blank fields in [url removed, login to view]
But it would need to be FLEXIBLE on the search match as it would not be exactly a 100% match.
It would need to take extracts from words and try to match them.
Example on Source File it product name may be “Escape to the Big Blue” and on the Input File the name may be “Finding Nemo - Escape to the Big Blue” so it will be still a match. But also there will be some names that do not match at all as they are not listed on the file and vice versa.
The script should be easy for me to use on my Windows XP PC. I do not mind how you build the script as long as it is reliable and fast to use. It should be able to hand files with 1,000s of product names.
This script must not be a one time use feature for this type of data match this is just a example and I should be able to use it on other XLS files in the same way.
Please do send a working demo so I know that you understand on how the script works.
Also NO time wasters.