Shandisa basa rakajeka kuti ubvise nhamba dzisina kunyorwa dzinyorwa zvemakombiyuta dzakanyorwa kana kuendeswa mune pepa rekushandisa pamwe chete nemashoko akanaka.
Iyi kodeji yepasi-diki inowanzowanikwa pakutanga uye / kana kuguma kwemafaira e data.
Mamwe mienzaniso yakawanda yeiyo isiri iyo inonyatsotsanangurwa ndeyevanhu vanobatanidzwa pamwe nemashoko ari mu mienzaniso mumasero A2 neA6 mumufananidzo uri pamusoro.
Izvi zvinogona kukanganisa kushandisa dhidhi mumabasa ekushandura mapepa akadai sokudhinda, kusarudza, nekutsvaga deta.
Bvisa Zisina-Zvinyorwa ASCII uye Unicode Characters neCLEAN Function
Nhengo imwe neimwe pamakombiyuta - inonyorwa uye isina kudhindwa - ine nhamba inozivikanwa seyo Unicode character code kana kukosha.
Imwe, yakwegura, uye iri nani inonyatsozivikaniswa hutano ndiyo ASCII, iyo inomirira American Standard Code yeKushandurana kweNhau, yakabatanidzwa muUnicode set.
Somugumisiro, mazita 32 okutanga (0 kusvika ku31) eUnicode neAscII setsani akafanana uye anonzi mazita ekudzora mashandisirwo anoshandiswa nezvirongwa zvekugadzirisa zvigadzirwa zvepakita sevashanduri.
Sezvo zvakadaro, havakwanisi kushandiswa mune pepaji uye zvinogona kukonzera mhando dzekanganiso dzinotaurwa pamusoro apa kana dziripo.
Basa rakanaka, iro rinotungamira Unicode character set, rakagadzirirwa kubvisa mazita 32 ekutanga asina kushandura ASCII uye rinobvisa vanhu vakadaro kubva kuUnicode set.
Syntax Yakanakira Function uye Arguments
Mutsara webasa unoreva kurongeka kwebasa uye rinosanganisira zita rebasa, mabheji, uye nharo .
Mutsara weCLEAN work is:
= ZVINOKOSHA (Nyaya)
Mhemberero - (inodikanwa) data kucheneswa kwevasina kudhindwa. Sero rinotarisa panzvimbo ye data iyi mune pepa rekushanda.
Semuenzaniso, kuchenesa data muchitokisi A2 mumufananidzo uri pamusoro, pinda fomu:
= ZVINOKOSHA (A2)
mune imwe sero rebasa remashandi.
Kuchenesa Numeri
Kana yakashandiswa kuchenesa nhamba ye data, ICHIKANAKA basa, kunze kwekubvisa chero zvisizvo zvisati zvinyorwa, zvinoshandura nhamba dzose kuenda kune zvinyorwa-izvo zvingaguma nezvikanganiso kana iyo deta inoshandiswa pakuverenga.
Mienzaniso: Kubvisa Unhu Husina Kupihwa
Muchikamu cheA mumufananidzo, basa reCAR rave richishandiswa kuwedzera kusina-kudhinda mavara kumashoko emazwi sezvinoratidzwa mubhairi yepamusoro pane pepa rekushanda kwema cell A3 iyo inobva yabviswa neCLEAN basa.
Mutsamba B neC yemufananidzo wepamusoro, basa reEEN, iro rinoverenga nhamba yevanhu vari muchitokisi, rinoshandiswa kuratidza kushandiswa kwekushandisa basa rakanaka pane data iri mumutsara A.
Chimiro chinoverengera sero B2 chikamu che-7 - mavara mana nokuda kwemashoko emashoko uye zvitatu zvevasiri vanyori vanopoteredza.
Hunhu hunowanikwa muchitokisi C2 ndeye 4 nokuti basa rakanaka rakawedzerwa pamutemo uye rinobvisa zvitatu zvisati zvinyorwa kusati kwaitwa basa reLEN richiverenga vanhu.
Kubvisa Unhu # 129, # 141, # 143, # 144, uye # 157
Iyo Unicode character yakarongeka ine zvimwe zvisingashandisi zvinyorwa zvisingawanikwi muACC character set - nhamba 129, 141, 143, 144, uye 157.
Kunyange zvazvo webusaiti yekusimbisa ye Excel inoti haikwanise, basa rakanaka rinogona kubvisa mavara aya eUnicode kubva kune data sezvaratidzwa mumutsara wechitatu pamusoro apa.
Mumuenzaniso uyu, CHINHU chakakosha mumutsetse C chinoshandiswa kubvisa zvinhu zvishanu izvi zvisingaoneki kudzora maitiro achisiya zvakare chimiro chemavara mana chete emashoko ekuC3.
Kubvisa Unhu # 127
Pane imwe isiri-kudhinda inoitwa muUnicode yekuti CLEAN basa haigoni kubvisa - bhokisi-yakafanana nhamba # 127 inoratidzwa muchitokisi A4, uko mana evanhu ava vanokomberedza izwi.
Chimiro chemairi masere muchitsetse C4 chakangofanana neicho muchitokisi B4 uye nokuti CHIKANYE chinoshanda mu C4 chiri kuedza kusabudirira kubvisa # 127 pachako.
Zvisinei, sezvinoratidzwa mumitsara mitanhatu nematanhatu pamusoro apa, kune dzimwe nzira dzokushandisa kushandisa CHAR uye SUBSTITUTE mabasa anogona kushandiswa kubvisa unhu uyu:
- Nzira iri mumutsara wechishanu inoshandisa SUBSTITUTE uye CHAR kuti ishandure mutsairi # 127 nehutsika iyo HACHAITA basa rinogona kubvisa-munyaya ino, nhamba # 7 (iyo inonzi black dot inowanikwa muchitokisi A2);
- Nzira iri mumutsara mitanhatu inoshandisa SUBSTITUTE uye CHAR inoshandura kutora unhu # 127 isina chinhu sezvinoratidzwa nemabhuku asina zvinyorwa zvinyorwa ( "" ) pakuguma kwemufaira muchitokisi D6. Somugumisiro, basa rakanaka harina kudiwa mumutsetse, sezvo pasina chimiro chokubvisa.
Kubvisa Zvisiri-Kuputsa Mazhenje kubva Pashanduri
Zvakafanana nezvisiri izvo zvinyorwa zvinonyanya kushandiswa iyo isiri-break space iyo inogona kukonzera matambudziko nekuverenga uye kuomesa mune pepa rekushanda. Nhamba yeUnicode yekuti isiri-break space ndiyo # 160.
Nzvimbo dzisiri-kuputsa dzinoshandiswa zvakanyanya pamapeji ewebhu - html code yeyo & nbsp; - saka kana data yakadhindwa kuExcel kubva peji yewebhu, nzvimbo dzisiri dzekuputsa dzinogona kuiswa.
Imwe nzira yekubvisa kusaputsika kwemavara kubva pahwheti yepurogiramu iri neyuyu fomu inosanganisira SUBSTITUTE, CHAR, uye TRIM mabasa.