Bude tsarin CSV

CSV (Wuraren tsaka-tsaki) fayilolin rubutu ne wanda aka tsara don nuna bayanan ƙungiyar. A wannan yanayin, an raba ginshiƙai ta hanyar waka da kuma waƙoƙin digiri. Gano wanda aikace-aikacen za ku iya buɗe wannan tsarin.

Shirye-shirye don aiki tare da CSV

A matsayinka na doka, ana amfani da masu sarrafa tebur don duba abubuwan CSV daidai, kuma za'a iya amfani da masu shirya rubutu don shirya su. Bari muyi zurfin bincike kan tsarin ayyukan yayin da shirye-shirye daban-daban suka bude irin wannan fayil din.

Hanyar 1: Microsoft Excel

Bari mu ga yadda za a gudanar da CSV a cikin sananniyar kalma ta processor word, wanda aka haɗa a cikin Microsoft Office suite.

1. Kaddamar da Excel. Je zuwa shafin Fayiloli.



2. Je zuwa wannan shafin, danna "Bude".

   

   Madadin waɗannan ayyuka, zaku iya amfani kai tsaye zuwa takardar Ctrl + O.

3. Wani taga ya bayyana "Bude daftarin aiki". Yi amfani da shi don kewaya zuwa inda CSV take. Tabbatar zaɓi daga jerin nau'ikan tsari Fayilolin rubutu ko "Duk fayiloli". In ba haka ba, tsarin da ake so kawai ba za a nuna shi ba. Sannan yiwa alama abin da aka bayar kuma latsa "Bude"hakan zai haifar "Jagora na matani".

Akwai wata hanyar zuwa "Jagora na matani".

1. Matsa zuwa ɓangaren "Bayanai". Danna abu "Daga rubutun"sanya shi a toshe "Samun bayanan waje".



2. Kayan aiki ya bayyana Shigo da Fayilolin rubutu. Iri ɗaya kamar yadda yake a cikin taga "Bude daftarin aiki", a nan kuna buƙatar zuwa yankin yankin na abu ɗin kuma yi masa alama. Ba kwa buƙatar zaɓar tsari, saboda lokacin amfani da wannan kayan aikin, abubuwa masu ɗauke da rubutu za a nuna su. Danna "Shigo".



3. Ya fara "Jagora na matani". A cikin tagarsa ta farko "Nuna tsarin data" saita maɓallin rediyo zuwa An ware. A yankin "Tsarin fayil" dole ne ya zama aya Unicode (UTF-8). Latsa "Gaba".



4. Yanzu ya zama dole don aiwatar da mataki mai mahimmanci, wanda akan daidaituwar allon bayanan zai dogara. An buƙata don nuna abin da daidai yake ɗayan mai keɓancewa: kalma ta kalma (;) ko wakafi (,). Gaskiyar ita ce a cikin ƙasashe daban-daban ana amfani da matakai daban-daban a wannan batun. Don haka, don rubutun Turanci, ana amfani da wakafi sau da yawa, kuma don rubutu-harshen Rasha, semicolon. Amma akwai banbancen yayin da aka yi amfani da masu raba baya. Kari akan haka, a lokuta marasa saukin, ana amfani da wasu haruffa azaman masu yanke hukunci, kamar layin wavy (~).

   Sabili da haka, mai amfani dole ne ya ƙayyade ko a wannan yanayin takamaiman halayen silan ne ko kuma alama ce ta yau da kullun. Zai iya yin wannan ta hanyar bincika rubutun da ya bayyana a yankin. "Sample bayanai parsing" kuma ya dogara da dabaru.

   

   Bayan mai amfani ya tantance wane hali ne mai raba gari a cikin kungiyar "Halin raba kayan shine" duba akwatin kusa da Semicolon ko Takaice. Za'a iya cire akwatunan daga sauran abubuwan. Sannan danna "Gaba".



5. Bayan haka, taga yana buɗewa a ciki, yana nuna takamaiman shafi a yankin "Sample bayanai parsing", zaku iya sanya shi tsari don ingantaccen bayyanar bayanin a cikin toshe Tsarin Bayanai na Shafi ta sauya maɓallin rediyo tsakanin waɗannan matsayi:
   • tsallake wata takarda;
   • matani
   • Kwanan Wata
   • na kowa.

   Bayan kammala magudin, latsa Anyi.



6. Wani taga yana fitowa yana tambaya inda daidai bayanan da za'a shigo da shi akan takardar. Ta sauya maɓallin rediyo, zaku iya yin wannan akan sabon abu ko takaddar takarda. A cikin maganar ta karshen, zaka iya kuma tantance ainihin wurin daidaitawa a cikin filin mai dacewa. Domin kar a shigar dasu da hannu, ya ishe sanya siginan kwamfuta a cikin wannan filin, sannan ka zabi kan takaddar da kwayar zata zama babbar hagu ta hagu na tsararren inda za'a kara bayanan. Bayan saita daidaitawar, danna "Ok".



7. An nuna abubuwan da ke cikin abin a kan takardar Excel.

Darasi: Yadda ake gudanar da CSV a cikin Excel

Hanyar 2: CalreOffice Calc

Wani processor mai aiki zai iya gudanar da CSV - Calc, wanda shine ɓangare na taron LibreOffice.

1. Kaddamar da LibreOffice. Danna "Bude fayil" ko amfani Ctrl + O.

   

   Hakanan zaka iya shiga cikin menu ta latsa Fayiloli da "Bude ...".

   

   Bugu da kari, ana bude shafin taga kai tsaye ta hanyar Kalmar gani. Don yin wannan, yayin da ke cikin LibreOffice Calc, danna kan gunkin babban fayil ko nau'in Ctrl + O.

   

   Wani zabin ya ƙunshi canjin madogara ta hanyar maki Fayiloli da "Bude ...".



2. Yin amfani da kowane ɗayan zaɓuɓɓuka masu yawa da aka lissafa zai haifar da taga "Bude". Matsar da shi zuwa wurin CSV, yi masa alama ka latsa "Bude".

   

   Amma zaka iya ma yin ba tare da bude taga ba "Bude". Don yin wannan, ja CSV waje "Mai bincike" a cikin LibreOffice.



3. Kayan aiki ya bayyana Shigo da rubutukasancewa analog "Malaman rubutu" a cikin Excel. Amfanin shine cewa a wannan yanayin ba dole ba ne ku matsa tsakanin windows daban-daban, ana aiwatar da saitunan shigo da kaya, tunda dukkanin sigogin da ake buƙata suna cikin taga ɗaya.

   Jeka kai tsaye zuwa rukunin saiti "Shigo". A yankin "Lullube bayanan" zabi darajar Unicode (UTF-8)idan ba haka ba ya nuna a wurin. A yankin "Harshe" zaɓi yaren rubutun. A yankin "Daga layin" kuna buƙatar tantance wane layi yakamata a fara shigo da abun cikin. A mafi yawan lokuta, wannan siga baya buƙatar canza shi.

   Na gaba, je zuwa rukuni Zaɓuɓɓuka daban. Da farko dai, kuna buƙatar saita maɓallin rediyo zuwa Mai rarrabewa. Furtherarin gaba, gwargwadon wannan ƙa'idar da aka yi la’akari da ita lokacin amfani da Excel, kuna buƙatar tantancewa, ta hanyar duba akwatin kusa da takamaiman abu, menene daidai zai taka rawar raba

   "Sauran zaɓuɓɓuka" bar canzawa.

   Kuna iya gani a gaba yadda ainihin bayanan da aka shigo da su suke yi lokacin da ake sauya wasu saiti, a ƙasan taga. Bayan shigar duk sigogi masu mahimmanci, latsa "Ok".



4. Za a nuna abun ciki ta hanyar LibreOffice Kalk interface.

Hanyar 3: OpenOffice Calc

Kuna iya duba CSV ta amfani da wani tebur na processor - OpenOffice Calc.

1. Kaddamar da OpenOffice. A cikin babban taga, danna "Bude ..." ko amfani Ctrl + O.

   

   Hakanan zaka iya amfani da menu. Don yin wannan, tafi cikin abubuwan Fayiloli da "Bude ...".

   

   Kamar yadda ke tare da hanyar da ta gabata shirin, zaku iya zuwa wajan buɗe taga kai tsaye ta hanyar wiwo Kalk. A wannan yanayin, kuna buƙatar danna kan gunki a cikin hoton babban fayil ɗin ko amfani da wannan Ctrl + O.

   

   Hakanan zaka iya amfani da menu ta zuwa wuraren da ke ciki. Fayiloli da "Bude ...".



2. A cikin taga buɗewa wanda ke bayyana, je zuwa yankin CSV, zaɓi wannan abun kuma danna "Bude".

   

   Kuna iya yin ba tare da ƙaddamar da wannan taga ba ta hanyar kawai zazzage CSV daga "Mai bincike" a cikin OpenOffice.



3. Duk ɗayan ayyukan da yawa da aka bayyana zai haifar da kunna aikin taga. Shigo da rubutu, wanda yake da kamannin biyu a bayyanar da kuma aiki zuwa kayan aiki mai suna iri ɗaya a cikin LibreOffice. Haka kuma, yi ainihin ayyukan. A cikin filayen "Lullube bayanan" da "Harshe" bijirar Unicode (UTF-8) da kuma harshen daftarin aiki na yanzu, bi da bi.

   A toshe Rarraba Mai rarrabewa saka maɓallin rediyo kusa da abun Mai rarrabewa, sannan duba akwatin kusa da (Semicolon ko Takaice) wanda ya dace da nau'in mai raba kayan a cikin takaddar.

   Bayan aiwatar da waɗannan matakan, idan bayanai a cikin samfotin da aka nuna a ƙasan taga an nuna su daidai, danna "Ok".



4. Za'a iya nuna bayanai cikin nasara ta hanyar keɓancewar OpenOffice Kalk.

Hanyar 4: Littafin rubutu

Don gyara, zaku iya amfani da notepad na yau da kullun.

1. Kaddamar da notepad. A cikin menu, danna Fayiloli da "Bude ...". Ko zaka iya amfani Ctrl + O.



2. Wani taga yana buɗewa. Shiga ciki zuwa yankin CSV. A cikin filin nuni, saita darajar "Duk fayiloli". Yi alama abin da kuke nema. Bayan haka latsa "Bude".



3. Za a buɗe abu ɗin, amma, ba shakka, ba a cikin tsarin ma'anar da muka lura a cikin masu sarrafa teburin ba, amma a matani ɗaya. Koyaya, a cikin littafin rubutu yana da matukar dacewa a gyara abubuwa na wannan tsari. Kuna buƙatar kawai la'akari da cewa kowane layi na tebur ya dace da layin rubutu a cikin Notepad, kuma an raba sassan sassan ta hanyar wakafi ko semicolons. Ba da wannan bayanin, zaka iya yin kowane gyare-gyare a wurina, ƙimar rubutu, ƙara layin, cire ko ƙara raba tsakanin inda ya cancanta.

Hanyar 5: Allon rubutu ++

Kuna iya buɗe shi tare da editan rubutu mafi tsayi - Notepad ++.

1. Kunna notepad ++. Danna kan menu Fayiloli. Zaɓi na gaba "Bude ...". Hakanan zaka iya amfani Ctrl + O.

   

   Wani zabin ya haɗa da danna kan gunkin allon a cikin babban fayil.



2. Wani taga yana buɗewa. Wajibi ne don matsawa zuwa yankin fayil ɗin fayil inda CSV ake so. Bayan zaba shi, latsa "Bude".



3. Abun ciki zai nuna a Notepad ++. Ka'idojin gyaran iri ɗaya daidai ne lokacin amfani da Notepad, amma Notepad ++ yana ba da kayan aikin da yawa don yawan amfani da bayanai.

Hanyar 6: Safari

Kuna iya duba abun ciki a cikin sigar rubutu ba tare da yiwuwar gyara shi a cikin binciken Safari ba. Yawancin sauran masanan binciken ba su bayar da wannan yanayin ba.

1. Kaddamar da Safari. Danna Fayiloli. Danna gaba "Bude fayil ...".



2. Da taga budewa ya bayyana. Yana buƙatar ƙaura zuwa wurin da CSV yake, wanda mai amfani yake so ya duba. Dole a canza tsarin tilas a cikin taga "Duk fayiloli". Sannan zaɓi abu tare da ɗimbin CSV kuma danna "Bude".



3. Abinda ke ciki na abu zai buɗe a cikin wani sabon taga Safari ta hanyar rubutu, kamar yadda yake a notepad. Gaskiya ne, sabanin Notepad, gyara bayanai a Safari, da rashin alheri, ba zaiyi aiki ba, tunda zaka iya duba shi kawai.

Hanyar 7: Microsoft Outlook

Wasu abubuwa na CSV sune imel da aka fitar daga abokin ciniki na imel. Ana iya duba su ta amfani da shirin Microsoft Outlook ta hanyar aiwatar da tsarin shigo da kaya.

1. Kaddamar da Outlook. Bayan buɗe shirin, je zuwa shafin Fayiloli. Sannan danna "Bude" a menu na gefen. Danna gaba "Shigo".



2. Ya fara "Shigo da fitarwa Wizard". A cikin jerin da aka gabatar, zaɓi "Shigo daga wani shirin ko fayil". Latsa "Gaba".



3. A taga na gaba, zaɓi nau'in kayan da za'a shigo. Idan za mu shigo da CSV, to lallai ne sai ka zabi wuri "Wajan Rarraba dabi'u (Windows)". Danna "Gaba".



4. A taga na gaba, danna "Yi bita ...".



5. Wani taga ya bayyana "Sanarwa". Ya kamata ya tafi wurin da wasikar take a cikin tsarin CSV. Yi wa wannan abun alama kuma danna "Ok".



6. Akwai dawowa ta taga "Shigo da fitarwa Wizards". Kamar yadda kake gani, a cikin yankin "Fayil don shigo da shi" An kara adreshin zuwa wurin da abu na CSV. A toshe "Zaɓuɓɓuka" Za'a iya barin saitunan azaman tsoho. Danna "Gaba".



7. Sannan kuna buƙatar yiwa alama alama a cikin akwatin saƙo inda kuke so ku sanya kayan da aka shigo da shi.



8. Na gaba taga yana nuna sunan aikin wanda shirin zai yi. Kawai danna nan Anyi.



9. Bayan haka, don duba bayanan da aka shigo da shi, je zuwa shafin "Ana aikawa da karba". A cikin yankin dubawa na shirin, zabi babban fayil inda aka shigo da sakon. Sannan a cikin tsakiyar shirin shirin jerin haruffa dake cikin wannan babban fayil zasu bayyana. Ya isa sau biyu danna kan wasiƙar da ake so tare da maɓallin linzamin kwamfuta na hagu.



10. Harafin da aka shigo da shi daga abu na CSV za'a bude shi a cikin shirin Outlook.

Gaskiya ne, yana da mahimmanci a lura cewa ta wannan hanyar zaka iya gudu da nisa daga duk abubuwan ƙira na CSV, amma haruffa kawai waɗanda tsarinsu ya dace da wasu daidaitattun abubuwa, waɗanda ke ɗauke da filaye: batun, rubutu, adireshin mai aikawa, adireshin mai karɓa, da dai sauransu.

Kamar yadda kake gani, akwai programsan shirye-shirye don buɗe abubuwa na CSV. A matsayinka na mai mulkin, ya fi kyau a kalli abubuwan da ke cikin irin waɗannan fayilolin a cikin masu sarrafa tebur. Ana iya gyara abu azaman rubutu a cikin masu shirya rubutu. Bugu da ƙari, akwai CSV daban tare da takamaiman tsari, wanda shirye-shirye na musamman ke aiki, alal misali, abokan ciniki na imel.