Indlela Yokudala Ifayela le-.CSV ku-Notepad

Ifayela le-CSV liyisiqephu sombhalo nje ojwayelekile. Lokho kusho ukuthi awudingi i-Excel noma i-Google Sheets ukuze udale elodwa. I-Notepad, noma i- notepad esheshayo ku-inthanethi, iyawenza lo msebenzi ngezinyathelo ezimbalwa nje.

Uyini umbhalo we-CSV?

I-CSV imele ama-Comma-Separated Values (Amanani Ahlukaniswe Ngamakholomu/Ngokukhomba). Igcina imidwebo yedatha emigqeni, lapho inani ngalinye emgqeni lihlukaniswa ngekhomba. Izinhlelo zokusebenza zamashethi (spreadsheets), imininingwane yolwazi (databases), nemibhalo yamakhodi konke kuyakwazi ukufunda le fomethi, okuyenza ibe moja yezindlela ezivame kakhulu zokuhambisa idatha phakathi kwamathuluzi ahlukene.

I-CSV elula ibukeka kanje:

Name, Age, City

John,28, New York

Sara,24, London

Ulayini ngamunye ungumugqa owodwa. Ikhomba ngalinye limakula ikholomu entsha.

Igceke negceke: Dala ifayela le-CSV ku-Notepad

Isinyathelo 1: Vula i-Notepad

Vula i-Notepad kukhompyutha yakho, noma usebenzise mahhala i-notepad esheshayo ku-inthanethi uma ufuna ukweqa ukusebenzisa uhlelo lwekhompyutha yakho.

Isinyathelo 2: Thayipha izihloko zamakholomu akho

Thayipha izihloko zakho emgqeni wokuqala, zihlukaniswe ngamakholomu. Isibonelo:

Product, Price, Quantity

Isinyathelo 3: Engeza idatha yakho

Engeza umugqa ngamunye wedatha emgqeni omusha, ugcine ukulandelana okufana nezihloko zakho.

Product, Price, Quantity

Laptop,850,5

Mouse,20,30

Keyboard,45,15

Isinyathelo 4: Gcina ifayela ngesandiso se-.csv

Yiya ku-File, bese ukhetha u-Save As. Ebhokisini elisuselwayo elithi "Save as type", khetha u-All Files. Nika ifayela lakho igama elinesandiso se-.csv, isibonelo inventory.csv. Uma weqa lesi sinyathelo, i-Notepad izoligcina njengefayela le-.txt, futhi ngeke lifundwe njengeshethi.

Isinyathelo 5: Vula futhi uhlole ifayela

Vula ifayela ku-Excel, ku-Google Sheets, noma kunoma yiluphi uhlelo lweshethi ukuze uqinisekise ukuthi amakholomu nemigqa kuhambisana ngendlela othembela ngayo.

Amaphutha Ajwayelekile Okufanele Awagweme

• Amakholomu angeziwe enanini. Uma inani uqobo liqukethe ikhomba, lifake phakathi kwezingcaphuno eziphindwe kabili, njengo-"New York, NY". Ngaphandle kwalokho lizohlukana libe amakholomu amabili ngephutha.

• Amakholomu angahambisani. Umugqa ngamunye udinga inani elifanayo lamanani njengomugqa wesihloko. Ikhomba elilahlekile lisiphula sonke isigqi somugqa.

• Isandiso sefayela esingalungile. Ukugcina njenge-.txt esikhundleni se-.csv kusho ukuthi izinhlelo zamashethi ngeke zilikhiphe kahle.

• Izikhala ezengeziwe ngemva kwamakhomba. Amanye amathuluzi afunda isikhala ngemva kwekhomba njengengxenye yenani. Gcina amakhomba esondelene nenani elilandelayo ngaphandle uma uhlelo lwakho oluhlosiwe lulindela izikhala.

Amathiphu Asheshayo

• Gcina umugqa owodwa ngomugqa ngamunye. Ungahlukanisi umugqa owodwa ube imigqa emibili.

  Sebenzisa umugqa wesihloko ukuze noma ubani ovula ifayela azi ukuthi ikholomu ngalinye lisho ukuthini.

• Uma wakha i-CSV enkulu, yibhale kuqala kuhlelo lweshethi, bese uyayikhiphela ku-CSV, esikhundleni sokuthayipha amakhulu emizila ngesandla.

• Ngabe usuvele unedatha ku-Excel futhi uyidinga njenge-CSV, noma ngendlela ephambene? Sebenzisa mahhala isiqondisi se-CSV kuya ku-Excel esikhundleni sokuthayipha kabusha konke.

Isiphetho

Ifayela le-CSV aliylutho ngaphandle kombhalo ohlukaniswe ngamakhomba ogcinwe ngesandiso esifanele. I-Notepad iyaliphatha ngaphandle kwanoma yiluphi uhlelo olwengeziwe. Thayipha izihloko zakho, engeza imigqa yakho, ligcine njenge-.csv, futhi sekulungele ukuvulwa kunoma yiliphi ithuluzi leshethi.