Buyela kwibhlog

Indlela Yokudala Ifayile ye-.CSV kwiNotepad

Jul 3, 20263 min read

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.

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.

Amanqaku anxulumeneyo