Yuav Tsim Cov Ntaub Ntawv CSV Li Cas

Cov txheej txheem:

Yuav Tsim Cov Ntaub Ntawv CSV Li Cas
Yuav Tsim Cov Ntaub Ntawv CSV Li Cas

Video: Yuav Tsim Cov Ntaub Ntawv CSV Li Cas

Video: Yuav Tsim Cov Ntaub Ntawv CSV Li Cas
Video: yuav tau tsim kho tus kheej lub neej thiaj yuav vam meej tau 2024, Hlis ntuj nqeg
Anonim

Cov ntaub ntawv CSV yog tsim los khaws cov ntaub ntawv tabular ua hom ntawv ua kab ntawv. Txhawm rau qhib cov ntaub ntawv zoo li no, tsis muaj ib qho kev qhia tshwj xeeb rau kev ua haujlwm nrog lub rooj yog yuav tsum muaj; Cov hom ntawv no feem ntau siv ntau hom kev sau ntawv khaws cov ntaub ntawv me me.

Yuav tsim cov ntaub ntawv CSV li cas
Yuav tsim cov ntaub ntawv CSV li cas

Cov Lus Qhia

Kauj ruam 1

Siv cov ntawv sau uas yooj yim tshaj plaws (xws li Notepad) rau "sau" tsim cov ntaub ntawv CSV. Yog tias koj xav tau cov ntaub ntawv uas tsis muaj cov ntaub ntawv, tom qab ntawd tsuas khaws ib daim ntawv dawb xwb nrog csv txuas ntxiv - piv txwv li data.csv.

Kauj ruam 2

Cais cov ntsiab lus ntawm cov kab ntawv ntawm ib sab uas muaj daim ntawv nrog rau lub comma yog tias koj xav tau muab qee cov ntaub ntawv cov lus hauv cov ntawv. Lub npe heev ntawm hom ntawv no (CSV - Comma Separated Values) yog txhais los ntawm lus Askiv raws li "qhov tseem ceeb sib cais los ntawm commas". Txawm li cas los xij, nws yooj yim dua thiab yog li muaj ntau siv los cais qhov tseem ceeb nrog semicolons. Qhov no yog vim qhov tseeb tias nyob rau hauv feem ntau cov neeg tsis paub lus Askiv, nws yog kev coj los siv comma ua ib qho kev cais tawm ntawm cov zauv feem thiab feem ntawm cov zauv tiag.

Kauj ruam 3

Tso tsuas yog ib kab ntawm tabular cov ntaub ntawv ib kab hauv CSV cov ntaub ntawv. Ntawd yog, kab terminator yog kab cais rau lub rooj uas muaj cov ntawv zoo li no.

Kauj ruam 4

Siv daim ntawv teev kev nthuav dav sau yog tias koj tsis xav tsim cov ntaub ntawv CSV ntawm koj tus kheej. Feem ntau cov ntawv nthuav qhia muaj peev xwm nyeem thiab khaws cov ntaub ntawv hauv hom ntawv no. Piv txwv li, koj tuaj yeem siv daim ntawv thov chaw haujlwm Microsoft Excel 2007. Tom qab tsim (lossis qhib) lub rooj hauv nws uas koj xav khaws cia rau CSV cov ntaub ntawv, nyem qhov loj, puag ncig Lub Chaw Haujlwm khawm nyob rau sab saud sab laug ntawm cov khoos phis tawm. Hauv cov ntawv qhia zaub mov uas qhib, mus rau tshooj "Tseg raws li" thiab xaiv cov khoom hauv qab - "Lwm hom ntawv". Cov ntawv qhia zaub mov no tau muab rau "yuam sij kub" F12 - koj tuaj yeem siv nws.

Kauj ruam 5

Nthuav daim ntawv nco-down "Cov hom ntaub ntawv" thiab xaiv kab "CSV (comma delimited)". Tom qab ntawd hauv "Cov ntaub ntawv lub npe" teb, sau lub npe, xaiv qhov chaw khaws khoom thiab nyem lub pob "Txuag".

Kauj Ruam 6

Teb cov lus lees paub (OK thiab Yog khawm) rau cov lus nug Excel nug ob zaug ua ntej khaws cov ntaub ntawv. Nyob rau hauv txoj kev no, tus sau ntawv yuav ceeb toom tias CSV hom tsis txhawb nqa lub peev xwm los sau cov ntawv, siv "cov phau ntawv" thiab "nplooj ntawv", cov qauv hauv cov hlwb thiab lwm yam kev xaiv muaj nyob rau hauv hom ntawv ntawm hom ntawv sau no.

Pom zoo: