'CSV' stands for Comma Separated Values. The data is in ASCII text format, with rows and columns. The first row often holds column headings. Data items in a row are separated with ',' signs, ASCII 34 or h2C. Rows and whole file end with CRLF, ie h0D h0A, or chr$( 13) chr$( 10).
This should be visible in the printout below of part of a sample file as text and as a hex dump.
Note that while all spreadsheets will load and save in csv format, their native format is much bulkier, with all sorts of formatting data, macros, etc.
I've often found data on the web, such as astronomical star data, that can be read straight into LB for me to do whatever I like. See an example.
Another example was I found datafiles online of height above sea level by latitude and longitude, so in LB could generate animated maps of the effects of rising sea levels where I live.
There are always things to do with data that even the creators of Excel haven't thought of- 'though my LB code may run slower, it is more versatile.
Two things may complicate your use of csv files obtained from others.
Linux and Microsoft use different line/file terminators. It may be CRLF, or one of these chars alone.
In an effort to make csv files hold more universal character strings, especially those holding commas ',' and '"' 'quote' characters, you may find strings surrounded by chr$( 34) quote characters.
Any decent spreadsheet ( Excel, Open Office) will offer to import all such files and allow you to chreck exactly what you are importing and what it may become on import.
User beware!
' ************************************************************************************ ' ** ** ' ** readWriteCsv3.bas tenochtitlanuk Feb/July 2019 ** ' ** ** ' ************************************************************************************ ' I have a csv-separated list of people's names, email, tel, addresses, etc. "MOCK_DATA.csv" ' Read csv file into an array... dim data$( 1000, 20) ' anticipate up to 1000 rows, 20 columns. data$( col, row) i =1 ' (assume you want terms to start at 0 rather than zero) global recNum, numRows, numCols, fn$, firstRow$ filedialog "Choose csv datafile", "*.csv", fn$ open fn$ for input as #fileIn line input #fileIn, firstRow$ numCols =1 ' find number of columns for f =1 to len( firstRow$) if mid$( firstRow$, f, 1) ="," then numCols =numCols +1 next f while eof( #fileIn) =0 ' read each row and its column entries into an array line input #fileIn, row$ for k =0 to numCols item$ =word$( row$, k, ",") if item$ <>"" then data$( i, k) =item$ ': print item$, next k i =i +1 scan 'print "" ' start a new row wend numRows =i -1 close #fileIn ' array now holds all the data. textbox #w.te1, 220, 40, 400, 30 textbox #w.te2, 220, 80, 400, 30 textbox #w.te3, 220, 120, 400, 30 textbox #w.te4, 220, 160, 400, 30 textbox #w.te5, 220, 200, 400, 30 textbox #w.te6, 220, 240, 400, 30 textbox #w.te7, 220, 280, 400, 30 textbox #w.te8, 220, 320, 400, 30 textbox #w.te9, 220, 360, 400, 30 textbox #w.te10, 220, 400, 400, 30 textbox #w.te11, 220, 440, 400, 30 textbox #w.te12, 220, 480, 400, 30 statictext #w.st1, "", 20, 40, 180, 30 statictext #w.st2, "", 20, 80, 180, 30 statictext #w.st3, "", 20, 120, 180, 30 statictext #w.st4, "", 20, 160, 180, 30 statictext #w.st5, "", 20, 200, 180, 30 statictext #w.st6, "", 20, 240, 180, 30 statictext #w.st7, "", 20, 280, 180, 30 statictext #w.st8, "", 20, 320, 180, 30 statictext #w.st9, "", 20, 360, 180, 30 statictext #w.st10, "", 20, 400, 180, 30 statictext #w.st11, "", 20, 440, 180, 30 statictext #w.st11, "", 20, 480, 180, 30 statictext #w.st12, "", 20, 520, 180, 30 button #w.bu1, "Record no?", recordNumber, LR, 200, 420, 160, 30 button #w.bu2, "Print?", printRecord, LR, 200, 380, 160, 30 button #w.bu3, "Save Record", saveEdit, LR, 200, 340, 160, 30 button #w.bu4, "Save DBase", saveFile, LR, 200, 260, 160, 30 button #w.bu5, "Quit", quit, LR, 200, 140, 160, 30 bmpbutton #w.bb1, "left.bmp", returnVar, LR, 210, 390 bmpbutton #w.bb2, "right.bmp", returnVar, LR, 10, 390 nomainwin WindowWidth =1000 WindowHeight = 600 open "Demo. csv data read/ alter/ write" for window as #w #w "trapclose quit" #w "font 10 bold" #w.st1 word$( firstRow$, 1, ",") #w.st2 word$( firstRow$, 2, ",") #w.st3 word$( firstRow$, 3, ",") #w.st4 word$( firstRow$, 4, ",") #w.st5 word$( firstRow$, 5, ",") #w.st6 word$( firstRow$, 6, ",") #w.st7 word$( firstRow$, 7, ",") #w.st8 word$( firstRow$, 8, ",") #w.st9 word$( firstRow$, 9, ",") #w.st10 word$( firstRow$, 10, ",") #w.st11 word$( firstRow$, 11, ",") #w.st12 word$( firstRow$, 12, ",") #w.te1 data$( 1, 1) #w.te2 data$( 1, 2) #w.te3 data$( 1, 3) #w.te4 data$( 1, 4) #w.te5 data$( 1, 5) #w.te6 data$( 1, 6) #w.te7 data$( 1, 7) #w.te8 data$( 1, 8) #w.te9 data$( 1, 9) #w.te10 data$( 1, 10) #w.te11 data$( 1, 11) #w.te12 data$( 1, 12) wait sub recordNumber a$ prompt "Desired record number"; rec$ recNum =val( rec$) for k =1 to numCols #w.te1 data$( recNum, 1) #w.te2 data$( recNum, 2) #w.te3 data$( recNum, 3) #w.te4 data$( recNum, 4) #w.te5 data$( recNum, 5) #w.te6 data$( recNum, 6) #w.te7 data$( recNum, 7) #w.te8 data$( recNum, 8) #w.te9 data$( recNum, 9) #w.te10 data$( recNum, 10) #w.te11 data$( recNum, 11) #w.te12 data$( recNum, 12) next k end sub sub printRecord a$ ' not implemented... end sub sub saveEdit a$ for k =1 to numCols #w.te1 "!contents? c$": data$( recNum, 1) =c$ #w.te2 "!contents? c$": data$( recNum, 2) =c$ #w.te3 "!contents? c$": data$( recNum, 3) =c$ #w.te4 "!contents? c$": data$( recNum, 4) =c$ #w.te5 "!contents? c$": data$( recNum, 5) =c$ #w.te6 "!contents? c$": data$( recNum, 6) =c$ #w.te7 "!contents? c$": data$( recNum, 7) =c$ #w.te8 "!contents? c$": data$( recNum, 8) =c$ #w.te9 "!contents? c$": data$( recNum, 9) =c$ #w.te10 "!contents? c$": data$( recNum, 10) =c$ #w.te11 "!contents? c$": data$( recNum, 11) =c$ #w.te12 "!contents? c$": data$( recNum, 12) =c$ next k end sub sub saveFile a$ fileOut$ =word$( fn$, 1, ".") +"New.csv" open fileOut$ for output as #fOut #fOut firstRow$ +chr$( 13) +chr$( 10); for i =1 to numRows for j =1 to numCols #fOut data$( i, j); if j <>numCols then #fOut ","; next j #fOut chr$( 13) +chr$( 10); next i close #fOut end sub sub quit h$ ' save array as csv file with amended name ' put up notice saying saving before exit close #w end end sub textbox #w.te4, 220, 160, 400, 30 textbox #w.te5, 220, 200, 400, 30 textbox #w.te6, 220, 240, 400, 30 textbox #w.te7, 220, 280, 400, 30 textbox #w.te8, 220, 320, 400, 30 textbox #w.te9, 220, 360, 400, 30 textbox #w.te10, 220, 400, 400, 30 textbox #w.te11, 220, 440, 400, 30 textbox #w.te12, 220, 480, 400, 30 statictext #w.st1, "", 20, 40, 180, 30 statictext #w.st2, "", 20, 80, 180, 30 statictext #w.st3, "", 20, 120, 180, 30 statictext #w.st4, "", 20, 160, 180, 30 statictext #w.st5, "", 20, 200, 180, 30 statictext #w.st6, "", 20, 240, 180, 30 statictext #w.st7, "", 20, 280, 180, 30 statictext #w.st8, "", 20, 320, 180, 30 statictext #w.st9, "", 20, 360, 180, 30 statictext #w.st10, "", 20, 400, 180, 30 statictext #w.st11, "", 20, 440, 180, 30 statictext #w.st11, "", 20, 480, 180, 30 statictext #w.st12, "", 20, 520, 180, 30 button #w.bu1, "Record no?", recordNumber, LR, 200, 420, 160, 30 button #w.bu2, "Print?", printRecord, LR, 200, 380, 160, 30 button #w.bu3, "Save Record", saveEdit, LR, 200, 340, 160, 30 button #w.bu4, "Save DBase", saveFile, LR, 200, 260, 160, 30 button #w.bu5, "Quit", quit, LR, 200, 140, 160, 30 bmpbutton #w.bb1, "left.bmp", returnVar, LR, 210, 390 bmpbutton #w.bb2, "right.bmp", returnVar, LR, 10, 390 nomainwin WindowWidth =1000 WindowHeight = 600 open "Demo. csv data read/ alter/ write" for window as #w #w "trapclose quit" #w "font 10 bold" #w.st1 word$( firstRow$, 1, ",") #w.st2 word$( firstRow$, 2, ",") #w.st3 word$( firstRow$, 3, ",") #w.st4 word$( firstRow$, 4, ",") #w.st5 word$( firstRow$, 5, ",") #w.st6 word$( firstRow$, 6, ",") #w.st7 word$( firstRow$, 7, ",") #w.st8 word$( firstRow$, 8, ",") #w.st9 word$( firstRow$, 9, ",") #w.st10 word$( firstRow$, 10, ",") #w.st11 word$( firstRow$, 11, ",") #w.st12 word$( firstRow$, 12, ",") #w.te1 data$( 1, 1) #w.te2 data$( 1, 2) #w.te3 data$( 1, 3) #w.te4 data$( 1, 4) #w.te5 data$( 1, 5) #w.te6 data$( 1, 6) #w.te7 data$( 1, 7) #w.te8 data$( 1, 8) #w.te9 data$( 1, 9) #w.te10 data$( 1, 10) #w.te11 data$( 1, 11) #w.te12 data$( 1, 12) wait sub recordNumber a$ prompt "Desired record number"; rec$ recNum =val( rec$) for k =1 to numCols #w.te1 data$( recNum, 1) #w.te2 data$( recNum, 2) #w.te3 data$( recNum, 3) #w.te4 data$( recNum, 4) #w.te5 data$( recNum, 5) #w.te6 data$( recNum, 6) #w.te7 data$( recNum, 7) #w.te8 data$( recNum, 8) #w.te9 data$( recNum, 9) #w.te10 data$( recNum, 10) #w.te11 data$( recNum, 11) #w.te12 data$( recNum, 12) next k end sub sub printRecord a$ ' not implemented... end sub sub saveEdit a$ for k =1 to numCols #w.te1 "!contents? c$": data$( recNum, 1) =c$ #w.te2 "!contents? c$": data$( recNum, 2) =c$ #w.te3 "!contents? c$": data$( recNum, 3) =c$ #w.te4 "!contents? c$": data$( recNum, 4) =c$ #w.te5 "!contents? c$": data$( recNum, 5) =c$ #w.te6 "!contents? c$": data$( recNum, 6) =c$ #w.te7 "!contents? c$": data$( recNum, 7) =c$ #w.te8 "!contents? c$": data$( recNum, 8) =c$ #w.te9 "!contents? c$": data$( recNum, 9) =c$ #w.te10 "!contents? c$": data$( recNum, 10) =c$ #w.te11 "!contents? c$": data$( recNum, 11) =c$ #w.te12 "!contents? c$": data$( recNum, 12) =c$ next k end sub sub saveFile a$ fileOut$ =word$( fn$, 1, ".") +"New.csv" open fileOut$ for output as #fOut #fOut firstRow$ +chr$( 13) +chr$( 10); for i =1 to numRows for j =1 to numCols #fOut data$( i, j); if j <>numCols then #fOut ","; next j #fOut chr$( 13) +chr$( 10); next i close #fOut end sub sub quit h$ ' save array as csv file with amended name ' put up notice saying saving before exit close #w end end suband the data file
id,first_name,last_name,email,gender,ip_address,Town,Country,Telephone 1,Mellisent,Atkinson,matkinson0@ed.gov,Female,132.184.164.67,Ufimskiy,Russia,+7-528-235-0490 2,Merrel,Dewdney,mdewdney1@google.com,Male,70.194.5.103,Bergerac,France,+33-591-768-4351 3,Horace,Gillum,hgillum2@google.com.hk,Male,151.229.167.50,Xinsheng,China,+86-733-329-5150 4,Ruthie,De Avenell,rdeavenell3@noaa.gov,Female,46.101.6.221,Al Mughayyir,Palestinian Territory,+970-175-858-9294 5,Blayne,Sherrocks,bsherrocks4@walmart.com,Male,200.133.217.60,Cikuya,Indonesia,+62-104-965-3112 6,Phedra,Keizman,pkeizman5@creativecommons.org,Female,233.14.22.195,Kloulklubed,Palau,+680-683-365-3528 7,Kandy,Ketchell,kketchell6@sciencedaily.com,Female,152.161.77.217,Suhong,China,+86-192-941-0861 8,Jerrold,Risebrow,jrisebrow7@cloudflare.com,Male,44.2.25.162,Phùng,Vietnam,+84-770-132-7341 9,Adrianne,Yetton,ayetton8@usnews.com,Female,134.147.18.12,Quintães,Portugal,+351-683-326-1607 10,Alphonso,Garn,agarn9@cam.ac.uk,Male,58.247.147.67,Mosina,Poland,+48-491-200-1739 11,Daffi,Stoneman,dstonemana@ycombinator.com,Female,200.102.84.250,Sangongqiao,China,+86-388-291-5597 12,Bernardine,Ayre,bayreb@stanford.edu,Female,73.112.54.209,Podedwórze,Poland,+48-543-654-6838 13,Stesha,Dwelling,sdwellingc@wufoo.com,Female,64.224.239.181,Oygon,Mongolia,+976-995-338-8965 14,Lotte,Tremontana,ltremontanad@fda.gov,Female,221.162.119.2,Donglai,China,+86-700-740-3566 15,Brendin,Breazeall,bbreazealle@huffingtonpost.com,Male,128.227.20.247,Khŭjand,Tajikistan,+992-218-144-1725 16,Tadeo,Snaith,tsnaithf@gmpg.org,Male,133.17.119.34,Margen,Philippines,+63-285-446-4383 17,Cecil,Currington,ccurringtong@huffingtonpost.com,Male,215.116.19.24,Gongyi,China,+86-903-994-9291 18,Ula,Ikin,uikinh@tuttocitta.it,Female,125.26.174.192,Dallas,United States,+1-214-308-6606 19,Jamill,Bortol,jbortoli@hao123.com,Male,233.167.213.156,Qalyūb,Egypt,+20-660-288-7735 20,Loren,Toms,ltomsj@posterous.com,Male,78.25.89.59,Catumbela,Angola,+244-737-862-1467 21,Gerald,Coupar,gcoupark@vistaprint.com,Male,168.191.115.138,Mosteiro,Portugal,+351-411-183-6425 22,Wilhelmine,Portch,wportchl@live.com,Female,212.120.215.132,Catalina,Canada,+1-498-980-8191 23,Danella,Iannitti,diannittim@cafepress.com,Female,85.35.238.115,Cikijing,Indonesia,+62-351-439-3089 24,Merla,Bartosik,mbartosikn@wordpress.org,Female,97.34.148.119,Halimpu,Indonesia,+62-802-887-4954 25,Carolin,Hatwells,chatwellso@bbc.co.uk,Female,11.76.28.58,La Guata,Honduras,+504-539-930-1056 26,Charlotte,Housego,chousegop@edublogs.org,Female,15.244.59.36,Union,Philippines,+63-215-362-9722 27,Ermentrude,De la Yglesia,edelayglesiaq@cnet.com,Female,10.20.30.10,Fredrikstad,Norway,+47-920-543-5360 28,Waldemar,Dussy,wdussyr@bbb.org,Male,194.44.178.3,Sindangrasa,Indonesia,+62-663-525-6055 29,Chrissy,Jeffes,cjeffess@sourceforge.net,Male,67.78.158.212,Mozdok,Russia,+7-994-931-6910 30,Almira,Coggin,acoggint@ask.com,Female,33.185.159.208,Viengxay,Laos,+856-204-846-4348 31,Franni,Alloisi,falloisiu@exblog.jp,Female,105.81.104.18,Kelowna,Canada,+1-788-800-5974 32,Opaline,Barrack,obarrackv@intel.com,Female,50.87.131.158,Punta de Bombón,Peru,+51-838-997-6993 33,Lorrin,Lidington,llidingtonw@dedecms.com,Female,207.165.84.117,Khanu Woralaksaburi,Thailand,+66-898-641-8477 34,Tessy,Wyllie,twylliex@microsoft.com,Female,185.82.119.102,Biny Selo,Azerbaijan,+994-463-409-9764 35,Michelle,Lamey,mlameyy@ox.ac.uk,Female,171.239.200.244,Chodów,Poland,+48-330-635-9288 36,Christiane,Esome,cesomez@blogtalkradio.com,Female,151.0.7.26,Bulakan,Indonesia,+62-441-956-7520 37,Calypso,McConville,cmcconville10@sciencedaily.com,Female,96.106.196.11,Bamako,Mali,+223-147-170-1387 38,Mariska,Cajkler,mcajkler11@hc360.com,Female,40.81.46.120,Stockholm,Sweden,+46-250-912-7715 39,Laurianne,Bhar,lbhar12@bbb.org,Female,192.30.185.168,Rudnichnyy,Russia,+7-373-760-2913 40,Margarete,Kleinsmuntz,mkleinsmuntz13@trellian.com,Female,223.185.120.92,Chuoyuan,China,+86-729-800-7953 41,Gibb,Erett,gerett14@jugem.jp,Male,43.218.194.231,Wuma,China,+86-173-316-4743 42,Halsy,Selby,hselby15@vistaprint.com,Male,73.204.129.99,Porto Ferreira,Brazil,+55-521-227-0896 43,Vail,Keuneke,vkeuneke16@miitbeian.gov.cn,Male,131.173.59.121,La Asunción,Costa Rica,+506-679-947-5759 44,Timoteo,Cranfield,tcranfield17@nymag.com,Male,15.43.123.233,Provo,United States,+1-801-702-0105 45,Iris,Wailes,iwailes18@theglobeandmail.com,Female,32.120.146.157,Zhuoshui,China,+86-340-446-0402 46,Hurlee,Croote,hcroote19@people.com.cn,Male,2.15.218.99,Oklahoma City,United States,+1-405-467-5360 47,Trip,Biaggioni,tbiaggioni1a@ezinearticles.com,Male,249.235.191.248,Xiang Ngeun,Laos,+856-904-201-9963 48,Rosmunda,Spaven,rspaven1b@cafepress.com,Female,132.17.114.23,Jiepai,China,+86-551-474-3866 49,Pembroke,Healings,phealings1c@multiply.com,Male,180.141.93.26,Shuangqiao,China,+86-164-911-0662 50,Norbert,Mableson,nmableson1d@fastcompany.com,Male,171.2.77.2,Saint Ann’s Bay,Jamaica,+1-129-477-0756 51,Urban,Standingford,ustandingford1e@unicef.org,Male,176.8.59.134,El Charco,Colombia,+57-362-918-3490 52,Hy,Grinsted,hgrinsted1f@lulu.com,Male,214.151.253.75,Kashima-shi,Japan,+81-985-703-3000 53,Abdel,Trudgian,atrudgian1g@oaic.gov.au,Male,85.190.169.169,Bibis,Indonesia,+62-709-524-0810 54,Adelaide,Mileham,amileham1h@cpanel.net,Female,156.103.71.246,Xingcheng,China,+86-197-251-9291 55,Vicky,Nossent,vnossent1i@51.la,Female,78.57.121.128,Saint-Germain-en-Laye,France,+33-497-768-8418 56,Cordelia,Sibthorpe,csibthorpe1j@google.com,Female,10.89.138.163,Shiyu,China,+86-637-971-7501 57,Maurie,Schaffel,mschaffel1k@princeton.edu,Male,77.237.1.35,Öndörhoshuu,Mongolia,+976-207-506-1867 58,Bel,Grelik,bgrelik1l@chron.com,Female,97.35.181.181,Hongyi,China,+86-967-167-3437 59,Annabela,Barles,abarles1m@ucsd.edu,Female,224.156.95.19,Nanmen,China,+86-120-234-1505 60,Giuditta,Arthan,garthan1n@purevolume.com,Female,200.90.124.51,Lupane,Zimbabwe,+263-524-920-3341 61,Carley,Troucher,ctroucher1o@instagram.com,Female,40.81.12.21,Ostrzeszów,Poland,+48-433-595-1287 62,Elsworth,Deverell,edeverell1p@accuweather.com,Male,129.203.49.255,Svatava,Czech Republic,+420-705-293-7237 63,Davine,Durward,ddurward1q@spiegel.de,Female,44.111.82.181,Sanxixiang,China,+86-818-877-9762 64,Willis,Cardon,wcardon1r@cornell.edu,Male,2.149.231.159,Candelária,Portugal,+351-739-240-4462 65,Stefania,Georgins,sgeorgins1s@mozilla.com,Female,21.65.42.195,San Calixto,Colombia,+57-174-336-9255 66,Terese,Cherryman,tcherryman1t@edublogs.org,Female,147.93.30.17,Sahagún,Colombia,+57-317-520-7966 67,Rebecka,Dawltrey,rdawltrey1u@angelfire.com,Female,162.246.195.12,Solosolo,Samoa,+685-954-101-1438 68,Ricki,Doud,rdoud1v@cdc.gov,Female,157.177.245.23,Fort Worth,United States,+1-682-927-8447 69,Jeffy,Conrad,jconrad1w@xrea.com,Male,182.156.147.173,Vandœuvre-lès-Nancy,France,+33-414-711-1575 70,Joel,Faucherand,jfaucherand1x@booking.com,Male,236.232.85.41,Naviraí,Brazil,+55-926-346-4469 71,Raimund,Deeny,rdeeny1y@clickbank.net,Male,54.41.237.5,Megáli Khóra,Greece,+30-814-453-8281 72,Brodie,Keetley,bkeetley1z@wunderground.com,Male,97.254.112.232,Ryazanskiy,Russia,+7-921-494-9759 73,Fayre,Larmour,flarmour20@trellian.com,Female,203.69.189.118,Portalegre,Portugal,+351-248-783-7183 74,Derrik,Royan,droyan21@nsw.gov.au,Male,164.20.5.61,Hennenman,South Africa,+27-460-422-8942 75,Jorgan,Goulborn,jgoulborn22@wordpress.com,Male,42.83.219.184,Novokuz’minki,Russia,+7-250-652-0042 76,Syd,Nuccii,snuccii23@vk.com,Male,82.207.183.126,Manwakh,Yemen,+967-857-964-5153 77,Verney,Bertenshaw,vbertenshaw24@narod.ru,Male,2.30.102.38,Sundbyberg,Sweden,+46-993-652-1798 78,Adler,Bootyman,abootyman25@homestead.com,Male,131.75.47.178,Wuxi,China,+86-479-235-6679 79,Maynord,Hefferon,mhefferon26@sogou.com,Male,69.109.37.56,Erdaobaihe,China,+86-309-118-2040 80,Didi,Ambroisin,dambroisin27@blog.com,Female,11.244.157.71,Bayanhongor,Mongolia,+976-286-884-4813 81,Karel,Winship,kwinship28@cloudflare.com,Female,254.98.40.149,Yigo Village,Guam,+1-573-835-0519 82,Kip,Finlayson,kfinlayson29@weebly.com,Male,45.21.198.254,Zdounky,Czech Republic,+420-883-765-0356 83,Saw,Synder,ssynder2a@reddit.com,Male,35.205.142.137,Hoàn Kiếm,Vietnam,+84-158-237-0962 84,Falito,Avrasin,favrasin2b@is.gd,Male,90.162.22.20,Soasio,Indonesia,+62-975-753-9792 85,Codie,Stalley,cstalley2c@cloudflare.com,Female,112.56.233.104,Tafí del Valle,Argentina,+54-496-366-5285 86,Jess,Artinstall,jartinstall2d@google.de,Male,115.180.17.135,Sterlibashevo,Russia,+7-264-598-2801 87,Enrico,Habron,ehabron2e@rambler.ru,Male,221.161.117.41,Tiglauigan,Philippines,+63-642-828-3866 88,Wynny,Weepers,wweepers2f@blog.com,Female,97.235.38.95,Kogota,Japan,+81-109-169-6769 89,Decca,Picott,dpicott2g@unicef.org,Male,113.128.88.90,Marka,Somalia,+252-667-780-6135 90,Smith,Grieves,sgrieves2h@opera.com,Male,66.84.140.126,Domaradz,Poland,+48-586-136-4253 91,Friedrick,Fargie,ffargie2i@squarespace.com,Male,214.161.245.198,Prelog,Croatia,+385-665-216-9206 92,Jeni,Grover,jgrover2j@eepurl.com,Female,253.172.56.177,Inhambupe,Brazil,+55-572-321-1796 93,Shea,Zoellner,szoellner2k@gmpg.org,Female,245.13.15.4,Uppsala,Sweden,+46-471-443-7769 94,Kenton,Signori,ksignori2l@google.co.jp,Male,45.151.96.83,Velika Kladuša,Bosnia and Herzegovina,+387-202-494-3897 95,Donna,Wakley,dwakley2m@deliciousdays.com,Female,95.252.36.230,Bratislava,Slovakia,+421-943-157-4323 96,Ruthy,Tootal,rtootal2n@indiatimes.com,Female,142.41.103.32,Jiangning,China,+86-634-996-9618 97,Janella,Wyse,jwyse2o@opera.com,Female,130.130.70.95,Bat Khela,Pakistan,+92-964-274-4276 98,Latrena,de Werk,ldewerk2p@imgur.com,Female,39.100.170.248,Odolena Voda,Czech Republic,+420-809-561-7420 99,Sayer,Jouanny,sjouanny2q@theatlantic.com,Male,143.89.8.32,Usevia,Tanzania,+255-804-674-6057 100,Essie,MacAllister,emacallister2r@mediafire.com,Female,253.83.182.0,Zliten,Libya,+218-882-387-4522 101,Efrem,Goodinson,egoodinson2s@berkeley.edu,Male,153.227.107.46,Palopo,Indonesia,+62-481-978-1300 102,Sigismondo,Durtnall,sdurtnall2t@a8.net,Male,105.230.4.203,Lamatuka,Indonesia,+62-367-354-3581 103,Kanya,Orys,korys2u@goo.gl,Female,0.54.186.200,Veiga,Portugal,+351-452-909-7899 104,Sloane,Churly,schurly2v@canalblog.com,Male,86.235.66.247,Kamárai,Greece,+30-505-515-8796 105,Isac,Burgess,iburgess2w@ehow.com,Male,180.1.118.98,Lovisa,Finland,+358-825-100-0760 106,Verna,Jacson,vjacson2x@ucsd.edu,Female,135.247.48.160,Vlkoš,Czech Republic,+420-153-989-7240 107,Desiree,Serotsky,dserotsky2y@blogspot.com,Female,219.114.27.154,Vetlanda,Sweden,+46-627-224-5537 108,Neall,Carson,ncarson2z@1688.com,Male,216.119.38.132,Roma,Italy,+39-633-332-7735 109,Vanya,Vickress,vvickress30@samsung.com,Male,37.194.40.209,Yancheng,China,+86-145-587-0979 110,Sela,Starbeck,sstarbeck31@google.pl,Female,239.85.221.82,Shuangshi,China,+86-384-804-9905 111,Christian,Peevor,cpeevor32@ow.ly,Female,156.131.95.233,Hiratsuka,Japan,+81-670-328-0615 112,Emmy,Arrigucci,earrigucci33@gravatar.com,Male,157.204.125.109,Trmice,Czech Republic,+420-878-411-5028 113,Granthem,Itzhak,gitzhak34@w3.org,Male,166.34.229.207,Baima,China,+86-889-279-5526 114,Vivia,Carlill,vcarlill35@sbwire.com,Female,75.170.12.89,Wanghu,China,+86-118-640-3535 115,York,de Pinna,ydepinna36@noaa.gov,Male,217.64.221.209,Fengshuling,China,+86-613-418-1887 116,Rudy,Coushe,rcoushe37@themeforest.net,Male,195.104.176.30,Ash Shajarah,Syria,+963-279-699-3703 117,Petronilla,Pigford,ppigford38@squarespace.com,Female,196.75.69.17,Saint-Gratien,France,+33-585-116-8405 118,Willard,Bavister,wbavister39@amazonaws.com,Male,250.113.121.51,Placer,Philippines,+63-561-903-7007 119,Elset,Duncanson,eduncanson3a@theglobeandmail.com,Female,127.78.224.155,Puerto Esperanza,Argentina,+54-328-977-2855 120,Beitris,Schroeder,bschroeder3b@1und1.de,Female,240.35.38.129,Nová Role,Czech Republic,+420-283-650-1136 121,Brice,Wims,bwims3c@wunderground.com,Male,41.95.6.131,Panyingkiran,Indonesia,+62-184-958-8290 122,Emlynne,Teml,eteml3d@shinystat.com,Female,211.113.123.81,Erfurt,Germany,+49-638-466-5180 123,Ray,Hanscom,rhanscom3e@apple.com,Female,248.57.37.97,Tolitoli,Indonesia,+62-594-554-4242 124,Benedict,Morde,bmorde3f@google.com.hk,Male,192.129.251.173,Czarna Woda,Poland,+48-641-440-8079 125,Ignacio,Napthine,inapthine3g@statcounter.com,Male,46.106.65.245,Puerto Esperanza,Argentina,+54-657-562-0609 126,Chadd,Belfield,cbelfield3h@usa.gov,Male,148.142.94.164,Doumen,China,+86-157-537-6202 127,Sada,Havvock,shavvock3i@auda.org.au,Female,213.72.24.13,Boyeros,Cuba,+53-452-615-7083 128,Margaux,Halsey,mhalsey3j@zimbio.com,Female,129.35.227.81,Zhusha,China,+86-522-871-1032 129,Cordie,Moakson,cmoakson3k@github.com,Male,93.67.222.30,Bourail,New Caledonia,+687-108-798-3237 130,Boycey,Yegorchenkov,byegorchenkov3l@istockphoto.com,Male,194.182.4.65,Sorong,Indonesia,+62-885-269-5688 131,Chet,Wadman,cwadman3m@reverbnation.com,Male,88.13.99.216,Norsborg,Sweden,+46-966-137-1737 132,Alberik,Yelyashev,ayelyashev3n@vkontakte.ru,Male,148.198.73.33,Kaabong,Uganda,+256-824-713-7919 133,Glori,Cassam,gcassam3o@t.co,Female,124.65.25.213,Amio,Philippines,+63-447-529-7579 134,Val,Creaser,vcreaser3p@eventbrite.com,Female,219.249.106.176,Akbarābād,Iran,+98-347-847-4005 135,Zorine,Zarfati,zzarfati3q@zdnet.com,Female,199.72.117.146,Qinghu,China,+86-116-627-0397 136,Xena,Shaddock,xshaddock3r@imgur.com,Female,180.70.12.213,Tangkeng,China,+86-517-314-1002 137,Constantine,Pigrome,cpigrome3s@answers.com,Male,77.124.132.245,Peso da Régua,Portugal,+351-885-946-3878 138,Tyne,Phaup,tphaup3t@epa.gov,Female,96.156.32.208,Rambatan,Indonesia,+62-626-494-1260 139,Louie,Goodday,lgoodday3u@i2i.jp,Male,135.141.247.136,Anderstorp,Sweden,+46-970-638-4252 140,Jerad,Croot,jcroot3v@yandex.ru,Male,179.203.19.150,Mnich,Poland,+48-237-711-6162 141,Muire,Defau,mdefau3w@wix.com,Female,195.248.189.247,Khōshī,Afghanistan,+93-684-965-9589 142,Corenda,Paulusch,cpaulusch3x@ibm.com,Female,40.2.164.153,Aasiaat,Greenland,+299-638-273-5291 143,Leslie,Chave,lchave3y@weibo.com,Male,146.173.248.148,København,Denmark,+45-789-324-7956 144,Norry,Tyrer,ntyrer3z@cpanel.net,Female,96.138.246.245,La Garenne-Colombes,France,+33-208-848-7795 145,Jackson,Brikner,jbrikner40@icq.com,Male,83.215.178.129,Wurno,Nigeria,+234-816-564-0862 146,Barbi,Bellow,bbellow41@altervista.org,Female,250.233.251.183,Siepraw,Poland,+48-137-304-5776 147,Anallise,Gallier,agallier42@hexun.com,Female,67.26.76.159,Talun,Indonesia,+62-250-935-7285 148,Kate,Baxstar,kbaxstar43@latimes.com,Female,225.53.250.14,Poiares,Portugal,+351-610-409-5401 149,Merwyn,McGuggy,mmcguggy44@cbc.ca,Male,201.108.90.208,Trzemeszno,Poland,+48-983-414-0426 150,Berni,Purchase,bpurchase45@ucoz.ru,Female,86.220.246.212,Slatina,Croatia,+385-315-391-7691 151,Anya,Zucker,azucker46@netvibes.com,Female,7.80.95.142,Biecz,Poland,+48-729-733-7619 152,Donia,Trickett,dtrickett47@usa.gov,Female,25.151.108.83,Germiston,South Africa,+27-996-754-8761 153,Phyllys,Pendlington,ppendlington48@marketwatch.com,Female,107.194.108.35,Somié,Cameroon,+237-738-469-9038 154,Sebastien,Coghlin,scoghlin49@newyorker.com,Male,116.139.81.19,Minami-rinkan,Japan,+81-172-423-9841 155,Gordie,Kelling,gkelling4a@rambler.ru,Male,183.162.220.36,Yuelai,China,+86-796-464-2540 156,Tomasine,Itzik,titzik4b@ameblo.jp,Female,17.221.26.216,Wosai,China,+86-144-987-2164 157,Edward,Stockow,estockow4c@clickbank.net,Male,95.112.186.197,Baruta,Venezuela,+58-718-749-1636 158,Dara,Ianni,dianni4d@sina.com.cn,Female,97.216.36.133,Shunling,China,+86-412-204-6516 159,Clyde,Setford,csetford4e@globo.com,Male,191.121.45.150,Gaoqiao,China,+86-625-625-5198 160,Tynan,Faich,tfaich4f@usda.gov,Male,194.48.130.235,Las Flores,Mexico,+52-387-384-4328 161,Pancho,Malicki,pmalicki4g@utexas.edu,Male,107.176.143.122,Bayuin,Philippines,+63-119-397-4678 162,Alex,Yarnton,ayarnton4h@google.co.jp,Male,156.17.220.27,Vénissieux,France,+33-405-478-8099 163,Koral,Thorald,kthorald4i@comcast.net,Female,19.82.137.81,Tsiatsan,Armenia,+374-501-249-7822 164,Abner,Shacklady,ashacklady4j@godaddy.com,Male,251.130.217.70,Tancheng,China,+86-100-711-6012 165,Alanson,Van der Kruys,avanderkruys4k@techcrunch.com,Male,123.44.239.5,Krajan Puru,Indonesia,+62-332-895-3650 166,Noak,Tourne,ntourne4l@quantcast.com,Male,123.113.227.81,Kuhmalahti,Finland,+358-325-129-6774 167,Lexy,Beaglehole,lbeaglehole4m@vinaora.com,Female,172.250.143.139,Huangtang,China,+86-215-421-9016 168,Angelle,Elland,aelland4n@lulu.com,Female,31.120.230.177,San Pedro One,Philippines,+63-969-676-8408 169,Wain,O'Carmody,wocarmody4o@rakuten.co.jp,Male,6.149.107.31,Trollhättan,Sweden,+46-766-791-4342 170,Reube,Ruff,rruff4p@ameblo.jp,Male,227.25.193.202,Banjar Pasekan,Indonesia,+62-611-847-0878 171,Lyndsie,Moreby,lmoreby4q@oracle.com,Female,241.233.222.174,Dalmacio Vélez Sársfield,Argentina,+54-891-404-3315 172,Avrom,Kivlehan,akivlehan4r@toplist.cz,Male,236.238.74.132,Kamennogorsk,Russia,+7-490-143-5183 173,Ric,Shevell,rshevell4s@netvibes.com,Male,157.23.9.101,Melipilla,Chile,+56-629-600-5628 174,Langsdon,Tomasz,ltomasz4t@un.org,Male,178.251.33.5,Sigaboy,Philippines,+63-133-405-8084 175,Wrennie,Dagger,wdagger4u@state.tx.us,Female,219.167.203.216,Strawczyn,Poland,+48-842-794-6464 176,Jory,Goodere,jgoodere4v@blogtalkradio.com,Male,97.198.28.75,Thành Phố Hà Giang,Vietnam,+84-860-324-4227 177,Moishe,de Grey,mdegrey4w@mashable.com,Male,156.64.21.60,Haikou,China,+86-337-692-6244 178,Chicky,Davenell,cdavenell4x@digg.com,Male,56.67.56.223,Butel,Macedonia,+389-222-646-9456 179,Howie,Melia,hmelia4y@myspace.com,Male,97.119.218.18,Añatuya,Argentina,+54-797-559-0961 180,Cirilo,Fairhall,cfairhall4z@engadget.com,Male,56.92.54.158,Xiaomenjia,China,+86-857-935-6107 181,Taddeusz,Clarkin,tclarkin50@loc.gov,Male,69.110.33.8,Huaraz,Peru,+51-209-537-7254 182,Mackenzie,Peto,mpeto51@liveinternet.ru,Male,68.115.11.130,Shchelkovo,Russia,+7-100-585-9426 183,Lainey,D'Alessandro,ldalessandro52@cafepress.com,Female,253.232.241.110,Tha Bo,Thailand,+66-851-665-7838 184,Eugene,Borgnol,eborgnol53@arizona.edu,Male,80.92.249.161,El Kef,Tunisia,+216-570-599-0766 185,Roseline,Penzer,rpenzer54@slideshare.net,Female,119.52.45.72,Vila Nova,Portugal,+351-803-589-8238 186,Bekki,Jankiewicz,bjankiewicz55@a8.net,Female,146.154.143.5,Vreshtas,Albania,+355-165-623-0764 187,Perry,Korous,pkorous56@narod.ru,Male,103.8.122.178,Batuna Satu,Indonesia,+62-745-157-2883 188,Husein,Fursey,hfursey57@redcross.org,Male,195.36.168.102,Shazhenxi,China,+86-606-696-5162 189,Florette,Coldham,fcoldham58@storify.com,Female,67.66.185.145,Níkaia,Greece,+30-726-671-7761 190,Linc,Jerok,ljerok59@chicagotribune.com,Male,238.154.189.232,Kaznějov,Czech Republic,+420-411-234-0432 191,Ki,Flockhart,kflockhart5a@studiopress.com,Female,77.225.249.208,Tindog,Philippines,+63-288-882-7996 192,Lanni,Tufts,ltufts5b@sbwire.com,Female,245.99.46.208,Lazaro Cardenas,Mexico,+52-979-122-5969 193,Birdie,Hadlow,bhadlow5c@so-net.ne.jp,Female,58.207.57.72,Raub,Malaysia,+60-848-662-2414 194,Del,Kurdani,dkurdani5d@washington.edu,Male,19.227.168.34,Tawangrejo,Indonesia,+62-953-968-1186 195,Lezley,O'Connolly,loconnolly5e@hc360.com,Male,140.243.58.158,Paarl,South Africa,+27-594-540-1273 196,Irwin,Gravener,igravener5f@deviantart.com,Male,204.117.23.80,Jiuhua,China,+86-110-966-0382 197,Matthew,Toffel,mtoffel5g@opera.com,Male,150.140.59.206,Guayabal,Colombia,+57-988-952-3927 198,Nelle,Cromar,ncromar5h@geocities.com,Female,81.77.142.99,Isdalstø,Norway,+47-436-169-0258 199,Chandler,Didball,cdidball5i@mapy.cz,Male,16.64.110.155,Antony,France,+33-853-425-4253 200,Morgan,Cottu,mcottu5j@blogspot.com,Male,79.41.191.214,Bukomansimbi,Uganda,+256-964-259-1823 201,John,Fisher,mrjohnf@yahoo.com,Male,69.69.69.69,Keswick,UK,+44-1923-453132