perl and twitter [MAX BID $40]

I need a script that will read a semicolon delimted file and take the

last field in each row which is a location field from twitter and try

to match it with a database I have of cities and countries

the twitter record would look like below. They are not in any kind of

good shape. All I would like is to know what country it comes from if possible.

Sometimes there may not even be a location field. If the field is corrupt or empty it can be left out.

The input would be file containing these entries along with a database

of cities and countries that comes from

[url removed, login to view] (it is downloadable) and the

output would be the same file with the fields

Country City AccentCity Region Population Latitude Longitude


Some of the twitter locations are bad as for example:


_ -sittinq pretty on mars ;;

_ El Vaticano

_ New York, NY

_ Chicago

_ ÜT: [url removed, login to view],110.372674

_ Dover, NH

_ Houston TX

_ Merida, Yucatan, Mexico

_ Lima

_ Tampa/Portland

_ Caracas

_ Fairview-Wood Village, Oregon

_ Reikiavik, Lýðveldið Ísland

Here is the format for the tweets. Note there are about 200,000

records like the below in each file so the script cannot be too slow.

28062321;08:00:14;01;12;2009;acestasemy;@asanilta halo Asanilta aku

akan coba memikirkannya!;Jakarta Indonesia;;;;;0;0

28062322;08:00:14;01;12;2009;juhguastella;@natzzzz Na hora de mandar

todo mundo pro créu ninguem reclama né?! ¬¬' #ORobinWilliansCreu

HAUHSHUAUHSAUHSA #Red;Brazil;;;;;0;0

28062323;08:00:14;01;12;2009;SenhorFhodastic;@rene_navarro MSN?;Picos

PI Brasil;;;;;0;0

28062324;08:00:14;01;12;2009;Paatata;@Tinchusuey aw shiz can you text

her? Tell her what I was supposed to tell [url removed, login to view] YOOOU!;Down

the yellow brick road;;;;;0;0

28062325;08:00:14;01;12;2009;_Carbuncle;ã ã £ã ã ãƒ¼ï¼ ;魔導世界;;;;;0;0

28062326;08:00:14;01;12;2009;danniannie;i cant stand it;ingleby barwick.;;;;;0;0

28062327;08:00:14;01;12;2009;Seravim7;@empiremagazine #alecbaldwinporn

'The Shav(en haven)iator;Behind you!;;;;;0;0

28062328;08:00:15;01;12;2009;husein_goodboy;Jadwal malam ini nonton

film;ÃœT: [url removed, login to view] 107.623621;;;;;0;0

28062329;08:00:15;01;12;2009;speak3raudio;Watch Shoots High-Def Video

(Not Really) [url removed, login to view];Los Angeles;;;;;0;0

28062330;08:00:15;01;12;2009;edsabella;aduh internetnya cepet banget

deh hihihihihi tapi boong;ÃœT: [url removed, login to view] 106.783305;;;;;0;0

28062331;08:00:15;01;12;2009;liverice;ãƒˆãƒ©ãƒ™ãƒªãƒƒã‚¯ã‚¹ã ¯ã ˜ã ¾ã‚‹ã Šï¼ ã‚¸ãƒ£ã‚¹ãƒˆ;本州北㠮海近ã ;;;;;0;0

28062332;08:00:15;01;12;2009;DerLeon;Neuste Erkenntnis: Interface

Builder eignet sich auch für komplexe UIs;Berlin;;;;;0;0

28062333;08:00:15;01;12;2009;olalekt;Ehm !!!RT @Mr_Edgal: @olalekt na

naija be dis? [url removed, login to view];ÃœT: 6.544789


The database of cities looks like

Country City AccentCity Region Population Latitude Longitude

ad aixas Aixàs 6 42.4833333 1.4666667

ad aixirivali Aixirivali 6 42.4666667 1.5

ad aixirivall Aixirivall 6 42.4666667 1.5

ad aixirvall Aixirvall 6 42.4666667 1.5

ad aixovall Aixovall 6 42.4666667 1.4833333

ad andorra Andorra 7 42.5 1.5166667

ad andorra la vella Andorra la Vella 7 20430 42.5 1.5166667

ad andorra-vieille Andorra-Vieille 7 42.5 1.5166667

ad andorre Andorre 7 42.5 1.5166667

ad andorre-la-vieille Andorre-la-Vieille 7 42.5 1.5166667

ad andorre-vieille Andorre-Vieille 7 42.5 1.5166667

Evner: C programmering, Perl, PHP, Twitter, Visual Basic

Se mere: red-brick, look for twitter, high match, good and the bad, cr&r, cr. app, cr.app, com reg, perl twitter, md n, bad l, wood , what is a bid, tapi, TAMPA, shy, shape file, semicolon, rt, R pro

Om arbejdsgiveren:
( 53 bedømmelser ) Beppu shi, Japan

Projekt ID: #605406

Tildelt til:


Hello, please see PM

$40 USD på 1 dag
(21 bedømmelser)

6 freelancere byder i gennemsnit $40 på dette job


I was already chosen for the project

$40 USD in 2 dage
(134 bedømmelser)

Hi, I am willing to work with you ans can assure you about quality work. Let me know when to start. Thanks, Sagar

$40 USD in 2 dage
(1 bedømmelse)

Hello, pls chk PMB. THANKS

$40 USD på 1 dag
(0 bedømmelser)

Pleae check your PM

$50 USD på 1 dag
(0 bedømmelser)

I can do this for you. I have good hold on perl.

$30 USD in 3 dage
(0 bedømmelser)