Momwe mungatsegulire CSV: 7 Zosankha

CSV (mfundo zopatukana-comma) ndi fayilo ya zilembo zomwe zapangidwa kuti ziwoneke bwino. Nthawi yomweyo, mizata imalekanitsidwa ndi comma ndi semicolon. Timaphunzira, ndi ntchito ziti zomwe mungagwiritse ntchito.

Mapulogalamu a CSV

Monga lamulo, madongosolo a tebulo amagwiritsidwa ntchito poona zomwe zili mu CSV, ndipo olemba mameseji amatha kugwiritsidwa ntchito kuwasintha. Tiyeni tikambirane mwatsatanetsatane algorithm ya zochita mukatsegula mapulogalamu osiyanasiyana amtunduwu.

Njira 1: Microsoft Excel

Ganizirani momwe mungayendetsere CSV mu purosesa yotchuka ya Exel, yomwe imaphatikizidwa mu phukusi la Microsoft.

1. Thamangani Excel. Pitani ku "fayilo" tabu.



2. Kupita ku tabu iyi, dinani "Tsegulani".

   

   M'malo mwa zochita izi, ndizotheka kugwiritsa ntchito CTRL + o pa pepala.

3. Zikalata zotseguka "zikuwonekera. Ndi icho, mudzasamukira ku CSV ili. Onetsetsani kuti mwasankha "mafayilo" kapena "mafayilo onse" kuchokera pamndandanda wamafuta. Kupanda kutero, mtundu womwe mukufuna sunawonekere. Kenako sankhani chinthu ichi ndikudina "lotseguka", lomwe lidzatcha "masters".

Pali njira ina yopita ku "Msterna".

1. Pitani ku "deta". Kanikizani "kuchokera ku chinthu", chomwe chili mu "kupeza deta yakunja".



2. Chida cholowera "chitsimikiziro" chikuwoneka. Monga mu "Chikalata chotsegulira", ndikofunikira kupita kudera la chinthucho ndikuwulemba. Simuyenera kusankha mafomu, chifukwa mukamagwiritsa ntchito chida ichi, zinthu zomwe zili ndi zolemba zidzawonetsedwa. Dinani "Cholowetsa".



3. "Master of malembo" ayambitsidwa. M'mawilo ake oyamba, "Fotokozerani mtundu wa data" Ikani batani la Idilesi kwa "wokhala ndi malo opatulika". Mu "Fomu ya fayilo", Unicode (UTF-8) iyenera kukhala. Dinani "Kenako".



4. Tsopano muyenera kuchita gawo lofunikira kwambiri, lomwe limatengera kuwonetsa kwa deta. Zimafunika kuwonetsa kuti imawerengedwa kuti ndi yolekanitsa: mfundo ndi comma (;) kapena comma (,). Chowonadi ndi chakuti miyezo yosiyanasiyana yosiyanasiyana imagwira ntchito m'maiko osiyanasiyana. Chifukwa chake, kwa malembedwe achingelezi, comma imagwiritsidwa ntchito nthawi zambiri, komanso yolankhula Chirasha - mfundo ndi comma. Koma pali zosiyana siyana pamene agalu amagwira ntchito mosiyana ndi izi. Kuphatikiza apo, molakwika kwambiri, zizindikiro zina zimagwiritsidwa ntchito ngati zopatula, monga mzere wa wavy (~).

   Chifukwa chake, wogwiritsa ntchitoyo ayenera kudziyika yekha, kaya chofanizira ichi chowoneka bwino cha wolekanitsa ndi kapena ndi chizindikiro chopumira wamba. Itha kuchitika poyang'ana lembalo lomwe likuwonetsedwa m'dera la "zitsanzo za data" komanso kutengera mfundo.

   

   Pambuyo posankha wogwiritsa ntchito ndendende ndi chizindikiro, mu gulu la "mu gulu la" chizindikiro-chowoneka bwino ndi "muyenera kuyang'ana bokosilo" kapena "Comma" kapena "Comma". Kuchokera pamabokosi ena onse ayenera kuchotsedwa. Kenako dinani "Kenako".



5. Pambuyo pake, zenera limatseguka pomwe posankha gawo lina la "zitsanzo," mutha kupatsa mawonekedwe a mawonekedwe a zolondola mu "mawonekedwe a data posinthira ma radiocans otsatirawa :
   • dumphani mizati;
   • Zolemba;
   • tsiku;
   • General.

   Pambuyo pochita zopyola, dinani "kumaliza".



6. Zenera limawonekera, lomwe limafunsidwa komwe deta yomwe ili papepala ili pa pepalalo. Mwa kusintha batani la wailesi, mutha kuchita papepala latsopano kapena latsopano. Potsirizira pake, mutha kunenanso kuti malowo amagwirizana mu gawo lolingana. Pofuna kuti musawalowe pamanja, ndikokwanira kuyika cholozera m'munda uno, kenako ndikutsindika khungu lomwe likhala losiyidwa lakuthwa komwe deta idzawonjezedwa. Pambuyo kukhazikitsa magwiridwe, kanikizani OK.



7. Zomwe zili ndi chinthucho ziwonetsedwa papepala la Ext.

Phunziro: Momwe Mungayendetsire CSV ku Excel

Njira 2: Cala calc

Thamangani CSV imatha ndi processor prossorsor - Kale, yomwe imaphatikizidwa kumsonkhano wa LibreOffice.

1. Thamangani malo a Listoffec. Dinani "Tsegulani fayilo" kapena gwiritsani CTRL + O.

   

   Mutha kusinthanso kudzera mumenyu podina "Fayilo" ndi "tsegulani ...".

   

   Kuphatikiza apo, zenera lotseguka mutha kudutsa mwachindunji mawonekedwe a cals. Kuti muchite izi, mukadali ku Cal Cal Cal, dinani chithunzicho ngati mawonekedwe a chikwatu kapena mtundu wa ctrl + o.

   

   Njira ina imasinthiratu ku "fayilo" ndi "lotseguka ..." Zinthu.



2. Ntchito iliyonse ya njira zambiri kutchulidwa chingandithandize maonekedwe a "Open" zenera. Kusamukira ku malo a CSV, mulembe izo ndi atolankhani "Open".

   

   Koma mungathe kuchita popanda kukulozani ndi "Open" zenera. Kuti tichite zimenezi, kuukoka CSV ku "Explorer" kuti Libreofis.



3. The "Tengani Text" chida aonekera, chomwe ndi analogue a "Text mfiti" mu kupambana. Ubwino ndi kuti mu nkhani iyi iwo sadzakhala ndi kusuntha pakati mazenera osiyana, kuchita zoikamo inatha, kuyambira magawo zonse zofunikira zili zenera limodzi.

   Nthawi yomweyo kupita ku "Tengani" Zikhazikiko gulu. Mu "kabisidwe" dera, kusankha "Unicode (UTF-8)" phindu ngati wina anakhoma kumeneko. Mu "Language" dera, sankhani chilankhulo malemba. Mu "Kuchokera Line" dera, muyenera mwachindunji chingwe chimene ayenera kuyamba yoti okhutira. Nthawi zambiri, simuyenera kusintha mu chizindikiro ichi.

   Kenako pitani gulu "olekanitsa". Choyamba, m'pofunika kukhazikitsa batani wailesi mu "olekanitsa" malo. Komanso pa mfundo yomweyi kuti ankaona ntchito kupambana, m'pofunika mwachindunji poonetsa bokosi zosiyana inayake yomwe idzaseweredwe ndi udindo wa olekanitsa ndi: a semicolon kapena koma.

   "Magawo Other" kusiya sichinasinthe.

   Pre-kuwona ndendende zimene kunja maonekedwe mudziwe ngati inu sinthani ena, mukhoza pansi pa zenera. Utatha magawo zonse zofunika, dinani bwino.



4. Nkhani adzakhala anasonyeza mwa mawonekedwe Libreofis Calc.

Njira 3: OpenOffice Calc

Mutha kuona CSV ntchito purosesa wina tabular - OpenOffice Calc.

1. Kuthamanga oopoopis. Mu zenera chachikulu, dinani "Open ..." kapena ntchito Ctrl + O.

   

   Mukhozanso ntchito menyu. Kuchita izi, kupita "Buku" ndi "Open ...".

   

   Monga ntchito njira ndi pulogalamu yapita, mukhoza kupeza kuti Open Oyamba zenera mwachindunji kupyolera Calc Chiyankhulo. Pankhaniyi, muyenera alemba pa mafano mu chikwatu chifanizo kapena ntchito zonse yemweyo Ctrl + O.

   

   Mukhozanso ntchito menyu ndi kupita mu izo mwa "Buku" ndi "lotseguka ..." maudindo.



2. Mu kutsegula zenera kuti aonekera, kupita ku CSV malo dera, kusankha chinthu ichi ndi atolankhani "Open".

   

   Mutha kuchita popanda kuyambitsa zenera ili, kungotsegula CSV kuchokera ku "wofufuza" kutseguka.



3. Zochitika zilizonse zofotokozedwa zidzayambitsa kutsegulira kwa zenera la "mutu", zomwe ndizofanana kwambiri, komanso magwiridwe antchito omwe ali ndi chida chomwe chili ndi dzina lofanana mu Libremoffice. Motero, zochitazo ndizofanana ndendende. Mu "polowa" ndi "zilankhulo", onetsani "Unicode (UTF-8)" ndi chilankhulo chalembedwa pano, motero.

   Mu "cholekanitsa parameter", ikani batani lailesi pafupi ndi gawo la "Olekanitsa", kenako mumayang'ana mtundu wa olekanitsa m'kalatayo.

   Pambuyo pochita zomwe mwachitazo, ngati detayo mu mawonekedwe omwe awonetsedwa pazenera pansi amawonetsedwa molondola, dinani Chabwino.



4. Zambiri zidzawonetsedwa bwino kudzera mu mawonekedwe otseguka.

Njira 4: Notete

Mutha kugwiritsa ntchito zolemba nthawi yokhazikika pokonza.

1. Thamangani Notepad. Mumenyu, dinani "Fayilo" ndi "Tsegulani ...". Kapena mutha kugwiritsa ntchito CTRL + O.



2. Zenera lotseguka limawonekera. Pitani kudera la CSV. Mu gawo lowonekera, khazikitsani "mafayilo onse". Lembani chinthu chomwe mukufuna. Kenako akanikizani "lotseguka".



3. Chomwe chikhala chotseguka, koma, sichoncho, osati mawonekedwe okoma, omwe tidawona mu tebulo la tebulo, ndipo m'mawu. Komabe, m'dongosolo limakhala labwino kwambiri kusintha zinthuzi. Ndikofunikira kuona kuti mzere uliwonse wa tebulo limafanana ndi chingwe cha lembalo mu kafukufuku, ndipo mizati imalekanitsidwa ndi osiyanika mu mawonekedwe a commas kapena ma coma. Popeza izi, ndizotheka kuthana ndi kusintha kulikonse, kutumizirana nkhani, kuwonjezera zingwe, kuchotsa kapena kuwonjezera kupatula komwe kuli kofunikira.

Njira 5: Notepadi ++

Mutha kutsegula ndikugwiritsa ntchito mkonzi wapamwamba kwambiri - Notepad ++.

1. Tembenuzani Notepad ++. Dinani pa menyu. Kenako, sankhani "Tsegulani ...". Mutha kugwiritsanso ntchito ctrl + o.

   

   Njira ina imaphatikizapo kukakamiza gululo paconi.



2. Zenera lotseguka limawonekera. Iyenera kusamukira kuderali la fayilo lomwe lafunkhidwa limakhala. Pambuyo posankha, kanikizani "lotseguka".



3. Zolemba zidzawonetsedwa ku Notepad ++. Mfundo za kusintha ndizofanana mukamagwiritsa ntchito kope, koma zosayimira + zimapereka zida zochuluka kwambiri pazowunikira zosiyanasiyana za data.

Njira 6: Safari

Onani zomwe zili mu mtundu wa mawu popanda kuthekera kuzisintha, mutha kulibe msakatuli. Asakatuli ena ambiri samapereka mwayi wotere.

1. Thamangani Safari. Dinani "Fayilo". Kenako dinani pa "fayilo yotseguka ...".



2. Zenera lotseguka limawonekera. Zimafunikira kusunthira kumalo komwe CSV ili, yomwe wogwiritsa ntchito akufuna kuona. Pakuvomerezera, kusintha kwa mawonekedwe pazenera kuyenera kukhazikitsidwa "mafayilo onse". Kenako pangani kusankha kwa chinthu chomwe chili ndi zowonjezera za CSV ndikudina wotseguka.



3. Zomwe zili patsamba lidzatsegulidwa pazenera latsopano la SFARI mu fomu, monga zinaliri mu kakalata. Zowona, mosiyana ndi noppad, Sinthani deta ku Safari, Tsoka ilo silidzagwira ntchito, monga momwe mungawonere.

Njira 7: Microsoft Outlook

Zinthu zina za CSV ndi maimelo omwe maimelo amatumizidwa kuchokera kwa makasitomala. Amatha kuwonedwa pogwiritsa ntchito pulogalamu ya Microsoft Outlook popanga njira yolowera.

1. Thamangani Outluk. Mukatsegula pulogalamuyi, pitani ku "fayilo" tabu. Kenako dinani lotseguka mu menyu. Kenako dinani "Inter".



2. "Mbuye wa" kutumiza kunja "kumayambitsidwa. Pa mndandanda wa zomwe zaperekedwa, sankhani "kutumiza kuchokera ku pulogalamu ina kapena fayilo". Dinani "Kenako".



3. Pawindo lotsatira, sankhani mtundu wa chinthu chogulitsa. Ngati tikufuna kulowetsa CSV, ndiye kuti muyenera kusankha njira ya "Kulekanitsidwa ndi Commake" udindo. Dinani "Kenako".



4. Pawindo lotsatira, kanikizani "kuwunika ...".



5. "Zithunzi zowonjezera" zikuwonekera. Ziyenera kupita kumalo komwe kalatayo mu mtundu wa CSV ili. Sonyezani chinthu ichi ndikudina "Chabwino".



6. Kubwerera mu "mbuye wa kuloza ndi kutumiza kunja" zenera. Monga mukuwonera, mu fayilo yolowera "dera, adilesiyi idawonjezedwa pamalo a CSV. Mu "magawo" block, makonda amatha kusiyidwa. Dinani "Kenako".



7. Ndiye muyenera awonetse kuti chikwatu mu bokosi la makalata amene inu mukufuna kulemba makalata kunja.



8. Zenera lotsatira amasonyeza dzina la kanthu kuti adzakhala anaphedwa ndi pulogalamu. Apa ndi wokwanira dinani "wokonzeka."



9. Pambuyo pake, kuona deta kunja, kusamuka kwa "Tumiza Kupeza" tabu. M'dera lateral wa mawonekedwe pulogalamu, kusankha chikwatu kumene kalatayo kunja. Ndiye, m'chigawo chapakati cha pulogalamuyi, mndandanda wa makalata fodayi adzaoneka. Kungodinanso pa kalata anakhumba kawiri ndi batani kumanzere mbewa.



10. Kalata kunja ku CSV chinthu adzatsegulidwa mu pulogalamuyi Outluk.

N'zoona Dziwani kuti njira imeneyi ikhoza anapezerapo onse zinthu CSV mtundu, koma zilembo amene dongosolo limafanana yeniyeni muyezo, ndicho, munali minda: mutu, malemba, sender adiresi, wolandira adiresi, etc.

Monga mukuonera, pali ndithu ochepa ndi mapulogalamu ndi zinthu lotseguka CSV. Monga ulamuliro, ndi bwino kuona nkhani owona choterechi mapurosesa tabular. Kusintha angathe kuchitidwa monga lemba mu akonzi malemba. Komanso, pali CSVs osiyana ndi dongosolo linalake limene apadera mapulogalamu ntchito, monga makasitomala positi.