Find and Replace String in CSV must run as Batch File

Slutfört Publicerat Mar 11, 2013 Betalades vid leverans

$30-80 USD

Betalades vid leverans

Slutfört Betalades vid leverans

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-programmering MySQL PHP Programvaruarkitektur Visual Basic

Projekt-id: #4322879

About the project

8 offerter Distansprojekt Aktivt Mar 11, 2013

Skulle du vilja tjäna pengar?

Fördelar med att lägga anbud på Freelancer

Ställ in budget och tidsram
Få betalt för ditt arbete
Skissa på ditt förslag
Det är gratis att registrera sig och lägga bud på jobb

Tilldelades:

beltechnologys Profilbild
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 Mer

$73 USD inom 1 dag
(0 omdömen)
0.0
qspsolutionss Profilbild
qspsolutions

Details in PMB.

$200 USD inom 1 dag
(12 omdömen)
5.6

8 frilansare har lagt bud på i genomsnitt $74 för det här jobbet

waelfrees Profilbild
waelfree

Hi, I can do that

$100 USD inom 1 dag
(50 omdömen)
5.8
pilicas Profilbild
pilica

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

$50 USD inom 1 dag
(10 omdömen)
4.0
kaloyan13s Profilbild
kaloyan13

C/C++ parallel programmer.

$50 USD inom 1 dag
(10 omdömen)
3.3
Pattanayaks Profilbild
Pattanayak

Hi, Please check PMB. Thanks Chinmay

$30 USD inom 2 dagar
(3 omdömen)
1.9
rubyonrailsdev21s Profilbild
rubyonrailsdev21

Hi, Please read private message. Thanks.

$30 USD inom 1 dag
(1 omdöme)
1.0
TCNGraphicExperts Profilbild
TCNGraphicExpert

Let's start the job.

$60 USD inom 3 dagar
(1 omdöme)
0.8
Lägg upp ett liknande projekt