Vula ifomethi ye-CSV

I-CSV (I-Comma-Separated Value) ifayela lefomethi yombhalo eklanyelwe ukubonisa idatha ye-tabular. Kulokhu, amakholomu ahlukaniswa yikhefana ne-semicolon. Thola ukuthi yiziphi izinhlelo ongavula ngazo le fomethi.

Izinhlelo zokusebenza nge-CSV

Njengomthetho, ama-processor etafula asetshenziselwa ukubuka kahle okuqukethwe kwe-CSV, futhi abahleli bemibhalo nabo bangasetshenziswa ukuhlela. Ake sibheke kabanzi i-algorithm yezenzo lapho izinhlelo ezahlukahlukene zivula lolu hlobo lwefayela.

Indlela yoku-1: Microsoft Excel

Ake sibheke ukuthi ingasebenza kanjani i-CSV kwinqubo eyaziwayo yamagama i-Excel, efakiwe kwi-Microsoft Office suite.

1. Qalisa i-Excel. Iya kuthebhu Ifayela.



2. Ukuya kule thebhu, chofoza "Vula".

   

   Esikhundleni salezi zenzo, ungasebenza ngokuqondile eshidini I-Ctrl + O.

3. Kuvele iwindi "Kuvulwa idokhumenti". Yisebenzise ukuzulazula lapho i-CSV itholakala khona. Qiniseka ukuthi ukhetha ohlwini lwamafomethi Amafayela Wombhalo noma "Wonke amafayela". Ngaphandle kwalokho, ifomethi efiselekayo ngeke nje iboniswe. Bese umaka into enikeziwe bese ucindezela "Vula"lokho kuzodala "Ingcweti yemibhalo".

Kukhona enye indlela ongaya kuyo "Ingcweti yemibhalo".

1. Hambisa esigabeni "Idatha". Chofoza entweni "Okusuka embhalweni"ibekwe block "Ukuthola imininingwane yangaphandle".



2. Kuvela ithuluzi Ngenisa Ifayela Lombhalo. Kuyafana nasewindini "Kuvulwa idokhumenti", lapha udinga ukuya endaweni yendawo yento bese uyimaka. Awudingi ukukhetha amafomethi, ngoba uma usebenzisa leli thuluzi, izinto eziqukethe umbhalo zizokhonjiswa. Qhafaza "Ngenisa".



3. Kuqala "Ingcweti yemibhalo". Ewindini lakhe lokuqala "Cacisa ifomethi yedatha" setha inkinobho yomsakazo ku- Ihlukaniswe. Endaweni "Ifomethi yefayela" kumele kube yipharamitha I-Unicode (UTF-8). Cindezela "Okulandelayo".



4. Manje kuyadingeka ukwenza isinyathelo esibaluleke kakhulu, lapho ukunemba kokukhonjiswa kwedatha kuzoncika khona. Kuyadingeka ukukhombisa ukuthi yini ngempela ethathwa njengesihlukanisi: i-semicolon (;) noma ikhefana (,). Iqiniso ngukuthi emazweni ahlukene kusetshenziswa amazinga ahlukene kulokhu. Ngakho-ke, emibhalweni yesiNgisi, ikhefana livame ukusetshenziswa, futhi emibhalweni yolimi lwaseRussia, i-semicolon. Kepha kukhona okuhlukile lapho izihlukanisi zisetshenziselwa ukuhlanekezela. Ngaphezu kwalokho, ezimweni ezingandile kakhulu, ezinye izinhlamvu zisetshenziselwa njengabambisi, njengolayini we-wavy (~).

   Ngakho-ke, umsebenzisi kufanele anqume ukuthi kuleli cala umlingisi othile ungumqili noma uphawu lokuloba ejwayelekile. Lokhu angakwenza ngokubheka umbhalo obonakala endaweni. "Ukuqanjwa kwemininingwane yesampula" futhi kususelwa kunengqondo.

   

   Ngemuva kokuba umsebenzisi enqume ukuthi yimuphi umhlukanisi eqenjini "Umlingisi owahlukile" hlola ibhokisi eliseduze I-Semicolon noma Ukhefana. Amabhokisi wokuhlola kufanele asuswe kuzo zonke ezinye izinto. Bese uqhafaza "Okulandelayo".



5. Ngemuva kwalokho, kuvulwa iwindi lapho, kuqokomisa ikholamu ethile endaweni "Ukuqanjwa kwemininingwane yesampula", ungayinikeza ifomethi yokuboniswa okuyilona kolwazi kwibhulokhi Indlela Yedatha Yekholomu ngokushintsha izinkinobho zomsakazo phakathi kwalezi zikhundla ezilandelayo:
   • weqa ikholamu;
   • umbhalo
   • Usuku
   • ejwayelekile.

   Ngemuva kokuqeda ukukhohlisa, cindezela Kwenziwe.



6. Iwindi livela libuze ukuthi imiphi imininingwane okufanele ingeniswe isendaweni. Ngokushintsha izinkinobho zomsakazo, ungakwenza lokhu eshidini elisha noma elikhona. Endabeni yokugcina, futhi ungacacisa ngokuqondile indawo izixhumanisi zensimu ehambelana nayo. Ukuze ungazifaki ngesandla, kwanele ukubeka ikhesa kule nkambu bese ukhetha iseli eshidini elizoba yinto ephezulu kwesokunxele yohlu lapho imininingwane izongezwa. Ngemuva kokusetha izixhumanisi, chofoza "Kulungile".



7. Okuqukethwe kwento kukhonjiswa ekhasini le-Excel.

Isifundo: Ungayisebenzisa kanjani iCSV e-Excel

Indlela 2: I-LibreOffice Calc

Enye iprosesa lethebula lingasebenza i-CSV - iCalc, okuyingxenye yomhlangano weLibreOffice.

1. Qalisa i-LibreOffice. Qhafaza "Vula ifayela" noma sebenzisa I-Ctrl + O.

   

   Ungahamba futhi ngemenyu ngokucindezela Ifayela futhi "Vula ...".

   

   Ngaphezu kwalokho, iwindi lokuvula lingatholakala futhi ngokuqondile ngokusebenzisa i-calc interface. Ukuze wenze lokhu, ngenkathi use-LibreOffice Calc, chofoza isithonjana sefolda noma thayipha I-Ctrl + O.

   

   Enye inketho ifaka ukuguqulwa okulandelanayo ngamaphuzu Ifayela futhi "Vula ...".



2. Usebenzisa noma ikuphi ukukhetha okuningi okusohlwini kuzoholela ewindini "Vula". Ihambise endaweni ye-CSV, imake bese ucindezela "Vula".

   

   Kepha ungakwenza ngaphandle kokusebenzisa iwindi "Vula". Ukuze wenze lokhu, donsa i-CSV "Isihloli" ku-LibreOffice.



3. Kuvela ithuluzi Ngenisa Umbhalokokuba yi-analog "Ama-Masters Wombhalo" e-Excel. Inzuzo ukuthi kuleli cala akudingeki uhambe phakathi kwamafasitela ahlukile, wenze izilungiselelo zokungenisa, ngoba wonke amapharamitha adingekayo abekwe efasiteleni elilodwa.

   Iya ngqo eqenjini lezilungiselelo "Ngenisa". Endaweni "Ukufaka ikhodi" khetha inani I-Unicode (UTF-8)uma kuboniswe ngenye indlela lapho. Endaweni "Ulimi" khetha ulimi lombhalo. Endaweni "Kusuka emugqeni" udinga ukucacisa ukuthi yimuphi umugqa okufanele uqale ukungenisa okuqukethwe. Ezimweni eziningi, le parcela ayidingi ukushintshwa.

   Okulandelayo, iya eqenjini Izinketho zehlukanisi. Okokuqala, udinga ukusetha inkinobho yomsakazo ukuze Isihlukanisi. Ngaphezu kwalokho, ngokuya ngomgomo ofanayo owathathwa ngenkathi usebenzisa i-Excel, udinga ukucacisa, ngokubheka ibhokisi eliseduze kwento ethize, ukuthi yini ngempela edlala indima yomhlukanisi: i-semicolon noma ikhefana.

   "Ezinye izinketho" shiya kungashintshiwe.

   Ungabona kusengaphambili ukuthi lunjani lolo lwazi olungenisiwe uma lushintsha izilungiselelo ezithile, phansi kwewindi. Ngemuva kokufaka wonke amapharamitha adingekayo, cindezela "Kulungile".



4. Okuqukethwe kuzokhonjiswa ngesixhumanisi se-LibreOffice Kalk.

Indlela 3: I-OpenOffice Calc

Ungabuka i-CSV usebenzisa enye iprosesa yetafula - i-OpenOffice Calc.

1. Qalisa i-OpenOffice. Ewindini elikhulu, chofoza "Vula ..." noma sebenzisa I-Ctrl + O.

   

   Ungasebenzisa futhi imenyu. Ukuze wenze lokhu, dlula ezintweni Ifayela futhi "Vula ...".

   

   Njengendlela nohlelo lwangaphambilini, ungangena efasiteleni elivula into ngokuqondile ngokusebenzisa isixhumanisi se-Kalk. Kulokhu, udinga chofoza isithonjana esithombeni sefolda noma usebenzise okufanayo I-Ctrl + O.

   

   Ungasebenzisa futhi imenyu ngokuya ezikhundleni ezikuyo. Ifayela futhi "Vula ...".



2. Ewindini elivulayo elivelayo, iya endaweni ye-CSV, khetha le nto bese uqhafaza "Vula".

   

   Ungakwenza ngaphandle kokuqalisa le windi ngokumane udonsele i-CSV kusuka "Isihloli" ku-OpenOffice.



3. Noma yiziphi izenzo eziningi ezichazwe zizoholela ekuqalisweni kwewindi. Ngenisa Umbhalo, okufanayo kakhulu ngokubukeka nasekusebenzeni kwensimbi enegama elifanayo kuLibreOffice. Ngokuvumelana nalokho, yenza isenzo esifanayo. Emasimini "Ukufaka ikhodi" futhi "Ulimi" veza I-Unicode (UTF-8) nolimi lwedokhumenti yamanje, ngokulandelana.

   Ebhlokini Ipharamitha Ehlukanisayo faka inkinobho yomsakazo eduze kwento Isihlukanisi, bese ubheka ibhokisi eliseduzane (I-Semicolon noma Ukhefana) olufana nohlobo lokwahlukanisa kudokhumenti.

   Ngemuva kokwenza lezi zinyathelo, uma idatha esefomini lokuhlola kuqala iboniswa ngezansi kwewindows iboniswa kahle, chofoza "Kulungile".



4. Idatha izokhonjiswa ngempumelelo kusixhumi esibonakalayo se-OpenOffice Kalk.

Indlela 4: Incwajana

Ukuhlela, ungasebenzisa i-Notepad ejwayelekile.

1. Hola incwajana. Kumenyu, chofoza Ifayela futhi "Vula ...". Noma ungafaka isicelo I-Ctrl + O.



2. Kuvele iwindi lokuvula. Iya kuyo endaweni yendawo ye-CSV. Ensimini yokubonisa ifomethi, setha inani "Wonke amafayela". Faka uphawu entweni oyifunayo. Bese ucindezela "Vula".



3. Into izovulwa, kepha-ke, hhayi ngendlela yethebhulethi esiyigcinile kuma processor etafuleni, kodwa embhalweni wokuqala. Noma kunjalo, kubhukwana elinemibhalo elula kakhulu ukuhlela izinto zale fomethi. Udinga nje ukunaka nje ukuthi umugqa ngamunye wethebula uhambelana nomugqa wombhalo ku-Notepad, futhi amakholomu ahlukaniswa abahlukanisi ngesimo samakhoma noma ama-semicolons. Ngokunikwa lolu lwazi, ungenza kalula noma iziphi izilungiso kimi, amanani wombhalo, ukungeza imigqa, ukususa noma ukungeza izihlukanisi lapho kunesidingo.

Indlela 5: Incwajana ++

Ungayivula ngesihleli sombhalo esithuthukile - i-Notepad ++.

1. Vula i-Notepad ++. Chofoza kumenyu Ifayela. Khetha okulandelayo "Vula ...". Ungafaka futhi isicelo I-Ctrl + O.

   

   Enye inketho ifaka chofoza isithonjana sephaneli ngendlela kwifolda.



2. Kuvele iwindi lokuvula. Kuyadingeka ukuthuthela endaweni yohlelo lwefayela lapho kutholakala khona i-CSV. Ngemuva kokukhetha, cindezela "Vula".



3. Okuqukethwe kuzobonakala ku-Notepad ++. Imigomo yokuhlela iyafana nalapho usebenzisa i-Notepad, kepha i-Notepad ++ ihlinzeka ngamanani amathuluzi amaningi wokuqanjwa kwemininingwane okuhlukahlukene.

Indlela 6: Safari

Ungakubuka okuqukethwe oku nguqulo yombhalo ngaphandle kokukuhlehlisa ku-Safari browser. Ezinye iziphequluli eziningi ezithandwayo azihlinzeki ngalesi sici.

1. Hola i-Safari. Qhafaza Ifayela. Qhafaza ngokulandelayo "Vula ifayela ...".



2. Kuvele iwindi lokuvula. Kudinga ukuhambisa endaweni lapho i-CSV ikhona, umsebenzisi afuna ukuyibuka. Ukushintshwa kwesakhiwo okuphoqelekile efasiteleni kufanele kusethelwe kulo "Wonke amafayela". Bese ukhetha into ngesandiso se-CSV bese uqhafaza "Vula".



3. Okuqukethwe kwale nto kuzovula ewindini elisha leSafari ngombhalo, njengoba bekunjalo ngeNotepad. Kuliqiniso, ngokungafani ne-Notepad, ukuhlela idatha ku-Safari, ngeshwa, ngeke kusebenze, ngoba ungayibuka kuphela.

Indlela yesi-7: I-Microsoft Outlook

Ezinye izinto ze-CSV ama-imeyili athunyelwa kusuka kuklayenti lwe-imeyili. Zingabukwa kusetshenziswa uhlelo lweMicrosoft Outlook ngokwenza inqubo yokungenisa.

1. Qalisa ukubuka. Ngemuva kokuvula uhlelo, iya kuthebhu Ifayela. Bese uqhafaza "Vula" kumenyu eseceleni. Qhafaza ngokulandelayo "Ngenisa".



2. Kuqala "Ngenisa futhi Uthekise Iwizadi". Kuluhlu olwethuliwe, khetha "Ngenisa kusuka kolunye uhlelo noma ifayela". Cindezela "Okulandelayo".



3. Ewindini elilandelayo, khetha uhlobo lwento oyongenisa. Uma sizongenisa i-CSV, kuzofanela ukhethe isikhundla "Amanani Ahlukaniswe Khefana (iWindows)". Qhafaza "Okulandelayo".



4. Ewindini elilandelayo, chofoza "Buyekeza ...".



5. Kuvele iwindi "Ukubuka konke". Kufanele iye endaweni lapho incwadi ikwifomethi ye-CSV. Faka ilebula le nto bese uqhafaza "Kulungile".



6. Kukhona ukubuyela ewindini "Ngenisa futhi Uthekise Wizadi". Njengoba ubona, endaweni "Ifayela lokungenisa" Kungezwe ikheli endaweni yento ye-CSV. Ebhlokini "Izinketho" izilungiselelo zingashiywa njengezenzakalelayo. Qhafaza "Okulandelayo".



7. Ngemuva kwalokho udinga ukumaka ifolda ebhokisini leposi lapho ufuna ukubeka khona izincwadi ezingenisiwe.



8. Iwindi elilandelayo libonisa igama lesenzo esizokwenziwa ngohlelo. Qhafaza lapha Kwenziwe.



9. Ngemuva kwalokho, ukubuka idatha engenisiwe, iya kuthebhu "Ukuthumela nokwamukela". Endaweni eseceleni yoxhumano lohlelo, khetha ifolda lapho umyalezo ungeniswe khona. Ngemuva kwengxenye yohlelo kuzovela uhlu lwezinhlamvu ezikule folda. Kwanele chofoza kabili kunhlamvu olufunayo ngenkinobho yegundane kwesokunxele.



10. Incwadi engenisiwe evela kwinto ye-CSV izovulwa kuhlelo lwe-Outlook.

Kuliqiniso, kuhle ukuqaphela ukuthi ngale ndlela ungagijima kude kuzo zonke izinto zefomethi ye-CSV, kepha izinhlamvu kuphela ezinesakhiwo esihlangabezana nezinga elithile, eliqukethe izinkambu: isihloko, umbhalo, ikheli lomthumeli, ikheli labamukeli, njll.

Njengoba ukwazi ukubona, kunezinhlelo ezimbalwa zokuvula izinto zefomethi ye-CSV. Njengomthetho, kungcono ukubuka okuqukethwe kwamafayela anjalo kuzinjiniyela zethebula. Ukuhlela kungenziwa njengombhalo kubahleli bemibhalo. Ngaphezu kwalokho, kunama-CSV ahlukile anesakhiwo esithile, lapho kusebenza khona izinhlelo ezikhethekile, isibonelo, amaklayenti we-imeyili.