Tsegulani mtundu wa CSV

CSV (Comma-Separated Value) ndi fayilo yama fayilo yolemba yomwe inakonzedwa kuti iwonetse mbiri ya tabular. Poterepa, mizati imasiyanitsidwa ndi comma ndi semicolon. Dziwani kuti ndi mapulogalamu ati omwe mungatsegule mawonekedwe awa.

Mapulogalamu ogwira ntchito ndi CSV

Monga lamulo, mapurosesa a tebulo amagwiritsidwa ntchito kuwona molondola zomwe zili mu CSV, ndipo olemba malembawo angagwiritsidwenso ntchito kuwasintha. Tiyeni tiwone mwatsatanetsatane mayendedwe azinthu pamene mapulogalamu osiyanasiyana amatsegula fayilo yamtunduwu.

Njira 1: Microsoft Excel

Tiyeni tiwone momwe mungayendetsere CSV mu purosesa yotchuka ya Excel mawu, omwe akuphatikizidwa mu Microsoft Office suite.

1. Yambitsani Excel. Pitani ku tabu Fayilo.



2. Kupita patsamba ili, dinani "Tsegulani".

   

   M'malo mwa izi, mutha kugwiritsa ntchito pepalalo mwachindunji Ctrl + O.

3. Zenera likuwonekera "Kutsegula chikalata". Gwiritsani ntchito kuyendayenda komwe CSV ili. Onetsetsani kuti mwasankha pamndandanda wamitundu Mafayilo Olemba kapena "Mafayilo onse". Kupanda kutero, mtundu womwe mukufuna siwonetsedwa. Kenako lembani chinthu chopatsidwa ndikusindikiza "Tsegulani"zomwe zipangitsa "Mkulu wazamalemba".

Pali njira inanso yoti mupiteko "Mkulu wazamalemba".

1. Pitani ku gawo "Zambiri". Dinani pa chinthu "Kuchokera palemba"kuyikidwa block "Kupeza deta yakunja".



2. Chida chikuwoneka Tengani Fayilo Yakalembera. Zofanana monga pazenera "Kutsegula chikalata", apa muyenera kupita kumalo omwe kuli chinthucho ndikuyika chizindikiro. Simuyenera kusankha mafomu, chifukwa mukamagwiritsa ntchito chida ichi, zinthu zomwe zili ndi zolemba zikuwonetsedwa. Dinani "Idyani".



3. Iyamba "Mkulu wazamalemba". Pa zenera lake loyamba "Tchulani mtundu wa data" ikani batani la wailesi kuti Olekanitsidwa. M'deralo "Fayilo ya fayilo" ikuyenera kukhala chizindikiro Unicode (UTF-8). Press "Kenako".



4. Tsopano ndikofunikira kuchita gawo lofunikira kwambiri, momwe kulondola kwa chiwonetserochi kudalira. Chofunikira kuti chisonyeze chomwe chimadziwika kuti chimadzipatula: semicolon (;) kapena comma (,). Chowonadi ndi chakuti m'maiko osiyanasiyana miyezo yosiyanasiyana imagwiritsidwa ntchito pankhaniyi. Chifukwa chake, pamalemba achingerezi, comma imagwiritsidwa ntchito nthawi zambiri, ndipo pazilankhulo za Chirasha, semicolon. Koma pali zosiyasiyana pomwe olekanitsa agwiritsidwa ntchito posinthanitsa. Kuphatikiza apo, m'malo osowa kwambiri, zilembo zina zimagwiritsidwa ntchito ngati onyenga, monga mzere wavy (~).

   Chifukwa chake, wosuta ayenera kudziwa ngati pamenepa mkhalidwe wina ndi wonyenga kapena ndi chizindikiro chomanga nthawi zonse. Amatha kuchita izi poyang'ana malembedwe omwe akuwonekera m'deralo. "Zitsanzo zachitsanzo" komanso kutengera mfundo zomveka.

   

   Wogwiritsa ntchito atazindikira kuti ndi gawo liti lomwe likugawanitsa gulu "Wodzilekanitsa ndi" onani bokosi pafupi Semicolon kapena Comma. Mabokosi ofunikira amayenera kuchotsedwa kuzinthu zina zonse. Kenako dinani "Kenako".



5. Pambuyo pake, zenera limatseguka momwe, ndikuwunikira mzati winawake m'deralo "Zitsanzo zachitsanzo", mutha kuyika mawonekedwe oti awonetse chidziwitso choyenera mu chipingacho Column Data Format posintha mabatani a wailesi pakati pa malo otsatirawa:
   • dumphani mzati;
   • zolemba
   • Tsiku
   • wamba.

   Mukamaliza kudulira pamanja, kanikizani Zachitika.



6. Zenera limawoneka kuti likufunsa komwe ndalamayo ikutumizidwe ili papepala. Mwa kusintha mabatani a wailesi, mutha kuchita izi papepala latsopano kapena lomwe mulipo. Pomaliza, muthanso kulongosola ndendende malo omwe lingachitike m'gawo lolingana. Pofuna kuti musazilowetse pamanja, ndikokwanira kuyika chikwangwani m'munda uno, ndikusankha pa pepalalo lomwe foniyo idzakhale gawo lamanzere mndandanda wazomwe zidzatsanulidwazo. Mukakhazikitsa magwirizanidwe, dinani "Zabwino".



7. Zomwe zili pachinthucho zikuwonetsedwa pa pepala la Excel.

Phunziro: Momwe mungayendetsere CSV ku Excel

Njira 2: LibreOffice Calc

Purosesa lina la tebulo lingayendetse CSV - Calc, yomwe ndi gawo la msonkhano wa LibreOffice.

1. Yambitsani LibreOffice. Dinani "Tsegulani fayilo" kapena gwiritsani ntchito Ctrl + O.

   

   Mutha kudutsanso menyu mwa kukanikiza Fayilo ndi "Tsegulani ...".

   

   Kuphatikiza apo, zenera lotsegulira limathanso kupezeka mwachindunji kudzera pa mawonekedwe a Calc. Kuti muchite izi, mukakhala ku LibreOffice Calc, dinani pazenera kapena mtundu Ctrl + O.

   

   Njira ina imaphatikizanso ndi kusintha kwa mndandanda ndi mfundo Fayilo ndi "Tsegulani ...".



2. Kugwiritsa ntchito njira zingapo zomwe zatchulidwa kumabweretsa zenera "Tsegulani". Sunthani komwe kuli CSV, ikani chizindikiro ndikusindikiza "Tsegulani".

   

   Koma mutha kuchita popanda kuthamanga pazenera "Tsegulani". Kuti muchite izi, kokerani CSV "Zofufuza" ku LibreOffice.



3. Chida chikuwoneka Lowetsani Mawukukhala analog "Zolembalemba" mu Excel. Ubwino ndikuti pamenepa simuyenera kusuntha pakati pazenera zosiyanasiyana, kumayendetsa zoikamo, popeza magawo onse omwe ali pazenera limodzi.

   Pitani mwachindunji pagawo lazokonda "Idyani". M'deralo "Kutsegula" sankhani mtengo Unicode (UTF-8)ngati zitawonetsedwa pamenepo. M'deralo "Chilankhulo" sankhani chilankhulo. M'deralo "Kuchokera mzere" muyenera kufotokozera kuti ndi gawo liti lomwe liyenera kuyambitsa kulowetsedwa kwa zomwe zili. Mwambiri, izi sizikusowa kuti zisinthidwe.

   Kenako, pitani ku gululi Zosankha Zopatula. Choyamba, muyenera kukhazikitsa batani lailesi kuti Wopatula. Kupitilira apo, molingana ndi mfundo yomweyi yomwe idaganiziridwa mukamagwiritsa ntchito Excel, muyenera kufotokozera, poyang'ana bokosi pafupi ndi chinthu china chake, chomwe kwenikweni chitenga mbali ya gawo: semicolon kapena comma.

   "Zosankha zina" siyani zosasinthika.

   Mutha kuwona pasadakhale kuti chidziwitso chogulitsidwa chimawoneka bwanji ndikusintha makonda ena, pansi pazenera. Mukalowetsa magawo onse ofunikira, kanikizani "Zabwino".



4. Zolemba zikuwonetsedwa kudzera pa mawonekedwe a LibreOffice Kalk.

Njira 3: OpenOffice Calc

Mutha kuwona CSV pogwiritsa ntchito purosesa ina ya pagome - OpenOffice Calc.

1. Yambitsani OpenOffice. Pazenera chachikulu, dinani "Tsegulani ..." kapena gwiritsani ntchito Ctrl + O.

   

   Mutha kugwiritsa ntchito menyu. Kuti muchite izi, pitani pazinthuzo Fayilo ndi "Tsegulani ...".

   

   Monga momwe zimakhalira ndi pulogalamu yapita, mutha kufika pazenera lotsegula mwachindunji kudzera pa mawonekedwe a Kalk. Poterepa, muyenera dinani pazithunzi pazithunzi za chikwatu kapena kutsatira zomwezo Ctrl + O.

   

   Mutha kugwiritsanso ntchito menyu popita kumalo omwe muli. Fayilo ndi "Tsegulani ...".



2. Pazenera lotsegulira lomwe limapezeka, pitani kumalo a CSV, sankhani chinthuchi ndikudina "Tsegulani".

   

   Mutha kuchita popanda kukhazikitsa zenera ili pongokoka CSV kuchokera "Zofufuza" mu OpenOffice.



3. Chilichonse mwazomwe zikufotokozedwa chitsogolera kutsegula kwa zenera. Lowetsani Mawu, omwe ali ofanana kwambiri mawonekedwe ndi magwiridwe antchito ndi chida chokhala ndi dzina lomweli ku LibreOffice. Ndipo chitani zomwezo. M'minda "Kutsegula" ndi "Chilankhulo" vumbula Unicode (UTF-8) komanso chilankhulo cha zomwe zalembedwa, motsatana.

   Mu block Separator Paramu ikani batani la wailesi pafupi ndi chinthucho Wopatula, kenako onani bokosi pafupi ndi (Semicolon kapena Comma) omwe amafanana ndi mtundu wodzilekanitsa mu chikalatacho.

   Pambuyo pochita izi, ngati deta yomwe ili mufayilo yowonetsedwa pansi pazenera ikuwonetsedwa bwino, dinani "Zabwino".



4. Zambiri ziziwonetsedwa bwino pa mawonekedwe a OpenOffice Kalk.

Njira 4: Zolemba

Kuti musinthe, mutha kugwiritsa ntchito Notepad pafupipafupi.

1. Yambitsani Notepad. Pazosankha, dinani Fayilo ndi "Tsegulani ...". Kapena mutha kulembetsa Ctrl + O.



2. Windo lotsegula likuwonekera. Pitani mmalo amenewo kupita ku malo a CSV. M'malo owonetsera mtundu, ikani mtengo wake "Mafayilo onse". Lemberani chinthu chomwe mukufuna. Kenako akanikizire "Tsegulani".



3. Cholembedwacho chidzatsegulidwa, koma, osati, mwa mawonekedwe omwe tawonera zomwe tidatsata patebulopo, koma palemba loyambayo. Komabe, mu kakalata kakang'ono ndikosavuta kusintha zinthu zamtunduwu. Mukungofunika kudziwa kuti mzere uliwonse wa tebulo umafanana ndi mzere walemba ku Notepad, ndipo mzati umasiyanitsidwa ndi olekanitsidwa mu mawonekedwe a comas kapena semicolons. Popeza izi, mutha kusintha zina ndi zina mosavuta kwa ine, malingaliro amalemba, kuwonjezera mizere, kuchotsa kapena kuwonjezera olekanitsidwa pakafunika.

Njira 5: Notepad ++

Mutha kutsegula ndi cholembera chapamwamba kwambiri - Notepad ++.

1. Yatsani Notepad ++. Dinani pamenyu Fayilo. Chosankha chotsatira "Tsegulani ...". Mutha kuyambiranso Ctrl + O.

   

   Njira inanso ikuphatikizira kuwonekera pazenera monga mtundu wa chikwatu.



2. Windo lotsegula likuwonekera. Ndikofunikira kusamukira kudera la fayilo komwe kuli CSV yomwe ilipo. Mukasankha, akanikizani "Tsegulani".



3. Zomwe zikuwonetsedwa mu Notepad ++. Mfundo zakusintha ndizofanana ndi kagwiritsidwe ntchito ka Notepad, koma Notepad ++ imapereka zida zochulukirapo pazida zingapo zosanja.

Njira 6: Safari

Mutha kuwona zomwe zili mumtundu wa zolemba popanda kuthekera kosintha mu msakatuli wa Safari. Asakatuli ena ambiri otchuka samapereka izi.

1. Yambitsani Safari. Dinani Fayilo. Dinani kenako "Tsegulani fayilo ...".



2. Zenera loyambira likuwonekera. Zimafunika kusamukira komwe CSV ili, komwe wogwiritsa ntchito akufuna kuti awone. Kuvomerezedwa kutembenuka kwa zenera kuyenera kukhazikitsidwa "Mafayilo onse". Kenako sankhani chinthucho ndi kuwonjezera kwa CSV ndikudina "Tsegulani".



3. Zomwe zili pachinthucho zitsegulidwa pazenera zatsopano la Safari mu mawonekedwe, monga zidaliri mu Notepad. Zowona, mosiyana ndi Notepad, kusintha data mu Safari, mwatsoka, sikugwira ntchito, chifukwa mutha kungowona.

Njira 7: Microsoft Outlook

Zinthu zina za CSV ndi maimelo omwe atumizidwa kuchokera kwa kasitomala wa imelo. Amatha kuwonedwa akugwiritsa ntchito pulogalamu ya Microsoft Outistic pochita njira yolowera kunja.

1. Yambitsirani Maganizo. Mukatsegula pulogalamu, pitani ku tabu Fayilo. Kenako dinani "Tsegulani" mumenyu yakutali. Dinani Kenako "Idyani".



2. Iyamba "Wizard Wotumiza ndi Kutumiza Kunja". Pa mndandanda womwe waperekedwa, sankhani "Idyani kuchokera ku pulogalamu ina kapena fayilo". Press "Kenako".



3. Pazenera lotsatira, sankhani mtundu wa chinthu chomwe mungalowe nacho. Ngati tikufuna kuloweza CSV, ndiye kuti muyenera kusankha malo "Makhalidwe Osiyanasiyana a Comma (Windows)". Dinani "Kenako".



4. Pazenera lotsatira, dinani "Ndemanga ...".



5. Zenera likuwonekera "Mwachidule". Iyenera kupita kumalo omwe kalatayo ili mu mtundu wa CSV. Lembani izi ndikudina "Zabwino".



6. Pali kubwerera ku zenera "Wizitsani Wotumiza ndi Kutumiza Kunja". Monga mukuwonera, m'deralo "Fayilo yolowera" Adilesi yawonjezeredwa komwe kuli CSV chinthu. Mu block "Zosankha" makonda akhoza kusiyidwa ngati osakhazikika. Dinani "Kenako".



7. Kenako muyenera kuyika chikwatu mu bokosi la makalata pomwe mukufuna kuyilembera makalata oitanitsa.



8. Windo lotsatira likuwonetsa dzina la zomwe zidzachitike ndi pulogalamuyi. Ingodinani apa Zachitika.



9. Pambuyo pake, kuti muwone zambiri zomwe zatengedwa, pitani pa tabu "Kutumiza ndi kulandira". M'mbali mwa mawonekedwe a pulogalamuyi, sankhani chikwatu komwe uthengawo unatumizidwa. Kenako pakatikati pa pulogalamuyi mndandanda wamakalata omwe ali mufoda iyi udzawonekera. Ndikokwanira kuti dinani kawiri pa kalata yomwe mukufuna ndi batani lakumanzere.



10. Kalata yomwe idatengedwa kuchokera ku chinthu cha CSV idzatsegulidwa mu pulogalamu ya Outlook.

Zowona, ndikofunikira kuzindikira kuti mwanjira iyi mutha kuthamangitsa kutali ndi zinthu zonse za CSV, koma zilembo zokha zomwe kapangidwe kake kamakhala ndi malire, omwe ali ndi magawo: mutu, zolemba, adilesi ya otumiza, adilesi yolandirira, etc.

Monga mukuwonera, pali mapulogalamu ochepa kwambiri otsegulira zinthu za mtundu wa CSV. Monga lamulo, ndibwino kuti muwone zomwe zili mumafayilo amtundu wa patebulo. Kusintha kumatha kuchitika ngati malembedwe aakonzi. Kuphatikiza apo, pali ma CSV osiyana ndi mawonekedwe enaake, omwe mapulogalamu apadera amagwira, mwachitsanzo, makasitomala amaimelo.