I-CSV (Ama-Values ​​Ahlukaniswe Ngama-Comma) iyifayela lombhalo elenzelwe ukubonisa idatha yamathebhu. Kulesi simo, amakholomu ahlukaniswa ngomahlaya kanye ne-semicolon. Sifunda, ngosizo lwama-applications ongavula le fomethi.
Izinhlelo zokusebenza nge-CSV
Njengomthetho, abacubungula be-tabular basetshenziselwa ukubuka okuqukethwe kwe-CSV ngendlela efanele, futhi abahleli bombhalo bangasetshenziswa ukuwahlela. Ake sihlolisise i-algorithm yezenzo uma sivula izinhlelo ezihlukahlukene zale fayili yefayela.
Indlela 1: Microsoft Excel
Cabanga ukuthi ungasebenzisa kanjani i-CSV ku-procel yegama elidumile leprosesa, elifakiwe ku-Microsoft Office suite.
- Run Excel. Chofoza ithebhu "Ifayela".
- Yiya kulethebhu, chofoza "Vula".
Esikhundleni salezi zenzo, ungafaka ngokuqondile kushidi. Ctrl + O.
- Iwindi livela "Idokhumenti yokuvula". Sebenzisa ukuze uhambise lapho i-CSV itholakala khona. Qinisekisa ukuthi ukhetha ohlwini lwamanani amafomethi "Amafayela Umbhalo" noma "Wonke Amafayela". Ngaphandle kwalokho, ifomethi oyifunayo ayiboniswa nje. Bese ubhala le nto bese ucindezela "Vula"lokho kuzobangela "Umbhalo Omkhulu".
Kukhona enye indlela ongaya kuyo "Umbhalo Omkhulu".
- Hambisa kusigaba "Idatha". Chofoza ku-into "Kusukela embhalweni"efakwe ebhodini "Ukuthola Idatha Yangaphandle".
- Ithuluzi livela "Ngenisa Ifayela Lombhalo". Njengasefestile "Idokhumenti yokuvula", lapha udinga ukuya endaweni yento bese uyibeka uphawu. Asikho isidingo sokukhetha amafomethi, kusukela lapho usebenzisa leli thuluzi, izinto eziqukethe umbhalo zizobonakala. Chofoza "Ngenisa".
- Iqala "Umbhalo Omkhulu". Ewindini lakhe lokuqala "Cacisa ifomethi yedatha" faka inkinobho yomsakazo esikhundleni "Unlimited". Endaweni "Ifomethi yefayela" kufanele kube nepharamitha "Unicode (UTF-8)". Cindezela phansi "Okulandelayo".
- Manje udinga ukwenza isinyathelo esibaluleke kakhulu, esizokwenza ukuthi ukuboniswa kwedatha kulungile. Kudingeka ukuthi ucacise lokho okubhekwa njengokuhlukanisa: i-semicolon (;) noma i-comma (,). Iqiniso liwukuthi emazweni ahlukene kulolu hlelo kusetshenziswa amazinga ahlukene. Ngakho-ke, i-comma ivame ukusetshenziswa kakhulu emibhalweni yesiNgisi, futhi i-semicolon isetshenziselwa imibhalo yesiRussia. Kodwa kukhona okungafani lapho ama-delimiters asetshenziswa ngenye indlela. Ngaphezu kwalokho, ezimweni ezingavamile kakhulu, ezinye izimpawu zisetshenziswa njengabahlukanisi, isibonelo, umzila we-wavy (~).
Ngakho-ke, umsebenzisi ngokwakhe kufanele amise ukuthi kulesi simo umlingisi othize ukhonza njengenhlawulo noma i-punctuation evamile. Angakwenza lokhu ngokubuka umbhalo okhonjisiwe ku "Idatha yokupakisha yesampula" futhi ngokusekelwe kwimiqondo.
Ngemuva kokuthi umsebenzisi anquma ukuthi yiliphi uhlamvu ohlukanisayo, eqenjini "Umlingiswa we-delimiter" hlola ibhokisi eliseduze "Semicolon" noma "Comma". Zonke ezinye izinto akufanele zihlolwe. Bese ucindezela "Okulandelayo".
- Ngemuva kwalokho iwindi livuleka lapho, ngokukhetha ikholomu ethile endaweni "Idatha yokupakisha yesampula", ungawabela ifomethi yokwaziswa okuqondile kolwazi "Ifomethi Yedatha Yekholomu" ngokushintsha inkinobho yomsakazo phakathi kwezikhundla ezilandelayo:
- yeqa ikholomu;
- umbhalo;
- usuku;
- evamile
Ngemuva kokusebenzisa ukuxhaphaza, cindezela "Yenzelwe".
- Iwindi libonakala libuza ukuthi impela idatha engenisiwe kufanele ifakwe eshadini. Ngokushintsha izinkinobho zomsakazo, ungakwenza lokhu eshidi elisha noma elikhona. Esikhathini esilandelayo, ungabuye ucacise izixhumanisi eziqondile zendawo ensimini ehambelana nayo. Ukuze ungangeni kuwo ngesandla, kwanele ukubeka isikhombisi kule nsimu, bese ukhetha eshadini iseli elizoba yingxenye ephezulu kwesokunxele lapho i-data izofakwa khona. Ngemuva kokuhlela izixhumanisi, cindezela "Kulungile".
- Okuqukethwe kwento kuboniswa ku-Excel sheet.
Isifundo: Indlela yokusebenzisa i-CSV ku-Excel
Indlela 2: I-LibreOffice Calc
I-CSV ingaphinde isebenze enye inqubo ye-table, i-Calc, efakiwe emhlanganweni we-LibreOffice.
- Qalisa i-FreeOffice. Chofoza "Vula Ifayela" noma sebenzisa Ctrl + O.
Ungakwazi futhi ukuhamba ngokusebenzisa imenyu ngokucindezela "Ifayela" futhi "Vula ...".
Ngaphezu kwalokho, iwindi lokuvula lingatholakala ngokuqondile nge-interface ye-Calc. Ukuze wenze lokhu, ngenkathi ku-LibreOffice Calc, chofoza isithonjana njengololwazi noma uhlobo Ctrl + O.
Enye indlela ukuhamba ngamaphuzu "Ifayela" futhi "Vula ...".
- Ukusebenzisa noma yikuphi okukhethwa kukho ohlwini kuzoholela efasiteleni "Vula". Yithuthela endaweni ye-CSV, uyibeke bese uyiqhafaza "Vula".
Kodwa ungenza ngisho ngaphandle kokusebenzisa iwindi "Vula". Ukwenza lokhu, donsela i-CSV kusuka "Explorer" e-LibreOffice.
- Ithuluzi livela "Ngenisa umbhalo"be-analog Amasevisi wombhalo ku-Excel. Inzuzo ukuthi kulokhu akudingekile ukuba uhambisane phakathi kwamawindi ahlukene, ukwenza izilungiselelo zokungenisa, ngoba yonke imingcele edingekayo itholakala ewindini elilodwa.
Iya ngqo eqenjini lezilungiselelo "Ngenisa". Endaweni "Ukubhala ngekhodi" khetha inani "Unicode (UTF-8)"uma kubonisa ngenye indlela. Endaweni "Ulimi" khetha ulimi lolimi. Endaweni "Kusukela emgqeni" udinga ukucacisa ukuthi yiliphi umugqa ozoqala ukungenisa okuqukethwe. Ezimweni eziningi, akudingeki wenze ushintsho kule parameter.
Okulandelayo, iya eqenjini "Izinketho zokwahlukana". Okokuqala, udinga ukusetha inkinobho yomsakazo endaweni "Umhlukanisi". Ngaphezu kwalokho, ngokuvumelana nomgomo ofanayo owacatshangwa uma usebenzisa i-Excel, udinga ukucacisa ngokuhlola ibhokisi lokuhlola phambi kwento ethize ukuthi yini eyodlala indima yokuhlukanisa: i-semicolon noma i-comma.
"Okunye okukhethwa kukho" shiya ingashintshi.
Ungabona kusengaphambili ukuthi ulwazi olufakiwe lubukeka kanjani uma ushintsha izilungiselelo ezithile ezansi kwewindi. Ngemva kokufaka yonke imingcele edingekayo, cindezela "Kulungile".
- Okuqukethwe kuzoboniswa nge-interface ye-LibreOffice Calc.
Indlela 3: I-OpenOffice Calc
Ungabuka i-CSV usebenzisa enye inqubo yephebula - I-OpenOffice Calc.
- Sebenzisa i-OpenOffice. Ewindini elikhulu, chofoza "Vula ..." noma sebenzisa Ctrl + O.
Ungasebenzisa futhi imenyu. Ukuze wenze lokhu, hamba amaphuzu "Ifayela" futhi "Vula ...".
Njengawo ndlela ngehlelo langaphambilini, ungathola ewindini lokuvula into ngqo ngokusebenzisa i-Kalk interface. Kulesi simo, udinga ukuchofoza esithombeni ngesithombe sefolda noma usebenzise okufanayo Ctrl + O.
Ungasebenzisa futhi imenyu ngokuhamba ngokusebenzisa izinto. "Ifayela" futhi "Vula ...".
- Ewindini lokuvulwa elivela, iya endaweni ye-CSV yokubekwa, khetha le nto bese uchofoza "Vula".
Ungenza ngaphandle kokusungula leli windi ngokumdonsa i-CSV kusuka "Explorer" ku-OpenOffice.
- Noma yikuphi kwezenzo eziningi ezichazwe kuzokwenza kusebenze iwindi. "Ngenisa umbhalo"okuyinto efana kakhulu kokubili ekubukeni nasekusebenzeni ithuluzi enegama elifanayo ku-FreeOffice. Ngakho-ke, izenzo zifana ncamashi. Emasimini "Ukubhala ngekhodi" futhi "Ulimi" ukuveza "Unicode (UTF-8)" futhi ulimi lomqulu wamanje ngokulandelana.
Ku-block "I-Parameters Yokuhlukanisa" faka inkinobho yomsakazo eduze kwento "Umhlukanisi", bese uhlola ibhokisi leyo nto ("Semicolon" noma "Comma"), okuhambisana nohlobo lokumisa emgqulwini.
Emva kokwenza izenzo ezibonisiwe, uma idatha efomini lokubuka kuqala eboniswe engxenyeni engezansi yewindi iboniswa ngendlela efanele, chofoza "Kulungile".
- Idatha izoboniswa ngempumelelo nge-OpenOffice Calc interface.
Indlela 4: Inothi
Ukuze uhlele, ungasebenzisa i-Notepad evamile.
- Qala i-Notepad. Chofoza kwimenyu "Ifayela" futhi "Vula ...". Noma ungafaka isicelo Ctrl + O.
- Iwindi yokuvula ivela. Zulazula endaweni yendawo ye-CSV. Esikhathini sendawo yokubonisa ifomethi, setha inani "Wonke Amafayela". Maka into oyifunayo. Bese ucindezela "Vula".
- Into izovuleka, kodwa, akusikho ngendlela ye-tabular, esiyibonile kuma-processors we-tabular, kodwa kufomini yombhalo. Noma kunjalo, encwadini yezincwadi kulula kakhulu ukuhlela izinto zaleli fomethi. Udinga nje ukucabangela ukuthi umugqa ngamunye wetafula uhambelana nomugqa wombhalo ku-Notepad, futhi amakholomu ahlukaniswa ngama-commas noma abahlukanisi abahlukaniswe ngama-comma. Njengoba unikeziwe ngalolu lwazi, ungakwazi kalula ukwenza noma yikuphi ukulungisa, ukubaluleka kombhalo kimi, ukungeza imigqa, ukususa noma ukungeza abahlukanisi lapho kunesidingo.
Indlela yesi-5: I-Notepad ++
Ungawuvula ngosizo lomhleli wombhalo ophambili kakhulu - I-Notepad ++.
- Vula i-Notepad ++. Chofoza kwimenyu "Ifayela". Okulandelayo, khetha "Vula ...". Ungasebenzisa futhi Ctrl + O.
Enye indlela kuhilela ukuchofoza isithonjana sephaneli ngendlela ifolda.
- Iwindi yokuvula ivela. Kudingeka ukuthuthela endaweni yesistimu lapho i-CSV efunayo ikhona khona. Ngemva kokukhetha, cindezela "Vula".
- Okuqukethwe kuboniswa ku-Notepad ++. Izimiso zokuhlela zifana ne-Notepad, kodwa i-Notepad ++ inikeza inani elikhulu kakhulu lamathuluzi wokusebenzisa idatha ehlukahlukene.
Indlela 6: Safari
Ungabuka okuqukethwe kwinguqulo yombhalo ngaphandle kokuthi ukwazi ukuhlela kusiphequluli se-Safari. Ezinye iziphequluli ezithandwa kakhulu azihlinzeki lesi sici.
- Qalisa i-Safari. Chofoza "Ifayela". Okulandelayo, chofoza "Vula ifayela ...".
- Iwindi yokuvula ivela. Kudinga ukuthuthela endaweni lapho i-CSV ikhona khona, umsebenzisi ofuna ukuyibuka. Kuyadingeka ukushintsha amafomethi efasiteleni "Wonke Amafayela". Bese ukhetha into nge-CSV yokwandisa bese ucindezela "Vula".
- Okuqukethwe kwento kuzovulwa efasiteleni elisha le-Safari kufomathi yombhalo, njengoba kwakungu-Notepad. Iqiniso, ngokungafani ne-Notepad, ukuhlela idatha ku-Safari, ngeshwa, ngeke kusebenze, ngoba uyayibona kuphela.
Indlela 7: iMicrosoft Outlook
Ezinye izinto ze-CSV ama-imeyili athunyelwe kusuka kuklayenti le-imeyili. Bangabhekwa besebenzisa iMicrosoft Outlook besebenzisa inqubo yokungenisa.
- Qalisa i-Outluk. Ngemva kokuvula uhlelo, iya kuthebhu "Ifayela". Bese uchofoza "Vula" e-sidebar. Okulandelayo, chofoza "Ngenisa".
- Iqala "Ngenisa futhi thumela i-Wizard". Kulolu hlu olukhethiwe khetha "Ngenisa kusuka kwenye uhlelo noma ifayela". Cindezela phansi "Okulandelayo".
- Ewindini elilandelayo, khetha uhlobo lento ongenayo. Uma sizofaka i-CSV, khona-ke kudingeka sikhethe isikhundla "I-Comma Ehlukanisiwe Imilinganiselo (Windows)". Chofoza "Okulandelayo".
- Ewindini elilandelayo, chofoza "Buyekeza ...".
- Iwindi livela "Buyekeza". Kumele uye endaweni lapho le ncwadi ifomethi ye-CSV. Maka le nto bese ucindezela "Kulungile".
- Ibuyela ewindini "Ngenisa futhi thumela ama-Wizards". Njengoba ungabona endaweni "Ifayili yokungenisa" Ikheli lengezwe endaweni ye-CSV into. Ku-block "Izinketho" Izilungiselelo zingashiywa njengezizenzakalelayo. Chofoza "Okulandelayo".
- Khona-ke udinga ukumaka ifolda ebhokisini lemeyili lapho ufuna ukufaka khona izincwadi ezifakiwe.
- Iwindi elilandelayo libonisa igama lesenzo esizokwenza ngohlelo. Kwanele ukuchofoza "Yenzelwe".
- Ngemva kwalokho, ukubuka idatha engenisiwe, hamba uye kuthebhu "Ukuthumela nokwamukela". Endaweni ehlangothini yesikhombikubona sohlelo, khetha ifolda lapho incwadi ingeniswe khona. Khona-ke engxenyeni eyinhloko yohlelo izovela uhlu lwamagama akhiwe kule folda. Kwanele ukuchofoza kabili encwadini oyifunayo ngenki yegundane lesokunxele.
- Incwadi ethunyelwe kusukela ku-CSV izovulwa ohlelweni lwe-Outluk.
Kumele kuqaphele, kodwa, ukuthi akuzona zonke izinto ezisefomethi ye-CSV ezingasebenza ngale ndlela, kodwa kuphela izinhlamvu ezinesakhiwo esithile, okungukuthi, eziqukethe amasimu: isihloko, umbhalo, ikheli lokuthumela, ikheli lomamukeli, njll.
Njengoba ungabona, kunezinhlelo ezimbalwa kakhulu zokuvula izinto zefomethi ye-CSV. Njengomthetho, kungcono ukubuka okuqukethwe kwalawo mafayela kumaprosesa we-tabular. Ukuhlela kungenziwa njengombhalo kubashicileli bombhalo. Ngaphezu kwalokho, kune-CSV ehlukile ngesakhiwo esithile, esisebenza nezinhlelo ezikhethekile, njengezaklayenti ze-imeyli.
