He kuputuhi noa iho te kōnae CSV. Ko te tikanga, kāore koe e hiahia ki a Excel, ki a Google Sheets rānei hei waihanga i tētahi. Mā te Notepad, tētahi notepad tuihono tere rānei, e oti ai i roto i ētahi taahiraa torutoru.
Me pēhea te Waihanga Kōnae .CSV ki Notepad
Jul 3, 20263 min read
He aha te kōnae CSV?
Ko te CSV te whakapoto mō te "Comma-Separated Values" (Ngā Uara e Whakawehea ana e te Piko). Ka pupuri raraunga ki ngā rarangi, ā, ka whakawehea ia uara i roto i te rarangi e te piko. Ka taea e ngā taupānga ripanga, ngā pātengi raraunga, me ngā hōtaka te pānui i tēnei hōputu, nā reira tētahi o ngā huarahi tino noa mō te nuku raraunga i waenga i ngā taputapu.
Anei te āhua o tētahi CSV māmā:
Ingoa, Tau, Tāone
John,28, New York
Sara,24, London
Ko ia raina he rarangi. Ko ia piko he tohu mō te poupou hou.
Taahiraa-ki-te-taahiraa: Waihanga kōnae CSV ki Notepad
Taahiraa 1: Whakatuwhera i te Notepad
Whakatuwheratia te Notepad i tō rorohiko, whakamahia rānei tētahi notepad tuihono koreutu mēnā e hiahia ana koe ki te karo i te taupānga papamahi.
Taahiraa 2: Patohia ō pane poupou
Patohia ō pane ki te raina tuatahi, whakawehea ai e ngā piko. Hei tauira:
Hua, Utu, Rahi
Taahiraa 3: Tāpirihia ō raraunga
Tāpirihia ia rarangi raraunga ki tētahi raina hou, kia mau tonu ki te raupapa o ō pane.
Hua, Utu, Rahi
Rorohiko,850,5
Kiore,20,30
Papapātuhi,45,15
Taahiraa 4: Tiakina te kōnae me te toronga .csv
Haere ki te Kōnae, kātahi ki te Tiaki Hei (Save As). I te takaiho "Tiaki hei momo" (Save as type), kōwhiria "Ngā Kōnae Katoa" (All Files). Whakaingoatia tō kōnae me te toronga .csv, hei tauira inventory.csv. Mēnā ka peke koe i tēnei taahiraa, ka tiakina e Notepad hei kōnae .txt, ā, kāore e pānuitia hei ripanga.
Taahiraa 5: Whakatuwhera me te tirotiro i te kōnae
Whakatuwheratia te kōnae i Excel, i a Google Sheets, i tētahi atu taupānga ripanga rānei kia mōhio ai e tika ana te hāngai o ngā poupou me ngā rarangi ki tāu e tūmanako ana.
Ngā Hapa Auau hei Karo
He piko tāpiri i roto i te uara. Mēnā kei roto i tētahi uara tētahi piko, takaihia ki ngā tohu kōrero rua, pēnei i te "New York, NY". Ki te kore, ka wehewehea ki ngā poupou e rua mā te hē.
Ngā poupou kore rite. Me ōrite te maha o ngā uara i ia rarangi ki tō te rarangi pane. Mā te piko e ngaro ana ka raru katoa te rarangi.
Toronga kōnae hē. Ko te tiaki hei .txt hei utu mō te .csv, ko te tikanga kāore e tika te whakatuwhera a ngā taupānga ripanga.
Ngā wāhi noa i muri i ngā piko. Ka pānui ētahi taputapu i te wāhi noa i muri i te piko hei wāhanga o te uara. Puritia ngā piko kia piri ki te uara e whai ake nei, hāunga mēnā e tūmanakohia ana e tō taputapu auau ētahi wāhi noa.
Ngā Tohutohu Tere
Puritia kia kotahi te rarangi ki ia raina. Kaua e wehewehea te rarangi kotahi ki ngā raina e rua.
Whakamahia tētahi rarangi pane kia mōhio ai te tangata e whakatuwhera ana i te kōnae he aha te tikanga o ia poupou.
Mēnā kei te hanga koe i tētahi CSV nui, tuhia ki tētahi taupānga ripanga i te tuatahi, kātahi ka kaweake ki te CSV, kaua i te patopato i ngā rau rarangi ā-ringa.
Kei a koe kē ngā raraunga i Excel, me huri hei CSV, tētahi atu huarahi rānei? Whakamahia tētahi kaitahuri CSV ki Excel koreutu hei utu mō te patopato anō i ngā mea katoa.
Whakamutunga
Ko te kōnae CSV he kuputuhi noa iho kua whakawehea e te piko, kua tiakina ki te toronga tika. Mā te Notepad e whakahaere me te kore rorohiko tāpiri. Patohia ō pane, tāpirihia ō rarangi, tiakina hei .csv, ā, kua reri ki te whakatuwhera i tētahi taputapu ripanga.