Kwanan nan, mun tattauna game da amfani da aikin FILTER.XML don shigo da bayanan XML daga Intanet - babban aikin da aka yi niyya don wannan aikin, a gaskiya,. A kan hanya, duk da haka, wani rashin zato kuma kyakkyawan amfani da wannan aikin ya bayyana - don rarraba rubutu mai ma'ana cikin sauri zuwa sel.
Bari mu ce muna da ginshiƙin bayanai kamar haka:
Tabbas, don dacewa, Ina so in raba shi zuwa ginshiƙai daban-daban: sunan kamfani, birni, titi, gida. Kuna iya yin wannan ta hanyoyi daban-daban:
- amfani Rubutu ta ginshiƙai daga tab data (Bayanai - Rubutu zuwa ginshiƙai) kuma tafi matakai uku Fassarar rubutu. Amma idan bayanan sun canza gobe, dole ne ku sake maimaita tsarin duka.
- Load da wannan bayanai zuwa Power Query kuma a raba su a can, sannan a mayar da su zuwa takardar, sannan sabunta tambayar idan bayanan sun canza (wanda ya riga ya fi sauƙi).
- Idan kuna buƙatar sabuntawa akan tashi, to zaku iya rubuta wasu dabaru masu rikitarwa don nemo waƙafi da fitar da rubutu a tsakanin su.
Kuma za ku iya yin shi da kyau kuma ku yi amfani da aikin FILTER.XML, amma menene ya yi da shi?
Ayyukan FILTER.XML yana karɓa azaman hujjarsa ta farko lambar XML - rubutun da aka yi masa alama tare da alamomi da halaye na musamman, sa'an nan kuma ya rarraba shi cikin sassansa, yana fitar da gutsuttsuran bayanan da muke buƙata. Lambar XML yawanci tana kama da wani abu kamar haka:
A cikin XML, kowane ɓangaren bayanai dole ne a haɗa shi cikin tags. Alama wani rubutu ne (a misalin da ke sama shi ne manaja, suna, riba) a ruɗe a cikin maƙallan kusurwa. Tags koyaushe suna zuwa nau'i-nau'i - buɗewa da rufewa (tare da slash ƙara zuwa farkon).
Ayyukan FILTER.XML na iya sauƙaƙe abubuwan da ke cikin duk tags ɗin da muke buƙata, misali, sunayen duk manajoji, da (mafi mahimmanci) nuna su gaba ɗaya a cikin jeri ɗaya. Don haka aikinmu shine ƙara tags zuwa rubutun tushe, juya shi zuwa lambar XML wanda ya dace da bincike na gaba ta aikin FILTER.XML.
Idan muka ɗauki adireshin farko daga jerinmu a matsayin misali, to muna buƙatar juya shi zuwa wannan ginin:
Na kira duniya buɗewa da rufe duk rubutu tag t, da tags da ke tsara kowane nau'in su ne s., amma zaka iya amfani da kowane nau'i - ba kome ba.
Idan muka cire indents da karya layi daga wannan lambar - gaba ɗaya, ta hanya, zaɓi na zaɓi kuma ƙara kawai don tsabta, to duk wannan zai juya zuwa layi:
Kuma ana iya samun sauƙin samu daga adireshin tushen ta hanyar maye gurbin waƙafi a ciki tare da tags biyu. amfani da aikin MUSA (MADAMA) da gluing tare da alamar & a farkon da ƙarshen buɗewa da rufewa tags:
Don fadada kewayon da aka samu a kwance, muna amfani da daidaitaccen aikin TRANSP (TSARKI), nannade tsarin mu a ciki:
Wani muhimmin fasalin wannan ƙirar gabaɗaya ita ce a cikin sabon sigar Office 2021 da Office 365 tare da goyan bayan tsararraki masu ƙarfi, ba a buƙatar karimci na musamman don shigarwa - kawai shigar da danna kan. Shigar - dabarar kanta tana ɗaukar adadin ƙwayoyin da take buƙata kuma duk abin da ke aiki tare da bang. A cikin nau'ikan da suka gabata, inda babu tsayayyen tsari tukuna, kuna buƙatar fara zaɓar isassun adadin sel marasa komai kafin shigar da dabarar (zaku iya tare da gefe), sannan bayan ƙirƙirar dabara, danna gajeriyar hanyar keyboard. Ctrl+Motsi+Shigardon shigar da shi azaman tsarin tsararru.
Ana iya amfani da irin wannan dabarar lokacin raba rubutu da aka makale tare cikin tantanin halitta guda ta hanyar karya layi:
Bambanci kawai tare da misalin da ya gabata shine cewa maimakon waƙafi, a nan muna maye gurbin alt + Shigar layin karya marar ganuwa, wanda za'a iya ƙayyade a cikin dabara ta amfani da aikin CHAR tare da lambar 10.
- Da dabara na aiki tare da layin karya (Alt + Shigar) a cikin Excel
- Raba rubutu da ginshiƙai a cikin Excel
- Maye gurbin rubutu da SUBSTITUTE