Find and Replace String in CSV must run as Batch File

Imekamilika Ilichapishwa Mar 11, 2013 Kulipwa wakati wa kujifungua

$30-80 USD

Kulipwa wakati wa kujifungua

Imekamilika Kulipwa wakati wa kujifungua

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.

C Programming MySQL PHP Software Architecture Visual Basic

Kitambulisho cha Mradi: #4322879

Kuhusu mradi

8 mapendekezo Mradi wa mbali Ipo mtandaoni %project.latestActivity_relativeTime|badilisha%

Unapania kutengeneza pesa?

Faida za kutoa zabuni kwenye Freelancer

Weka bajeti yako na muda
Lipwa kwa kazi yako
Onyesha ombi lako
Ni bure kujisajili na kuweka zabuni kwa kazi

Imetuzwa kwa:

Picha ya Profaili ya beltechnology
beltechnology

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 Zaidi

$73 USD kwa siku 1
(Maoni 0)
0.0
Picha ya Profaili ya qspsolutions
qspsolutions

Details in PMB.

$200 USD kwa siku 1
(Maoni 12)
5.6

8 wafanyakazi huru wanazabuni wastani wa $74 kwa kazi hii

Picha ya Profaili ya waelfree
waelfree

Hi, I can do that

$100 USD kwa siku 1
(Maoni 50)
5.8
Picha ya Profaili ya pilica
pilica

I have experience in scripting, I can do this job.

$50 USD kwa siku 1
(Maoni 10)
4.0
Picha ya Profaili ya kaloyan13
kaloyan13

C/C++ parallel programmer.

$50 USD kwa siku 1
(Maoni 10)
3.3
Picha ya Profaili ya Pattanayak
Pattanayak

Hi, Please check PMB. Thanks Chinmay

$30 USD kwa siku 2
(Maoni 3)
1.9
Picha ya Profaili ya rubyonrailsdev21
rubyonrailsdev21

Hi, Please read private message. Thanks.

$30 USD kwa siku 1
(Maoni 1)
1.0
Picha ya Profaili ya TCNGraphicExpert
TCNGraphicExpert

Let's start the job.

$60 USD kwa siku 3
(Maoni 1)
0.8
Tuma Mradi Kama huu