Ko ha faile CSV ko ha lau pē ia ʻoku mahino mo faingofua. ʻOku ʻuhinga eni ʻoku ʻikai ke ke fiemaʻu ai ʻa e Excel pe Google Sheets ke fakatupu ha taha. ʻOku fai ʻe he Notepad, pe ko ha notepad vave ʻi he initanetí, ʻa e ngāué ni ʻi ha ngaahi sitepu pē ʻe niʻihi.
Angaʻi hono Fakatupu ha Faile .CSV ʻi he Notepad
Jul 3, 20263 min read
Ko e hā ha faile CSV?
Ko e CSV ʻoku tuʻunga ia maʻá e Comma-Separated Values (Ngaahi Uike ʻoku Vahevahe ʻaki e Komá). ʻOku ne tauhi ʻa e fakamatala ʻi he ngaahi laine, pea ko e uike taki taha ʻi ha laine ʻoku vahevahe ia ʻaki ha koma. Ko e ngaahi polokalama laisiini, ngaahi tafaʻaki fakamatala, mo e ngaahi sikaliputa ʻoku nau lau kotoa pē ʻa e anga ko ení, ʻa ia ʻoku ne ʻai ia ke hoko ko ha taha ʻo e ngaahi founga angamaheni taha ke feʻaveʻaki fakamatala ai ʻi he vahaʻa ʻo e ngaahi meʻangāué.
Ko ha CSV faingofua ʻoku hange ko ení:
Name, Age, City
John,28, New York
Sara,24, London
Ko e laine taki taha ko ha laine ia. Ko e koma taki taha ʻoku fakaʻilongaʻi ai ha kolomu foʻou.
Sitepu ki he sitepu: Fakatupu ha faile CSV ʻi he Notepad
Sitepu 1: Fakaava ʻa e Notepad
Fakaava ʻa e Notepad ʻi ho komipiutá, pe fakaʻaongaʻi ha notepad taʻetotongi ʻi he initanetí kapau ʻoku ke fie tō ʻa e polokalama komipiutá.
Sitepu 2: Taki hoʻo ngaahi ʻuluʻi kolomú
Taki hoʻo ngaahi ʻuluʻi kolomú ʻi he ʻuluaki lainé, ʻo vahevahe ʻaki ʻa e ngaahi komá. Ko e fakatātaá:
Product, Price, Quantity
Sitepu 3: Tānaki hoʻo fakamatala
Tānaki mai ʻa e laine fakamatala taki taha ʻi ha laine foʻou, ʻo tauhi pē ʻa e fokotuʻutuʻu tatau mo hoʻo ngaahi ʻuluʻi kolomú.
Product, Price, Quantity
Laptop,850,5
Mouse,20,30
Keyboard,45,15
Sitepu 4: Tauhi ʻa e failé ʻaki ha fakalahi .csv
Falu ki he File, pea toki Save As. ʻI he lisi fakahifo "Save as type", fili ʻa e All Files. Fakingoa ho failé ʻaki ha fakalahi .csv, ko e fakatātaá inventory.csv. Kapau te ke tukuange ʻa e sitepuní ni, ʻoku tauhi ia ʻe he Notepad ko ha faile .txt, pea ʻe ʻikai ke lau ia ko ha laisiini.
Sitepu 5: Fakaava mo sivi ʻa e failé
Fakaava ʻa e faile ʻi he Excel, Google Sheets, pe ko ha polokalama laisiini pē ke fakapapauʻi ʻoku fetongi mo feʻunga ʻa e ngaahi kolomu mo e ngaahi laine ʻo hangē ko hoʻo ʻamanakí.
Ngaahi Hala Angamaheni Ke Fakaʻehiʻehi Meiate Ia
Ngaahi koma tānaki ʻi ha uike. Kapau ʻoku ʻi ai ha koma ʻi ha uike tonu, fakakau ʻi loto ʻi he fakaʻilonga lea ua, ʻo hangē ko e "New York, NY". Ka ʻikai ia ʻe vahevahe ia ki ha kolomu ʻe ua ʻi ha hala.
Ngaahi kolomu taʻe-fetuʻutaki. Ko e laine kotoa pe ʻoku fiemaʻu ke tatau ʻa e tokolahi ʻo e ngaahi uike mo e laine ʻuluʻi kolomú. Ko ha koma ʻoku mole ʻoku ne fakapuputuʻi ʻa e laine kotoa.
Fakalahi faile hala. Ko e tauhi ko e .txt kae ʻikai ko e .csv ʻoku ʻuhinga ia ʻe ʻikai ke fakaava totonu ia ʻe he ngaahi polokalama laisiini.
Ngaahi vahaʻa tānaki ʻi he hili ʻa e ngaahi komá. ʻOku lau ʻe he niʻihi ʻo e ngaahi meʻangāué ha vahaʻa ʻi he hili ʻa e koma ko ha konga ʻo e uiké. Tauhi maʻu ʻa e ngaahi komá ki he uike hono hoko kae ʻoua leva ke fiemaʻu ʻe hoʻo polokalama taumuʻá ha ngaahi vahaʻa.
Ngaahi faleʻi vave
Tauhi ha laine ʻe taha ʻi he laine kotoa. ʻOua naʻa vahevahe ha laine ʻi ha ngaahi laine ʻe ua.
Fakaʻaongaʻi ha laine ʻuluʻi kolomu koeʻuhí ke ʻiloʻi ʻe ha taha ʻoku fakaava ʻa e failé ʻa e ʻuhinga ʻo e kolomu kotoa pē.
Kapau ʻoku ke langa ha CSV lahi, hiki ia ʻi ha polokalama laisiini kimuʻa, pea toki tufa ki he CSV, kae ʻoua ʻe taipe ʻa e ngaahi laine ʻe teau ʻaki ho nima.
Kuo ʻosi ʻi ai ha fakamatala ʻi he Excel pea fiemaʻu ko e CSV, pe ko e tafaʻaki kehe? Fakaʻaongaʻi ha liliu CSV ki he Excel taʻetotongi kae ʻikai toe taipe kotoa.
Fakaʻosiʻosi
Ko ha faile CSV ʻoku ʻikai ko ha meʻa lahi ia ngata pe ʻi ha lau ʻoku vahevahe ʻaki e koma ʻoku tauhi mo e fakalahi totonu. ʻOku tokangaʻi ia ʻe he Notepad taʻe fiemaʻu ha polokalama fakalahi. Taipe hoʻo ngaahi ʻuluʻi kolomú, tānaki hoʻo ngaahi lainé, tauhi ia ko e .csv, pea kuo mateuteu ke fakaava ʻi ha faʻahinga meʻangāue laisiini pē.