A wasu lokuta, mai amfani yana fuskantar aiki na dawowa wayar salula daga wasu kwayoyin a wasu adadin haruffa, farawa tare da alamar da aka nuna akan asusun hagu. Ayyukan yana aiki lafiya tare da wannan aiki. PSTR. Ayyukanta yana ƙara ƙarin idan ana amfani da wasu masu aiki a haɗa tare da shi, alal misali SEARCH ko Binciki. Bari mu dubi abin da ke cikin aikin. PSTR kuma ga yadda yake aiki tare da takamaiman misalai.
Yin amfani da PSTR
Babban aikin mai aiki PSTR shine cire daga takaddamaccen takaddun takardar takarda wasu adadin haruffa, ciki har da sarari, farawa da halayen da aka nuna a gefen hagu na alama. Wannan aikin yana cikin nau'in masu aiki da rubutu. Sakamakonsa kamar haka:
= PSTR (rubutu; initial_position; yawan adadin haruffa)
Kamar yadda kake gani, wannan ma'anar ta ƙunshi abubuwa uku. Ana buƙatar duk.
Magana "Rubutu" ya ƙunshi adreshin ɓangaren takaddun da ke dauke da rubutun kalmomin tare da haruffa da aka cire.
Magana "Farawa Matsayi" da aka gabatar a cikin nau'i na lamba, wanda ya nuna daga wace alama a kan asusu, fara daga hagu, yana da muhimmanci don cire. Nauyin farko yana ƙidaya kamar yadda "1"na biyu don "2" da sauransu Ko da sarari suna kidaya a lissafi.
Magana "Yawan haruffa" ya ƙunshi nau'in lambobi na yawan haruffa, farawa daga matsayin farko don a fitar da shi zuwa tantanin salula. Idan aka kwatanta haka kamar yadda aka yi a cikin gardamar da ta gabata, an dauki wurare a cikin asusu.
Misali 1: hakar hakar
Bayyana misalai na amfani da aikin. PSTR Bari mu fara tare da mafi sauƙi yayin da kake buƙatar cire wata kalma ɗaya. Hakika, irin waɗannan zaɓuɓɓuka a aikace suna da wuya a yi amfani da su, saboda haka zamu bada wannan misali kawai a matsayin gabatarwa ga ka'idojin aiki na mai aiki na musamman.
Don haka, muna da tebur na ma'aikata. Kashi na farko sun ƙunshi sunayen ma'aikatan. Muna buƙatar amfani da mai aiki PSTR cire kawai sunan mahaifi na mutum na farko daga jeri na Peter Ivanovich Nikolayev a cikin ƙayyadaddun tantanin halitta.
- Zaɓi madaurar takardar da za a iya cirewa. Danna maballin "Saka aiki"wanda yake kusa da wannan tsari.
- Wurin ya fara. Ma'aikata masu aiki. Je zuwa category "Rubutu". Zaɓi akwai suna "PSTR" kuma danna maballin "Ok".
- An kaddamar da matakan maganganu. "PSTR". Kamar yadda kake gani, a cikin wannan taga yawan filayen suna dace da adadin abubuwan da aka yi a cikin wannan aikin.
A cikin filin "Rubutu" shigar da haɗin wayar, wanda ya ƙunshi sunayen ma'aikata. Domin kada a fitar dashi a cikin adireshin da hannunka, kawai saita siginan kwamfuta a fagen kuma danna maballin hagu na hagu a kan kashi a kan takardar, wanda ya ƙunshi bayanan da muke bukata.
A cikin filin "Farawa Matsayi" Dole ne ku ƙayyade lambar alama, ƙidaya daga hagu, daga abin da sunan mai aiki ya fara. Har ila yau muna la'akari da wurare a yayin da muke kirgawa. Harafi "H", tare da wanda sunan marubucin na ma'aikaci Nikolaev ya fara, ita ce alama ta goma sha biyar. Saboda haka, a cikin filin sa lambar "15".
A cikin filin "Yawan haruffa" Dole ne ku ƙayyade adadin haruffan da suka ƙunshi sunan karshe. Ya ƙunshi haruffa takwas. Amma la'akari da cewa bayan sunan karshe babu wasu haruffa a tantanin halitta, zamu iya nuna mafi yawan haruffa. Wato, a cikin yanayinmu, za ka iya sanya kowane lambar da ke daidai da ko fiye da takwas. Mun sanya, alal misali, lambar "10". Amma idan bayan sunaye a cikin tantanin halitta akwai karin kalmomi, lambobi ko wasu haruffa, to, dole ne mu saita kawai adadin haruffa ("8").
Bayan an shigar da bayanai, danna kan maballin "Ok".
- Kamar yadda kake gani, bayan wannan aikin, sunan mai aiki ya nuna a cikin wanda aka nuna a mataki na farko. Misali 1 cell
Darasi: Maɓallin aiki na Excel
Misali 2: hakar haɗin gwiwar
Amma, ba shakka, don dalilai masu amfani, yana da sauƙi don shigar da sunan karshe guda da hannu tare da amfani da maƙallin don wannan. Amma don canja wurin ƙungiyar bayanai ta amfani da aikin zai kasance daidai.
Muna da jerin wayoyin wayoyin hannu. Kafin sunan kowane samfurin kalma ne "Smartphone". Muna buƙatar saka a cikin sashe daban-daban kawai sunayen sunayen ba tare da wannan kalma ba.
- Zaɓi nau'in ɓangaren ɓangaren da aka samo asali wanda za'a nuna sakamakon, sa'annan ya kira maƙallin bayanin mai aiki PSTR kamar yadda a cikin misali ta baya.
A cikin filin "Rubutu" saka adireshin farko na shafi tare da asalin asalin.
A cikin filin "Farawa Matsayi" muna buƙatar ƙayyade lambar alamar da za a fitar da bayanan. A halinmu, a kowane tantanin halitta kafin sunan samfurin shine kalmar "Smartphone" da sarari. Saboda haka, kalmar da kake so ka sanya a cikin ɗakin halitta dabam dabam yana farawa tare da nau'in hamsin. Saita lambar "10" a cikin wannan filin.
A cikin filin "Yawan haruffa" kana buƙatar saita yawan haruffan da ya ƙunshi kalmar da aka nuna. Kamar yadda kake gani, a cikin sunan kowane samfurori ne daban-daban adadin haruffa. Amma gaskiyar cewa bayan bayanan model, rubutun a cikin sel ƙare yana ajiye yanayin. Saboda haka, zamu iya saitawa a cikin wannan filin kowane lambar da ke daidai da ko mafi girma fiye da adadin haruffa a cikin mafi tsawo sunan a cikin wannan jerin. Saita yawan haruffan haruffa. "50". Sunan kowane irin wayoyin wayoyin da aka sanyawa ba ya wuce 50 characters, don haka wannan zabin ya dace mana.
Bayan an shigar da bayanai, danna kan maballin "Ok".
- Bayan haka, sunan samfurin farko na wayan basira yana nunawa a cikin tantanin tantanin tantanin halitta.
- Domin kada a shigar da takaddar a cikin kowane tantanin halitta na shafi na daban, zamu yi kwashe ta hanyar alamar cikawa. Don yin wannan, sanya siginan kwamfuta a cikin kusurwar dama na tantanin halitta tare da tsari. Mai siginan kwamfuta ya canza zuwa alamar cika a cikin hanyar ƙananan giciye. Kunna maɓallin linzamin hagu kuma ja shi zuwa ƙarshen shafi.
- Kamar yadda kake gani, gaba ɗaya bayanan za a cika da bayanan da muke bukata. Asiri shine cewa hujja "Rubutu" yana da dangantaka tsakanin dangi da kuma canzawa matsayin matsayi na ƙwayoyin salula.
- Amma matsalar ita ce idan muka yanke shawarar yanke shawarar canzawa ko share shafi tare da asalin asalin, ba a nuna cikakkun bayanai a cikin shafi ba, tun da yake suna da alaka da juna.
Domin "saki" sakamakon daga asalin asalin, muna yin magudi mai biyowa. Zaži shafi wanda ya ƙunshi tsari. Kusa, je shafin "Gida" kuma danna gunkin "Kwafi"located a cikin wani toshe "Rubutun allo" a kan tef.
A matsayi na dabam, za ka iya danna maɓallin haɗin bayan zaɓi Ctrl + C.
- Sa'an nan, ba tare da cire zaɓi ba, danna-dama a shafi. Yanayin mahallin ya buɗe. A cikin toshe "Zaɓuɓɓukan Zaɓuka" danna kan gunkin "Darajar".
- Bayan wannan, maimakon nau'i, ana saka dabi'un a cikin sashen da aka zaɓa. Yanzu zaka iya canzawa ko sauya asalin asali. Ba zai shafi sakamakon a kowace hanya ba.
Misali 3: amfani da haɗin masu aiki
Duk da haka, misalin da ke sama ya iyakance ne akan gaskiyar cewa kalmar farko a cikin dukkanin kwayoyin halitta dole ne a sami adadin haruffa. Yi amfani da aiki PSTR masu aiki SEARCH ko Binciki zai kara fadada yiwuwar amfani da tsari.
Masu amfani da rubutu SEARCH kuma Binciki ya dawo wurin halin da aka ƙayyade a cikin rubutun da ake gani.
Haɗin aiki SEARCH gaba:
= SEARCH (search_text; text_for_search; initial_position)
Mai amfani da haɗin gwiwar Binciki kama da wannan:
= Binciko (search_text; view_text; start_position)
By da kuma manyan, muhawarar waɗannan ayyuka guda biyu suna da kama. Babban bambanci shine cewa mai aiki SEARCH lokacin da bayanai ba su kula da lamarin haruffa ba, kuma Binciki - yana la'akari.
Bari mu ga yadda zaka yi amfani da mai aiki SEARCH haɗe da aiki PSTR. Muna da tebur wanda aka shigar da sunayen nau'o'in kayan aiki na kwamfuta tare da sunan sunaye. Kamar lokaci na ƙarshe, muna buƙatar mu dawo da sunan model ba tare da sunan jinsin. Matsalar ita ce idan a cikin misali na gaba da sunan jinsin ga kowane matsayi iri ɗaya ("smartphone"), to, a cikin wannan jerin yana da daban ("kwamfuta", "saka idanu", "masu magana", da dai sauransu) tare da lambobi daban-daban na haruffa. Don warware wannan matsala, muna buƙatar mai aiki SEARCHwanda muke gida a cikin aiki PSTR.
- Muna yin zaɓi na farkon tantanin halitta na shafi inda bayanan zai zama fitarwa, kuma a cikin hanyar da aka saba amfani da shi yana nuna maɓallin muhawarar aikin PSTR.
A cikin filin "Rubutu"kamar yadda muka saba, mun saka tantanin farko na shafi tare da asalin asali. Yana da cikakke.
- Amma darajar filin "Farawa Matsayi" za su tabbatar da hujjar cewa siffofin aikin SEARCH. Kamar yadda kake gani, duk bayanan da ke cikin jerin sun hada da gaskiyar cewa akwai sararin samaniya kafin sunan samfurin. Sabili da haka, mai aiki SEARCH za su nemo wuri na farko a cikin tantanin halitta na tashar mai mahimmanci kuma ya bada rahoton yawan wannan alama ta aiki PSTR.
Don buɗe maɓallin ƙwaƙwalwar mai aiki SEARCH, saita siginan kwamfuta a filin "Farawa Matsayi". Next, danna kan gunkin a cikin nau'i mai maƙalli, an tura shi zuwa ƙasa. Wannan icon yana samuwa a kan matakin da aka kwance na window inda aka kunna maballin. "Saka aiki" da kuma maɓallin tsari, amma zuwa hagu daga gare su. Jerin ayyukan aiki na ƙarshe ya buɗe. Tun da babu wani suna a cikinsu "SEARCH", sannan danna kan abu "Sauran fasali ...".
- Window yana buɗe Ma'aikata masu aiki. A cikin rukunin "Rubutu" zaɓi sunan "SEARCH" kuma danna maballin "Ok".
- Maƙallin bayanin mai aiki ya fara. SEARCH. Tun da muna neman wuri, to a filin "Sakamakon rubutu" sanya sarari ta wurin saita siginan kwamfuta a can kuma latsa maɓallin daidai akan keyboard.
A cikin filin "Sakamakon rubutu" saka haɗin zuwa haɗin farko na shafi tare da asalin asali. Wannan haɗin zai zama daidai da wanda muka nuna a fili a filin "Rubutu" a cikin ƙwaƙwalwar mai aiki PSTR.
Jagoran filin "Farawa Matsayi" ba da ake bukata ba. A cikin yanayinmu, ba lallai ba ne a cika shi, ko zaka iya saita lambar "1". Ga kowane daga cikin waɗannan zaɓuɓɓuka, za'a nema bincike daga farkon rubutun.
Bayan an shigar da bayanai, kada ku rush don danna maballin "Ok"a matsayin aikin SEARCH an gwada. Kawai danna sunan PSTR a cikin tsari.
- Bayan aiwatar da aiki na ƙarshe da aka ƙayyade, za mu koma ta atomatik a cikin sigina. PSTR. Kamar yadda ka gani, filin "Farawa Matsayi" riga ya cika da wannan tsari SEARCH. Amma wannan ma'anar tana nuna sarari, kuma muna buƙatar halin na gaba bayan sarari, daga abin da sunan samfurin ya fara. Saboda haka, zuwa bayanan data kasance a filin "Farawa Matsayi" mun gama magana "+1" ba tare da fadi ba.
A cikin filin "Yawan haruffa"kamar yadda a cikin misali ta baya, rubuta kowace lambar da ta fi girma ko kuma daidai da yawan haruffan a cikin mafi tsawo magana na asalin asalin. Misali, saka lambar "50". A cikin yanayinmu, wannan ya isa sosai.
Bayan duk takunkumin da aka ƙayyade, danna kan maballin "Ok" a kasan taga.
- Kamar yadda ka gani, bayan wannan, an nuna sunan model na'urar a cikin tantanin salula.
- Yanzu, ta amfani da Fill Wizard, kamar yadda a cikin hanyar da ta wuce, kwafa da samfurin zuwa sel da aka samo a ƙasa a cikin wannan shafi.
- Sunan dukkan nau'ikan na'urori suna nunawa a cikin kwayoyin da aka kama. Yanzu, idan ya cancanta, za ka iya karya mahada a cikin waɗannan abubuwa tare da ginshiƙin bayanan bayanan, kamar yadda ya faru a baya, ta hanyar yin amfani da kwaskwarima da fassarar dabi'u. Duk da haka, wannan aikin ba a koyaushe ake bukata ba.
Yanayi Binciki amfani dashi tare da tsari PSTR a kan wannan ka'ida kamar mai aiki SEARCH.
Kamar yadda kake gani, aikin PSTR Yana da kayan aiki mai mahimmanci don nuna bayanan da ake buƙata a cikin wayar da aka ƙayyade. Gaskiyar cewa ba haka ba ne a cikin masu amfani da shi yana nuna cewa masu amfani da yawa, ta amfani da Excel, suna ba da hankali ga ayyukan lissafi, maimakon rubutu. Lokacin amfani da wannan tsari a hade tare da wasu masu aiki, aikinsa yana ƙara ƙara.
