Ifayile ye-CSV bubhalo olulula nje. Oku kuthetha ukuba awudingi i-Excel okanye i-Google Sheets ukuyila. I-Notepad, okanye i- notepad esheshayo ekwi-intanethi, iyayenza le nto ngamanyathelo ambalwa nje.
Indlela Yokudala Ifayile ye-.CSV kwiNotepad
Yintoni ifayile ye-CSV?
I-CSV imele i-Comma-Separated Values (Amaxabiso ahlula-hlulwe ngoKroqo). Igcina iinkcukacha ngendlela yemigca, apho ixabiso ngalinye kumgca lwahlulwe ngoKroqo. Iinkqubo zeespredishithi, oovimba beenkcukacha, kunye nezikripthi zonke ziyayifunda le fomat, eyenza ibe yenye yeendlela eziqhelekileyo zokuhambisa iinkcukacha phakathi kwezixhobo ezahlukeneyo.
I-CSV elula ikhankanywe apha ngezantsi:
Name, Age, City
John,28, New York
Sara,24, London
Umgca ngamunye ngumgca omi ngqo. Kroqo ngalinye liphawula ikholamu entsha.
Inyathelo ngenyathelo: Yenza ifayile ye-CSV kwiNotepad
Inyathelo 1: Vula iNotepad
Vula iNotepad kwikhompyutha yakho, okanye usebenzise mahala i-notepad esheshayo ekwi-intanethi ukuba ufuna ukutsiba usetyenziso lwekhompyutha.
Inyathelo 2: Chaza iintloko zekholamu yakho
Bhala iintloko zakho kumgca wokuqala, ohlulwe ngo-kroqo. Umzekelo:
Product, Price, Quantity
Inyathelo 3: Yongeza iinkcukacha zakho
Yongeza umgca ngamunye weenkcukacha kumgca omtsha, ugcine iododa efanayo neyeentloko zakho.
Product, Price, Quantity
Laptop,850,5
Mouse,20,30
Keyboard,45,15
Inyathelo 4: Gcina ifayile ngesijobelelo (extension) se-.csv
Yiya ku-File, uze ukhethe u-Save As. Kuluhlu oluhlayo "Save as type", khetha u-All Files. Nika ifayile yakho igama elinesijobelelo se-.csv, umzekelo inventory.csv. Ukuba uyalitsiba eli nyathelo, iNotepad iyayigcina njengefayile ye-.txt, kwaye ayiyi kufundwa njengespredishithi.
Inyathelo 5: Vula kwaye ujonge ifayile
Vula ifayile kwi-Excel, kwi-Google Sheets, okanye kuyo nayiphi na enye ispredishithi ukuqinisekisa ukuba iikholamu nemigca zilungelelene ngendlela obindilindele ngayo.
Impazamo eziqhelekileyo ekufuneka uziphephile
Ukroqo olongezelelweyo kwixabiso. Ukuba ixabiso ngokwalo linokroqo, lifake kwizibiyeli ezimbini ezingaphakathi, ezifana no-"New York, NY". Ngaphandle koko iya kwahlukana ibe ziikholamu ezimbini ngempazamo.
Iikholamu ezingahambelaniyo. Umgca ngamunye udinga inani elifanayo lamaxabiso njengomgca Wentloko. Ukroqo olushiyekileyo luphazamisa umgca ohlanganisiweyo uphela.
Isijobelelo sefayile esingachanekanga. Ukugcina njenge-.txt endaweni ye-.csv kuthetha ukuba izixhobo zeespredishithi aziyi kuyivula ngokuchanekileyo.
Izithuba ezingaphezulu emva kokroqo. Ezinye izixhobo zifunda isithuba esingemva kokroqo njengenxalenye yexabiso. Gcina ukroqo lufutshane kwixabiso elilandelayo ngaphandle kokuba isixhobo sakho ekujoliswe naso silindele izithuba.
Iingcebiso ezikhawulezayo
Gcina umgca omnye ngomgca. Sukwahlula umgca ube yimigca emibini.
Sebenzisa umgca wentloko ukuze nabani na ovula ifayile azazi ukuba kuthetha ukuthini ikholamu nganye.
Ukuba wakha i-CSV enkulu, yibhale kwispredishithi kuqala, uze uyithumele kwi-CSV, endaweni yokuchwetheza amakhulu emigca ngesandla.
Sele uneenkcukacha kwi-Excel kwaye uzidinga njenge-CSV, okanye ngendlela eyahlukileyo? Sebenzisa simahla isiguquli se-CSV ukuya kwi-Excel endaweni yokuchwetheza yonke into kwakhona.
Isiphelo
Ifayile ye-CSV ayiynto ngaphandle kwesicatshulwa esahlulwe ngo-kroqo esigcinwe ngesijobelelo esifanelekileyo. I-Notepad iyayiphatha ngaphandle kwesoftwe eyongezelelweyo. Chwetheza iintloko zakho, yongeza imigca yakho, uyigcine njenge-.csv, kwaye ilungele ukuvulwa kuyo nayiphi na isixhobo sespredishithi.