CSV, noma lapho ukubeka ukhefana?

Phakathi izicelo, wabhekana uma hhayi Unicode, isivele umsebenzisi ethuthukisiwe, idatha yokungenisa komunye isicelo kwenye ingekho kakhulu kuyaqabukela. Ngokuvamile kubalulekile ukungenisa idatha yethebula, okuyilokho, eqinisweni, livele CSV. Ubani athuthukile izixazululo okunye eziningana (umholi we-XML phakathi kwabo). Kodwa ukudalwa ifayela le-CSV, futhi kwezinye izimo, kuba ikhambi elilula kakhulu, futhi abanye - oyinkinga kakhulu.

It imelela igama format njengoba commaseparatedvalues - amagugu oluhlukaniswe. Ngo ifayela incwajana kanje:

00, 01, 02, 03;

01, 15, 34, 11;

16, 27, 33, 06 (ekupheleni uphawu wafaka kungadingeki)

Futhi i-Excel isipredishithi noma efanayo isicelo kakade ngakho:

Kodwa manje saxoxa kunjalo elula. Izinkinga uqale nje ngenxa yokuthi ngenxa ecindezeleke kakhulu yokubika idatha, CSV isetshenziswa ukuze uthumele esiningi ulwazi. Ngokuvamile atholakala yolwazi yamanani ahlukahlukene: ezinombolo, i-alpha, nezinombolo, kunezikhala, njll Ngokuvamile kumalungu afanayo okukhulu amaphutha, futhi uma, isibonelo, endaweni ethile kuyoba yinto ukhefana owengeziwe kule okuqukethwe omunye emasimini, wonke amaseli kungenziwa dengwane ngomunye.

Ngokuvamile, kuphakama izinkinga lapho idatha amazwe nge ngefomethi yefayela le-CSV, kungenziwa ihlukaniswe izigaba ezintathu:

1 - engalungile ukugcwaliswa Amasimu.

2 - engalungile idatha ukuguqulwa lapho nokulonda CSV.

3 - ukuqashelwa engalungile Uhlelo format ongenisa.

Icala lokuqala siye kancane wahlola. Ukuze kulwiwe nale nkinga, kufanele uhlinzeke indlela ukuqapha ngokunemba we idatha efakiwe. Isibonelo, uma udinga ukuqoqa database lamakheli uhlu lwamakheli, kukhona izikripthi ekhethekile ukuqinisekisa ukuthi ngabe umuntu engena e-mail isakhiwo. Lapho kukhona khona izikhala, bokhefana, kanye nanoma yimiphi eminye idatha ingafundwa okungalungile, okuqukethwe ensimini kufanele sibhalwe ebiyelwe bokhulunyiwe (okuthiwa computer "").

Icala lesibili ixhunyiwe kukhethwa wekhodi. Udinga ukuthola ngokuvamile ababhekana nazo yini wekhodi ukhetha ukungenisa hlelo. Ngo-Windows evame ukusetshenziswa 1251, ngakho-ke uma ifayela lokuqala uzohlangana umbhalo Unicode, ukulilandela izoboniswa isicelo uya khona njengoba uchungechunge imibuzo. Ku-Excel, ungagcina ngefomethi ye-CSV ne lokufaka ikhodi ezahlukene kanye idilimitha (ngaphandle iphuzu lisasebenza ithebhu, futhi isemikholoni), kodwa kungcono ukwakha ifayela incwajana ++ noma OpenOfficeCalc.

Icala lesithathu - phetho yesibili. Ngokomlando, ifomethi ye-CSV ayinayo ejwayelekile olulodwa. Izinhlelo eziningi ziqondakala njengoba CSV ne ifayela TSV (ithebhu-delimited) kanye SCSV (ahlukaniswe amakhefanangqi), ikakhulukazi ngoba isandiso fayela angabikwa ngakho. Kulesi simo, idatha ukufunda ngokungalungile futhi kungukuthi labelwe phakathi amaseli zilandelane. Into engcono singa ukweluleka - ukudala ifayela CSV mathupha. Njengoba sekushiwo, idinga ukusizakala umhleli elula.

Tricks indlela yokulawula ifomethi CSV, program ezaziwayo. umsebenzisi Simple kudingeka banamathele izincomo zethu ngokudala ifayela. Kulazo zonke izinkinga kwenzeka uma ifayela badalelwa ukuze ukungenisa lokusebenza oluthile (futhi ngezinye izikhathi ngendlela ehlukile). Kulula ikhumbule zonke izinkinga kungenzeka nazo idatha.