Tsis ntev los no, peb tau tham txog kev siv FILTER.XML muaj nuj nqi los import XML cov ntaub ntawv los ntawm Is Taws Nem - lub luag haujlwm tseem ceeb uas qhov haujlwm no, qhov tseeb, yog npaj. Raws li txoj kev, txawm li cas los xij, lwm qhov kev npaj txhij txog thiab kev siv zoo nkauj ntawm txoj haujlwm no tau tshwm sim - rau kev faib cov ntawv nplaum rau hauv cov hlwb sai.
Cia peb hais tias peb muaj ib kab ntawv zoo li no:
Tau kawg, kom yooj yim, kuv xav muab faib ua ke cais: tuam txhab npe, nroog, txoj kev, tsev. Koj tuaj yeem ua qhov no hauv ntau txoj hauv kev:
- siv Cov ntawv nyeem los ntawm kab los ntawm tab Cov ntaub ntawv (Cov ntaub ntawv - Cov ntawv nyeem rau kab) thiab mus peb kauj ruam Text parser. Tab sis yog tias cov ntaub ntawv hloov pauv tag kis, koj yuav tau rov ua tag nrho cov txheej txheem dua.
- Thawb cov ntaub ntawv no rau hauv Power Query thiab faib nws nyob ntawd, thiab tom qab ntawd muab nws rov qab rau hauv daim ntawv, thiab tom qab ntawd hloov cov lus nug thaum cov ntaub ntawv hloov pauv (uas yog qhov yooj yim dua lawm).
- Yog tias koj xav tau hloov kho ntawm yoov, ces koj tuaj yeem sau qee cov qauv yooj yim kom pom cov cim thiab rho tawm cov ntawv ntawm lawv.
Thiab koj tuaj yeem ua nws zoo nkauj dua thiab siv FILTER.XML muaj nuj nqi, tab sis nws yuav ua li cas rau nws?
FILTER.XML muaj nuj nqi tau txais raws li nws qhov kev sib cav thawj zaug XML code - cov ntawv sau nrog cov cim tshwj xeeb thiab cov cwj pwm, thiab tom qab ntawd txheeb xyuas nws rau hauv nws cov khoom, rho tawm cov ntaub ntawv fragments peb xav tau. XML code feem ntau zoo li no:
Hauv XML, txhua yam ntaub ntawv yuav tsum muab ntim rau hauv cov cim npe. Ib lub cim yog qee cov ntawv nyeem (hauv qhov piv txwv saum toj no nws yog tus thawj tswj hwm, lub npe, nyiaj tau los) nyob rau hauv lub kaum sab xis. Cov ntawv cim ib txwm tuaj ua khub - qhib thiab kaw (nrog tus lej ntxiv rau qhov pib).
FILTER.XML muaj nuj nqi tuaj yeem yooj yim tshem tawm cov ntsiab lus ntawm tag nrho cov cim npe peb xav tau, piv txwv li, cov npe ntawm txhua tus thawj tswj hwm, thiab (qhov tseem ceeb tshaj) tso saib lawv txhua lub sijhawm hauv ib daim ntawv teev npe. Yog li peb txoj haujlwm yog ntxiv cov cim npe rau cov ntawv nyeem, tig mus rau hauv XML code tsim nyog rau kev soj ntsuam tom qab los ntawm FILTER.XML muaj nuj nqi.
Yog tias peb coj thawj qhov chaw nyob ntawm peb daim ntawv teev npe ua piv txwv, ces peb yuav tsum tau tig nws mus rau hauv qhov kev tsim kho no:
Kuv hu lub ntiaj teb qhib thiab kaw tag nrho cov ntawv cim npe t, thiab tag framing txhua yam yog s., tab sis koj tuaj yeem siv lwm lub npe - nws tsis muaj teeb meem.
Yog tias peb tshem tawm indents thiab kab tawg los ntawm cov cai no - tag nrho, los ntawm txoj kev, xaiv tau thiab ntxiv tsuas yog kom pom tseeb, ces tag nrho cov no yuav tig mus rau hauv kab:
Thiab nws tuaj yeem tau yooj yim tau los ntawm qhov chaw nyob los ntawm kev hloov cov commas hauv nws nrog ob peb cim npe siv lub luag haujlwm RAWS LI (SIB NTAUS) thiab gluing nrog lub cim & thaum pib thiab xaus ntawm qhov qhib thiab kaw tags:
Txhawm rau nthuav dav qhov tshwm sim kab rov tav, peb siv tus qauv ua haujlwm TRANSP (HLOOV), qhwv peb cov qauv hauv nws:
Ib qho tseem ceeb ntawm qhov kev tsim tag nrho no yog tias nyob rau hauv qhov tshiab ntawm Office 2021 thiab Office 365 nrog kev txhawb nqa rau dynamic arrays, tsis muaj gestures tshwj xeeb yog xav tau rau kev nkag - tsuas yog nkag mus thiab nyem rau ntawm Sau - tus qauv nws tus kheej nyob ntawm cov xov tooj ntawm tes nws xav tau thiab txhua yam ua haujlwm nrog lub suab nrov. Nyob rau hauv cov versions dhau los, qhov twg tsis muaj dynamic arrays tseem, koj yuav tsum xub xaiv ib tug txaus tus naj npawb ntawm npliag hlwb ua ntej nkag mus rau lub mis (koj muaj peev xwm nrog ib tug margin), thiab tom qab tsim cov mis, nias lub keyboard shortcut. Ctrl+ua haujlwm+Saunkag mus rau nws raws li ib tug array formula.
Ib qho kev ua kom yuam kev zoo sib xws tuaj yeem siv thaum sib cais cov ntawv daig ua ke rau hauv ib lub xovtooj ntawm ib kab:
Qhov sib txawv ntawm qhov piv txwv yav dhau los yog tias tsis yog tus lej cim, ntawm no peb hloov qhov tsis pom Alt + Nkag mus rau kab ua cim, uas tuaj yeem teev nyob rau hauv cov qauv siv CHAR muaj nuj nqi nrog code 10.
- Cov subtleties ntawm kev ua hauj lwm nrog kab so (Alt + Enter) hauv Excel
- Faib cov ntawv los ntawm kab hauv Excel
- Hloov cov ntawv nrog SUBSTITUTE