Indlela yokuvula i-CSV: 7 Iinketho zomsebenzi ezi-7

I-CSV (amaxabiso ahlukileyo kwi-coma) yifayile yefomathi yokubhaliweyo eyilelwe ukubonisa idatha ye-tabir. Kwangelo xesha, iikholamu zahlulwe yikoma kunye nesemicolon. Sifunda ukuba zeziphi iindlela onokuthi uzivule le fomathi.

Iinkqubo ze-CSV

Njengommiselo, kusetyenziswa iiprosesa zetafile ekujonganeni ngokuchanekileyo kwakhona kwemixholo ye-CSV, kwaye abahleli bemibhalo abanokusetyenziswa ukuze bahlele. Makhe siqwalasele ngakumbi i-algorithm yezenzo xa kuvulwa iinkqubo ezahlukeneyo zolu hlobo lweefayile.

Indlela yoku-1: I-Microsoft Excel

Cinga ngendlela yokuqhuba i-CSV kwiprosesa ye-Enceb edumileyo, equkiweyo kwiphakheji yeOfisi yeMicrosoft.

1. Sebenzisa i-Excel. Yiya kwi "Ifayile" yethebhu.



2. Ukuya kule thebhu, cofa u "Vula".

   

   Endaweni yezi zenzo, kunokwenzeka ukuba usebenzise i-CTRL + O kwiphepha.

3. "Uxwebhu" lokuvula "luyavela. Ngayo, uya kufikelela apho i-CSV ikhona. Qiniseka ukuba ukhetha "iifayile zombhalo" okanye "zonke iifayile" ukusuka kuluhlu lwefomathi. Ngaphandle koko, ifomathi oyifunayo ayiboniswanga. Emva koko khetha le nto kwaye ucofe u "Vula", oya kuthi uyibize i "Master yezibhalo".

Ikho enye indlela yokuya kwi "inkosi yezibhalo".

1. Yiya kwicandelo "ledatha". Cinezela "kwiNgxelo", ibekwe kwi "Fumana iBhloko yangaphandle".



2. Isixhobo sokungenisa isixhobo "isixhobo sefayile. Njengakwi "ncwadi" lokuvula ", kufuneka uye kwindawo yendawo kwaye uphawula. Akukho mfuneko yokuba ukhethe iifomathi, ukusukela xa usebenzisa esi sixhobo, izinto ezinesicatshulwa ziya kuboniswa. Cofa "Ngenisa".



3. I "Inkosi yezicatshulwa" isunguliwe. Kwifestile yayo yokuqala, "chaza ifomathi yedatha" Beka iqhosha lerediyo kwi "kunye" ne-wandrators ". Kwindawo "yefomati yefayile", i-Unicode (i-UtF-8) ifanele ibe njalo. Cinezela "ngokulandelayo".



4. Ngoku kufuneka wenze inyathelo elibaluleke kakhulu, eliya kuxhomekeka ekuchazeni uvavanyo lwedatha. Kuya kufuneka ukubonisa ukuba ithathwa njengesahluli: inqaku eline-comma (;) okanye ikoma (,). Inyani yile yokuba imigangatho eyahlukeneyo isebenza kumazwe awahlukeneyo. Ke, izicatshulwa zelwimi lesiNgesi, ikoma idla ngokusetyenziswa ngakumbi, kunye ne-Russian-Ukuthetha isiRashiya kunye nekoma. Kodwa kukho okwahlukileyo xa izabelo zisebenza ngokuchaseneyo. Ukongeza, kwiimeko ezinqabileyo kakhulu, ezinye iimpawu zisetyenziswa njengokwahlula-hlulwa, ezinjengomgca we-wavy (~).

   Ke ngoko, umsebenzisi makazifake ngokwakhe, nokuba lityala elithile lomahluli okanye sisibonakaliso esiqhelekileyo sokudibanisa. Inokwenziwa ngokujonga isicatshulwa esiboniswe kwindawo ethi "Isampula yeDatha" kwaye isekwe kwi-Logic.

   

   Emva kokuchonga i-chasher ngqo ukuba loluphi uhlobo lophawu lwesahluli, kwiqela "Ukwahlulahlula" kuya kufuneka ujonge ibhokisi yokukhangela kufutshane nenqaku "okanye" ikoma "okanye" ikoma ". Kuzo zonke ezinye iibhokisi zokutshekisha kufuneka zisuswe. Emva koko cofa "ngokulandelayo".



5. Emva koko, iwindow ivuliwe apho ngokukhetha ikholamu ethile kwindawo "yedatha yedatha, unokwabela ifomathi yedatha" yefomathi "ibhloko" ibhloko "ivimba i-radiocans :
   • khupha iikholamu;
   • okhankanyiweyo;
   • umhla;
   • Ngokubanzi.

   Emva kokwenza i-wimipulations, cofa u "Gqibezela".



6. Iwindow iyavela, apho icelwe ukuba iphi idatha yephepha elingeniswayo kwiphepha. Ngokutshintsha iqhosha lerediyo, unokwenza kwiphepha elitsha okanye esele likho. Kwimeko yokugqibela, unokuchaza indawo efanelekileyo yokulungelelanisa kwicandelo elihambelanayo. Ukuze ungangenisi ngesandla, kwanele ukubeka isikhombisi kule ntsimi, emva koko ibalaselise iseli eya kuba yeyona nto ishiyekileyo yolawulo apho idatha iya kongezwa khona. Emva kokufaka ulungelelwaniso, cinezela Kulungile.



7. Umxholo wento uya kuboniswa kwiphepha le-elses.

Isifundo: Uqhuba njani i-CSV kwi-Excel

Indlela 2: I-LIBROFIce Calc

Sebenzisa i-CSV can kunye nenye iprosessor ye-tabiture - i-CAC, equkwe kwiNdibano ye-Librathoice.

1. Qhuba i-libreoffice. Cofa "ifayile evulekileyo" okanye usebenzise i-CTRL + O.

   

   Unokutshintsha kwimenyu ngokunqakraza "Ifayile" kunye "vula ...".

   

   Ukongeza, i-window yokuvula ungayifumana ngokuthe ngqo kwi-CALS inxibelelaniso. Ukwenza oku, ngelixa e-Libraffice Cal, cofa kwi icon njengefomathi okanye uhlobo lwe-CTRL + O.

   

   Olunye ukhetho lubonelela ngotshintsho olulandelelanayo kwi "Ifayile" kunye "vula ...".



2. Ukusetyenziswa kwalo naluphi na ukhetho olukhethiweyo lukhokelela kuya kubangela ukubonakala kwefestile "evulekileyo". Yiya kuyo kwindawo ye-CSV, phawula kwaye ucinezele "vula".

   

   Kodwa unokwenza ngaphandle kokuqalisa iwindow "evulekileyo". Ukwenza oku, tsala i-CSV kwi "Ehloli" kwi-llireofis.



3. Isixhobo "sokungenisa isicatshulwa" sivela, esiyinto engu-analogue ye "wizard yombhalo" kwi-Excel. Inzuzo kukuba kule meko akuyi kufuneka bahambe phakathi kweewindows ezahlukeneyo, ukwenza useto lokungenisa elizweni, kuba zonke iiparamitha ezifanelekileyo zibekwe kwifestile enye.

   Kwangoko yiya kwiqela lesetingi yendawo "yokungenisa". Kwindawo "yekhowudi", khetha i "Unicode (i-UTF-8)" Ixabiso ukuba elinye liboniswe apho. Kwindawo "yolwimi", khetha ulwimi lwesicatshulwa. Kwindawo "ukusuka kwindawo", kufuneka uchaze ukuba yeyiphi umtya ekufuneka uqale ukungenisa ngaphakathi. Kwiimeko ezininzi, akukho mfuneko yokuba wenze utshintsho kule parameter.

   Emva koko, yiya kwiqela "labahlukani". Okokuqala, kuyimfuneko ukufaka iqhosha lerediyo kwindawo "yokwahlula". Ngaphezulu kumgaqo omnye owawuqwalaselwa xa usebenzisa i-Excel, kuyimfuneko ukuqatshelwa ngokuseta ibhokisi malunga nenqaku elithile, eliza kudlalwa yindima ye-Semicolon okanye i-semicolon okanye ikoma.

   "Ezinye iiparamitha" zishiya zingaguqukanga.

   Ukubona kwangaphambili ukuba loluphi ulwazi olungeniswayo xa utshintsha useto oluthile, unokusezantsi kwefestile. Emva kokungena kuzo zonke iiparamitha ezifanelekileyo, cofa Kulungile.



4. Iziqulatho ziya kuboniswa kwi-LillReofis Calcy.

Indlela 3: I-OpenOffice Calc

Ungayijonga i-CSV usebenzisa enye iprosester ye-tabiture - i-OpenOffice Calc.

1. Baleka i-oopoopis. Kwifestile ephambili, cofa u "Vula ..." okanye usebenzise i-CTRL + O.

   

   Ungasebenzisa imenyu. Ukwenza oku, yiya "kwifayile" kwaye "vula ...".

   

   Njengokusetyenziswa kwendlela yenkqubo yangaphambili, unokufikelela kwifestile yokuvula evulekileyo ngokuthe ngqo kwiNkqubo yeCalkuc. Kule meko, kufuneka ucofe kwi icon kumfanekiso wefolda okanye ufake i-CTRL enye efanayo ye-Ctrl + O.

   

   Ungasebenzisa imenyu ngokuhamba kuyo nge "Ifayile" kunye "vula ..." izikhundla.



2. Kwifestile yokuvula ebonakalayo, yiya kwindawo ye-CSV, khetha le nto kwaye ucofe ". Vula".

   

   Unokwenza ngaphandle kokuqalisa le festile, ukuba nentembelo nje ye-csv kwi "Ehlohli" kwi-OpenOfis.



3. Nawuphi na ummiselo wezenzo ezichaziweyo ziya kukhokelela ekusebenzeni "kwitekisi yokungenisa elizweni, efana nembonakalo, kunye nokusebenza kwesixhobo ngegama elifanayo kwi-Libraffice. Ngokuhambelana, iintshukumo ziyafana. Kwi "winding" kunye "neelwimi", umboniso "Unicode (I-UTF-8)" nolwimi lwexwebhu lwangoku, ngokwahlukeneyo.

   Kwibhloko "eyahlula-hlulwa" ibhloko, beka iqhosha lerediyo kufutshane necandelo "Yohlulelwano", emva koko uyijonga le nto ("ikhomba kwi-semicolon" okanye "ehambelana nohlobo lombhali kuxwebhu.

   Emva kokwenza izenzo ezichaziweyo, ukuba idatha kwifom eboniswe kwifestile engezantsi iboniswe ngokufanelekileyo, cofa Kulungile.



4. Idatha iya kuboniswa ngempumelelo kwi-Intanethi yeCopeCis Countral.

Indlela 4: I-Matpad

Ungafaka incwadana yokuhlela rhoqo.

1. Baleka incwadana. Kwimenyu, cofa "kwifayile" kunye "vula ...". Okanye ungasebenzisa i-Ctrl + O.



2. Ifestile yokuvula iyavela. Yiya kuyo kwindawo ye-CSV. Kwimo yomboniso yefomathi, setha "zonke iifayile". Phawula into oyifunayo. Emva koko cinezela "Vula".



3. Into iya kuvulwa, kodwa, ngokuqinisekileyo, hayi kwifom ye-tabium, eso siye sabona kwiiprosesa zetafile, kunye nesicatshulwa. Nangona kunjalo, kwincwadi yencwadi ilula kakhulu ukuhlela izinto zale fomathi. Kuyimfuneko ukuqwalasela ukuba umqolo ngamnye we tafile uhambelana nomtya wokubhaliweyo kwincwadana enemifanekiso, kwaye iikholamu zahlulwe ngokwahlula-hlula ngendlela yeendlela okanye amachaphaza ngeekoma. Inikezwe olu lwazi, kunokwenzeka ukuba negalelo ngokulula naluphi na uhlengahlengiso, amaxabiso okubhaliweyo, ukongeza umtya, ukususa okanye ukongeza ukwahlula apho kuyimfuneko khona.

Indlela 5: I-ThutPad ++

Unokuvula kwaye usebenzisa umhleli oPhezulu we-Advanced-ThutPad ++.

1. Vula incwadana ++. Cofa kwimenyu yeFayile. Okulandelayo, khetha "Vula ...". Ungayisebenzisa kwakhona i-Ctrl + O.

   

   Olunye ukhetho lubandakanya ukucofa ipaneli kwi-icon yencwadi.



2. Ifestile yokuvula iyavela. Kufuneka ukufudukele kuloo ndawo yenkqubo yefayile apho i-CSV oyifunayo. Emva kokhetho lwayo, cinezela "vula".



3. Umxholo uya kuboniswa kwi-Matpad ++. Imithetho-siseko yokuhlela iyafana xa usebenzisa incwadana, kodwa i-Nohlobo ++ ibonelela ngesixa esikhulu sezixhobo zedatha ezahlukeneyo zedatha.

Indlela yesi-6: ISafari

Jonga umxholo kwinguqulelo yokubhaliweyo ngaphandle kokukwazi ukuyihlela, ungakwisikhangeli sendlela. Uninzi olunye lokukhangela alunikeli ithuba elinjalo.

1. Ibaleke iSafari. Cofa "Ifayile". Ngokubalandelayo nqakraza kwi "Ifayile evulekileyo ...".



2. Ifestile yokuvula iyavela. Ifuna ukufudukela kwindawo apho i-CSV ifumaneka khona, yomsebenzisi efuna ukujonga. Kunyanzelekile, utshintsho lwefomathi efestileni kufuneka lubekwe "zonke iifayile". Emva koko yenza ukhetho lwento eyandisiweyo ye-CSV kwaye ucofe Vula.



3. Iziqulatho zento ziya kuvulwa kwifestile entsha ye-sfari kwifom, njengoko yayikwincwadi yencwadi. Kuyinyani, ngokungafaniyo nencwadana, hlela idatha kwiSafari, ngelishwa, ayizukusebenza, njengoko unokujonga kuphela.

Indlela yesi-7: I-Microsoft Outlook

Ezinye izinto ze-CSV zii-imeyile ze-imeyile zithunyelwe kwi-imeyile. Banokujongwa kusetyenziswa inkqubo ye-Microsoftitlook ngokuvelisa inkqubo yokungenisa.

1. Gijima ngaphandle. Emva kokuvula le nkqubo, yiya kwi "Ifayile" yethebhu. Emva koko cofa uvule kwimenyu esecaleni. BASHHALA WOKUGQIBELA "Ngenisa".



2. "Inkosi yokungenisa ingenisa impahla kunye nokuthumela kwelinye ilizwe" isunguliwe. Kuluhlu olubonisiweyo, khetha "Ngenisa enye inkqubo okanye ifayile". Cinezela "ngokulandelayo".



3. Kwiwindows elandelayo, khetha uhlobo lwento yokungenisa elizweni. Ukuba siza kungenisa i-CSV, kuya kufuneka ukhethe "Ixabiso elahluleke kwindawo yeCommas". Cofa ".



4. Kwiwindows elandelayo, cinezela "uphononongo ...".



5. "Amagqabantshintshi" windows ivele. Kuya kufuneka iye kwindawo apho ileta ikwifomathi ye-CSV ikhona. Chaza le nto kwaye ucofe u "Kulungile".



6. Ibuyela "kwi-Master yokungenisa kunye nokungenisa" kwelinye ilizwe "lokuthumela kwelinye ilizwe". Njengoko ubona, kwifayile "yokungenisa, idilesi yongezwa kwindawo ye-CSV. Kwi "Parameter" ibhloko, useto lungashiywa ngokuzenzekelayo. Cofa ".



7. Emva koko kufuneka uphawule ukuba le folda kwibhokisi yeposi apho ufuna ukubeka khona imbalelwano engeniswayo.



8. Iwindow elandelayo ibonisa igama lesenzo esiya kuthi senzelwe yiNkqubo. Apha kwanele ukucofa "ukulungele."



9. Emva koko, ukujonga idatha engenisiweyo, fudukela kwi "Thumela kwaye ufumane" ithebhu. Kwindawo eyalandelayo yenkqubo yenkqubo yenkqubo, khetha ifolda apho yafunyanwa ileta. Ke, kwinxalenye ephakathi yenkqubo, uluhlu lweeleta ezilandelayo ziya kuvela. Cofa nje kwileta enqwenelekayo kabini ngeqhosha lasekhohlo iqhosha.



10. Ileta engeniswe evela kwinto ye-CSV iya kuvulelwa kwinkqubo yase-Outluk.

Kuyinyani, kufanelekile ukuba le ndlela inokupheliswa kwezinto zefomathi ye-CSV, kodwa kuphela oonobumba abanesakhiwo esithile esihambelana nomgangatho othile, oko kukuthi, idilesi, idilesi yomthumeli, idilesi yomamkeli, njl.

Njengoko ubona, kukho iinkqubo ezimbalwa zokuvula izinto ze-CSV. Njengomthetho, kungcono ukujonga imixholo yeefayile ezifana neeprosesa zeabuster. Ukuhlela kunokwenziwa njengombhalo kubahleli bothunge. Ukongeza, kukho ii-CSVs ezahlukileyo ze-CSVs ezinesithamo esithile esisebenza kuzo, njengabathengi beposi.