CSV (Lambobin da aka ƙayyade-ƙira) shi ne fayil ɗin rubutu wanda aka tsara domin nuna bayanan da ke cikin jerin. A wannan yanayin, ginshiƙai suna rabu da wani wakafi da kuma wani allon. Mun koya, tare da taimakon abin da aikace-aikace za ka iya buɗe wannan tsari.
Shirye-shirye na aiki tare da CSV
A matsayinka na mai mulki, ana amfani da na'urorin sarrafawa na layi don duba adreshin CSV da kyau, kuma ana iya amfani da editan rubutu don gyara su. Bari mu dubi algorithm na ayyuka yayin bude shirye-shirye daban-daban na wannan nau'in fayil ɗin.
Hanyar 1: Microsoft Excel
Yi la'akari da yadda za a gudanar da CSV a cikin mashawarcin mai amfani na Excel, wadda aka haɗa a cikin ɗakin Microsoft Office.
- Run Excel. Danna shafin "Fayil".
- Jeka wannan shafin, danna "Bude".
Maimakon waɗannan ayyuka, zaka iya amfani da kai tsaye akan takardar. Ctrl + O.
- A taga yana bayyana "Bayanin budewa". Yi amfani da shi don matsawa zuwa inda CSV ke samuwa. Tabbatar zaɓin daga jerin samfurori masu daraja "Fayilolin Fayilolin" ko "Duk fayiloli". In ba haka ba, tsarin da ake so ba a nuna ba. Sa'an nan kuma alama wannan abu kuma latsa "Bude"wannan zai haifar "Rubutun Jagora".
Akwai wata hanyar zuwa "Rubutun Jagora".
- Matsar zuwa sashe "Bayanan". Danna kan abu "Daga matanin"sanya a cikin wani toshe "Samun Bayanan waje".
- Kayan aiki yana bayyana "Shigo da Fayil ɗin Rubutun". Kamar dai a taga "Bayanin budewa", a nan kana buƙatar zuwa yankin na abu kuma alama. Babu buƙatar zaɓar tsari, tun lokacin amfani da wannan kayan aiki, abubuwa masu dauke da rubutu zasu nuna. Danna "Shigo da".
- Fara "Rubutun Jagora". A cikin ta farko taga "Saka tsarin tsarin bayanai" sanya maɓallin rediyo a matsayi "An ƙaddara". A cikin yankin "Tsarin fayil" Dole ne a zama saiti "Unicode (UTF-8)". Latsa ƙasa "Gaba".
- Yanzu kuna buƙatar yin wani mataki mai mahimmanci, wanda zai ƙayyade daidaiwar bayanan bayanan. Ana buƙatar saka ainihin abin da aka ɗauka a matsayin mai raba shi: semicolon (;) ko comma (,). Gaskiyar ita ce, a cikin ƙasashe daban-daban a cikin wannan shirin daban-daban ma'auni ana amfani. Saboda haka, ana amfani dashi mafi yawan amfani da rubutun Ingilishi, kuma ana amfani da maƙallan don amfani da harshen Turanci. Amma akwai wasu yayin da ake amfani da masu amfani da hanyoyi a hanya. Bugu da ƙari, a cikin wasu lokuta da yawa, wasu alamu suna amfani da su kamar masu rarrabe, misali, wata layi (~).
Sabili da haka, mai amfani da kansa ya kamata ya tabbatar ko a cikin wannan yanayin hali na musamman yana aiki a matsayin mai kyauta ko kuma alamar da aka saba. Zai iya yin wannan ta hanyar kallon rubutun da aka nuna a cikin "Samun bayanan samfurori" da kuma dogara ga ƙwarewa.
Bayan mai amfani ya ƙayyade wane hali ne mai rabawa, a cikin rukuni "Maganin kyawawan dabi'un" duba akwatin kusa da "Semicolon" ko "Kayan". Dole ne a rufe dukkan sauran abubuwa. Sa'an nan kuma latsa "Gaba".
- Bayan haka sai taga ta buɗe, inda, ta hanyar zabi wani shafi a yankin "Samun bayanan samfurori", za ka iya sanya shi a matsayin tsari don nuna cikakken bayani a cikin toshe "Harshen Bayanan Rukunin" ta hanyar sauya maɓallin rediyo tsakanin wurare masu zuwa:
- Kashe shafi;
- rubutu;
- kwanan wata;
- na kowa
Bayan yin manipulation, latsa "Anyi".
- Fila yana nuna tambayar inda za'a shigo da bayanan da aka shigo da takardar. Ta hanyar sauya maɓallin rediyo, zaka iya yin wannan a kan sabon takaddun da aka samo. A wannan yanayin, zaku iya ƙayyade ainihin ƙayyadaddun wurin wuri a filin daidai. Domin kada a shigar da su da hannu, ya isa ya sanya siginan kwamfuta a cikin wannan filin, sa'an nan kuma zaɓi a kan takardar tantanin halitta wanda zai zama babban hagu na sama na tsararren inda za'a kara bayanai. Bayan kafa saitunan, latsa "Ok".
- An ƙunshi abun ciki na abu a kan takardar Excel.
Darasi: Yadda za a gudu CSV a Excel
Hanyar 2: LibreOffice Calc
CSV kuma zai iya tafiyar da wani na'ura mai mahimmanci, Calc, wanda aka haɗa a cikin Ƙungiyar LibreOffice.
- Kaddamar da FreeOffice. Danna "Buga fayil" ko amfani Ctrl + O.
Zaka kuma iya kewaya ta hanyar menu ta latsa "Fayil" kuma "Bude ...".
Bugu da ƙari, za a iya samun dama ga bude taga ta hanyar hanyar Calc. Don yin wannan, yayin da a cikin LibreOffice Calc, danna kan gunkin a matsayin babban fayil ko nau'in Ctrl + O.
Wani zaɓi shine don shiga cikin maki "Fayil" kuma "Bude ...".
- Amfani da kowane zaɓin da aka zaɓa zai haifar da wata taga "Bude". Matsar da shi zuwa wurin wurin CSV, kalli shi kuma danna "Bude".
Amma zaka iya yin ba tare da yada taga ba "Bude". Don yin wannan, ja da CSV daga "Duba" a LibreOffice.
- Kayan aiki yana bayyana "Shigar da Rubutu"kasance analog Gizon Wuta in Excel. Amfani shine cewa a cikin wannan yanayin ba lallai ba ne don motsawa tsakanin windows daban-daban, yin saitunan shigarwa, tun da dukkan sigogin da aka buƙata suna cikin ɗaya taga.
Je kai tsaye zuwa rukunin saiti "Shigo da". A cikin yankin "Ciki" zabi darajar "Unicode (UTF-8)"idan ya nuna in ba haka ba. A cikin yankin "Harshe" zaɓi harshen rubutu. A cikin yankin "Daga layin" kana buƙatar saka wane layi don fara sayo abun ciki. A mafi yawan lokuta, ba ku buƙatar yin canji zuwa wannan saiti.
Kusa, je zuwa rukuni "Zaɓin Zaɓuɓɓuka". Da farko, kana buƙatar saita maɓallin rediyo zuwa matsayi "Yanki". Bugu da ari, bisa ga ka'idar da aka yi la'akari da lokacin amfani da Excel, kana buƙatar sakawa ta hanyar duba akwati a gaban wani abu na ainihi abin da zai dace da rawar mai rabawa: semicolon ko wakafi.
"Sauran zabin" bar canzawa.
Kuna iya gani a gabanin yadda yadda bayanin da aka shigo ya dubi lokacin canza wasu saituna a kasan taga. Bayan shigar da dukkan sigogin da ake bukata, latsa "Ok".
- Abubuwan ciki za a nuna su ta hanyar Siyarwa na LibreOffice Calc.
Hanyar 3: OpenOffice Calc
Zaka iya duba CSV ta amfani da sauran na'ura mai sarrafawa - OpenOffice Calc.
- Run OpenOffice. A babban taga, danna "Bude ..." ko amfani Ctrl + O.
Hakanan zaka iya amfani da menu. Don yin wannan, tafi ta wurin maki "Fayil" kuma "Bude ...".
Kamar yadda hanya tare da shirin da aka rigaya, za ka iya samun hanyar buɗewa ta bude ta hanyar kallon Kalk. A wannan yanayin, kana buƙatar danna kan gunkin a cikin hoton babban fayil ko amfani da duk guda ɗaya Ctrl + O.
Hakanan zaka iya amfani da menu ta hanyar kewaya ta abubuwan. "Fayil" kuma "Bude ...".
- A bude taga da ya bayyana, je zuwa wurin sakawa na CSV, zaɓi wannan abu kuma danna "Bude".
Kuna iya yin ba tare da kaddamar da wannan taga ba ta hanyar jawo CSV daga "Duba" in OpenOffice.
- Duk wani daga cikin ayyukan da aka bayyana zai kunna taga. "Shigar da Rubutu"wanda yake kama da juna a bayyanar da aiki a kayan aiki tare da wannan sunan a LibreOffice. Saboda haka, ayyukan suna daidai daidai. A cikin filayen "Ciki" kuma "Harshe" bayyana "Unicode (UTF-8)" da kuma harshen wannan littafin na yanzu.
A cikin toshe "Siffofin Jeri" sanya maɓallin rediyo kusa da abu "Yanki", to, duba akwatin cewa abu ("Semicolon" ko "Kayan"), wanda ya dace da irin nau'in delimiter a cikin takardun.
Bayan yin ayyukan da aka nuna, idan bayanan da aka nuna a cikin ɓangaren ƙananan window ya nuna daidai, danna "Ok".
- Za a samu bayanan da aka nuna ta hanyar OpenOffice Calc.
Hanyar 4: Binciken
Don gyarawa, zaka iya amfani da Ƙididdiga na yau da kullum.
- Fara Fara rubutu. Danna kan menu "Fayil" kuma "Bude ...". Ko zaka iya amfani Ctrl + O.
- Gidan bude yana bayyana. Nuna shi zuwa wurin wurin na CSV. A cikin yanayin nuni, saita darajar "Duk fayiloli". Alamar abun da ake so. Sa'an nan kuma latsa "Bude".
- Za a bude abu, amma, ba shakka, ba a cikin wata takarda ba, wanda muka lura a cikin na'urorin sarrafawa, amma a cikin rubutu. Duk da haka, a cikin littafin rubutu yana da matukar dace don gyara abubuwa na wannan tsari. Kuna buƙatar la'akari da cewa kowane jeri na tebur ya dace da layin rubutun a cikin Notepad, kuma an raba ginshiƙai ta tarho ko ɓangaren rabawa. Idan aka ba wannan bayani, zaka iya yin gyare-gyaren, sauƙaƙe ni, ƙara layi, cirewa ko ƙara masu rarraba idan ya cancanta.
Hanyar 5: Notepad ++
Za ka iya buɗe shi tare da taimakon mai yin amfani da rubutu na cigaba - Notepad ++.
- Kunna Notepad ++. Danna kan menu "Fayil". Kusa, zabi "Bude ...". Zaka kuma iya amfani da shi Ctrl + O.
Wani zaɓi ya hada da danna gunkin panel a cikin babban fayil.
- Gidan bude yana bayyana. Wajibi ne don motsawa zuwa yankin fayil ɗin inda CSV da aka so. Bayan zaɓar shi, latsa "Bude".
- An nuna abun ciki a Notepad ++. Ka'idodin gyare-gyare iri ɗaya ne da Notepad, amma Notepad ++ yana samar da kayan aiki da yawa da yawa don manipan bayanai.
Hanyar 6: Safari
Zaka iya duba abun ciki a cikin wani rubutu ba tare da yiwuwar gyara shi ba a cikin mai bincike na Safari. Yawancin masu bincike basu san wannan ba.
- Kaddamar da Safari. Danna "Fayil". Kusa, danna kan "Bude fayil ...".
- An bude taga ya bayyana. Yana buƙatar motsi zuwa wurin da CSV ke samuwa, wanda mai amfani yana so ya duba. Dole ne a canza yanayin cikin taga zuwa "Duk fayiloli". Sa'an nan kuma zaɓi abu tare da tsawo CSV kuma latsa "Bude".
- Abin da ke ciki na abu zai bude a cikin sabon Safari taga a cikin takarda, kamar yadda yake cikin Notepad. Gaskiya, sabanin Notepad, gyara bayanai a Safari, rashin alheri, bazai aiki ba, tun da zaka iya duba shi kawai.
Hanyar 7: Microsoft Outlook
Wasu abubuwa CSV suna imel da aka fitar daga imel na imel. Ana iya ganin su ta amfani da Microsoft Outlook ta yin amfani da hanyar shigarwa.
- Kaddamar da Outluk. Bayan bude shirin, je shafin "Fayil". Sa'an nan kuma danna "Bude" a cikin labarun gefe. Kusa, danna "Shigo da".
- Fara "Mai shigowa da fitarwa". A cikin jerin gabatarwa zaɓi "Shigo daga wani shirin ko fayil". Latsa ƙasa "Gaba".
- A cikin taga mai zuwa, zaɓi nau'in abu don shigo. Idan za mu shigo da CSV, to muna buƙatar zaɓar matsayi "Matsayin da aka ƙayyade (Windows)". Danna "Gaba".
- A cikin taga mai zuwa, danna "Review ...".
- A taga yana bayyana "Review". Ya kamata ya je wurin da wasikar yake a cikin tsarin CSV. Alamar wannan abu kuma latsa "Ok".
- Komawa zuwa taga "Masu shigowa da fitarwa". Kamar yadda kake gani a yankin "Fayil don shigowa" An ƙara adireshin zuwa wurin wurin CSV abu. A cikin toshe "Zabuka" Za'a iya barin saituna azaman tsoho. Danna "Gaba".
- Sa'an nan kuma akwai buƙatar ka yi alama da babban fayil a akwatin gidan waya inda kake so ka sanya takardun da aka shigo.
- Wurin da ke gaba ya nuna sunan aikin da za a yi ta shirin. Ya isa ya danna "Anyi".
- Bayan haka, don duba bayanan da aka shigo, kewaya zuwa shafin "Aika da karbar". A gefen gefen shirin, zaɓi babban fayil inda aka shigo da wasika. Sa'an nan kuma a tsakiyar ɓangaren shirin zai bayyana jerin haruffan dake cikin wannan babban fayil. Ya isa ya danna sau biyu a harafin da ake so tare da maɓallin linzamin hagu.
- Harafin da aka shigo daga kayan CSV za a bude a cikin shirin Outluk.
Ya kamata a lura, duk da haka, ba dukan abubuwa a cikin tsarin CSV ba za a iya gudana ta wannan hanyar, amma haruffa kawai wanda tsarin ya hadu da wani takamammen ƙira, wato, dauke da filayen: batun, rubutu, adireshin mai aikawa, adireshin mai karɓa, da dai sauransu.
Kamar yadda ka gani, akwai wasu shirye-shirye don bude samfurori na CSV. A matsayinka na mai mulki, ya fi dacewa don duba abubuwan da ke cikin fayiloli ɗin a cikin masu sarrafawa na layi. Za'a iya yin gyare-gyare azaman rubutu a cikin masu gyara rubutu. Bugu da kari, akwai CSV dabam dabam tare da wani tsari, wanda ke aiki tare da shirye-shirye na musamman, kamar email abokan ciniki.
