We need a script (that I can easily run on my mac or windows) that will allow me to select 2 CSV files.
1) The first CSV will have thousands of rows (20k+) and each cell contains a lot of data (numbers, characters and letters)
2) The second CSV will have two columns. Column A is the string to be found in each cell (if it exists) of CSV A and column B is what to replace it with if it is found.
The process needs to be quick and it needs to run through CSV A to check for all in CSV B. Essentially, it is a find & replace we want to do on CSV A but with around 2000 options.
Need this in 4 hours from now - 3pm UK Time Saturday 15 May
hi there, i will make the exe to run in windows that will accept the two csv file, one with data and another with search and replace items in each row. Will make in 2 hours starting right now,thanks