Find and Replace String in CSV must run as Batch File
$30-80 USD
货到付款
I need a script that can search through a whole csv using wildcard %% and replace that whole column with another word.
The target CSV will contain up-to 150,000 entries and the source file being used to replace with will contain 50,000 entries.
You may use any scripting language but must run on Windows and can be initiated from a batch file to automate the process. And you can use MySQL if you want.
But please note this has to be very fast as currently i have been using the following query in MYSQL with big performance problems:
UPDATE TABLE SET location = 'Leeds' WHERE location LIKE '%Leeds%';
Due to Mysql running a full table scan for each like statement and with 30,000+ this takes forever!
PLEASE ONLY BID IF YOU CAN GET THIS SETUP WITHIN ONE DAY.
项目ID： #4322879
关于项目
授予：
Hi We have read your project requirement in detail. Our team has the required expertise and knowledge to accomplish this requirement in the given time frame. Please let us know the best time to discuss the opportu 更多
有8名威客正在参与此工作的竞标，均价$74/小时
