{"id":7499,"date":"2025-01-24T09:00:10","date_gmt":"2025-01-24T09:00:10","guid":{"rendered":"https:\/\/howtogeek.blog\/lv\/?p=7499"},"modified":"2025-01-24T09:00:10","modified_gmt":"2025-01-24T09:00:10","slug":"a-comprehensive-guide-to-using-regex-functions-in-excel","status":"publish","type":"post","link":"https:\/\/howtogeek.blog\/lv\/a-comprehensive-guide-to-using-regex-functions-in-excel\/","title":{"rendered":"Visaptvero\u0161a rokasgr\u0101mata REGEX funkciju izmanto\u0161anai programm\u0101 Excel"},"content":{"rendered":"<p>2024.\u00a0gad\u0101 Microsoft uzlaboja Excel iesp\u0113jas, ievie\u0161ot tr\u012bs jaud\u012bgas funkcijas, kuru centr\u0101 ir regul\u0101r\u0101s izteiksmes (REGEX). \u0160\u012bs funkcijas, proti, REGEXTEST, REGEXEXTRACT un REGEXREPLACE, sniedz lietot\u0101jiem iesp\u0113ju efekt\u012bvi identific\u0113t, ieg\u016bt un aizst\u0101t sare\u017e\u0123\u012btus datu mode\u013cus. Tie ir pieejami Excel t\u012bmek\u013ca versij\u0101 un Microsoft\u00a0365, iev\u0113rojami uzlabojot datu manipul\u0101cijas lietot\u0101jiem.<\/p>\n<h2 id=\"introduction-to-regex\">Izpratne par REGEX funkcij\u0101m programm\u0101 Excel<\/h2>\n<p>Regul\u0101r\u0101s izteiksmes ir rakstz\u012bmju sec\u012bbas, kas veido mekl\u0113\u0161anas modeli, atvieglojot detaliz\u0113tu datu anal\u012bzi. \u0160\u012bs funkcijas p\u0101rveido to, k\u0101 Excel lietot\u0101ji mijiedarbojas ar sav\u0101m datu kop\u0101m, padarot t\u0101dus uzdevumus k\u0101 datu valid\u0101cija, ieguve un modific\u0113\u0161ana vienk\u0101r\u0161\u0101kus un intuit\u012bv\u0101kus.<\/p>\n<h2 id=\"using-the-regextest-function\">Funkcijas REGEXTEST izmanto\u0161ana<\/h2>\n<p>Funkcija REGEXTEST nosaka, vai teksta da\u013c\u0101 ir nor\u0101d\u012bts raksts, radot izvadi TRUE vai FALSE. Funkcijas sintakse ir <code>REGEXTEST(value, pattern, [case_sensitive])<\/code>. \u0160eit <code>value<\/code>ir nor\u0101d\u012bts test\u0113\u0161anas m\u0113r\u0137a teksts, <code>pattern<\/code>tiek mekl\u0113ts REGEX modelis, un re\u0123istrjut\u012bgais parametrs nav oblig\u0101ts.<\/p>\n<ul>\n<li>Piem\u0113ram, analiz\u0113sim Excel lapu, kur\u0101 ir produkta vai konta kodi.<\/li>\n<\/ul>\n<figure class=\"wp-block-image\"><img alt=\"Produktu kodu piem\u0113rs\" class=\"wp-image\" decoding=\"async\" height=\"456\" loading=\"lazy\" src=\"https:\/\/cdn.howtogeek.blog\/wp-content\/uploads\/2025\/01\/image-437-1.webp\" title=\"Produktu kodu piem\u0113rs\" width=\"811\"\/><\/figure>\n<ul>\n<li>Lai p\u0101rbaud\u012btu, vai kod\u0101 ir iek\u013cauti cipari, noklik\u0161\u0137iniet uz \u0161\u016bnas C4 un ievadiet: <code>=REGEXTEST(A4, \"[0-9]\")<\/code>.<\/li>\n<\/ul>\n<figure class=\"wp-block-image\"><img alt=\"Ievade \u0161\u016bn\u0101 C4 REGEXTEST\" class=\"wp-image\" decoding=\"async\" height=\"446\" loading=\"lazy\" src=\"https:\/\/cdn.howtogeek.blog\/wp-content\/uploads\/2025\/01\/image-438-1.webp\" title=\"Ievade \u0161\u016bn\u0101 C4 REGEXTEST\" width=\"792\"\/><\/figure>\n<ul>\n<li>Ja kod\u0101 ir k\u0101di cipari, izvade par\u0101d\u012bs \u201cTRUE\u201d.<\/li>\n<\/ul>\n<figure class=\"wp-block-image\"><img alt=\"REGEXTEST TRUE izvade\" class=\"wp-image\" decoding=\"async\" height=\"476\" loading=\"lazy\" src=\"https:\/\/cdn.howtogeek.blog\/wp-content\/uploads\/2025\/01\/image-439-1.webp\" title=\"REGEXTEST TRUE izvade\" width=\"846\"\/><\/figure>\n<ul>\n<li>Lai to atk\u0101rtotu cit\u0101s \u0161\u016bn\u0101s, satveriet aizpild\u012b\u0161anas turi formulas \u0161\u016bnas st\u016br\u012b un velciet to uz leju, lai autom\u0101tiski aizpild\u012btu blakus eso\u0161\u0101s \u0161\u016bnas.<\/li>\n<\/ul>\n<figure class=\"wp-block-image\"><img alt=\"Formulas vilk\u0161ana uz leju, lai aizpild\u012btu \u0161\u016bnas\" class=\"wp-image\" decoding=\"async\" height=\"430\" loading=\"lazy\" src=\"https:\/\/cdn.howtogeek.blog\/wp-content\/uploads\/2025\/01\/image-440-1.webp\" title=\"Formulas vilk\u0161ana uz leju, lai aizpild\u012btu \u0161\u016bnas\" width=\"764\"\/><\/figure>\n<ul>\n<li>Lai p\u0101rbaud\u012btu t\u0101lru\u0146a numurus, izmantojiet: <code>=REGEXTEST(A4, \"\\(?\\d{3}\\)?[-.\\s]?\\d{4}\")<\/code>.<\/li>\n<\/ul>\n<figure class=\"wp-block-image\"><img alt=\"REGEXTEST t\u0101lru\u0146a numuriem\" class=\"wp-image\" decoding=\"async\" height=\"478\" loading=\"lazy\" src=\"https:\/\/cdn.howtogeek.blog\/wp-content\/uploads\/2025\/01\/image-443-1.webp\" title=\"REGEXTEST t\u0101lru\u0146a numuriem\" width=\"849\"\/><\/figure>\n<ul>\n<li>T\u0101pat k\u0101 iepriek\u0161, velciet rokturi, lai lietotu papildu \u0161\u016bnas.<\/li>\n<\/ul>\n<figure class=\"wp-block-image\"><img alt=\"Vilk\u0161anas opcija t\u0101lru\u0146a numura p\u0101rbaudei\" class=\"wp-image\" decoding=\"async\" height=\"455\" loading=\"lazy\" src=\"https:\/\/cdn.howtogeek.blog\/wp-content\/uploads\/2025\/01\/image-444-1.webp\" title=\"Vilk\u0161anas opcija t\u0101lru\u0146a numura p\u0101rbaudei\" width=\"809\"\/><\/figure>\n<h2 id=\"using-the-regexextract-function\">Teksta izvilk\u0161ana, izmantojot REGEXEXTRACT<\/h2>\n<p>Funkcija REGEXEXTRACT specializ\u0113jas noteiktu teksta segmentu izvilk\u0161an\u0101 no noteiktas v\u0113rt\u012bbas. T\u0101s sintakse ir <code>REGEXEXTRACT(value, pattern, [first_match], [all_matches], [case_sensitive])<\/code>. \u0160eit j\u016bs nor\u0101d\u0101t, <code>value<\/code>no k\u0101 izvilkt, un <code>pattern<\/code>aprakstiet, ko izvilkt. Papildu parametrs \u013cauj lietot\u0101jiem izv\u0113l\u0113ties, vai atrast tikai pirmo atbilst\u012bbu vai visus gad\u012bjumus un vai mekl\u0113\u0161an\u0101 ir re\u0123istrjut\u012bgs.<\/p>\n<ul>\n<li>Turpinot m\u016bsu iepriek\u0161\u0113jo piem\u0113ru, m\u0113s varam neman\u0101mi izg\u016bt t\u0101lru\u0146u numurus.<\/li>\n<\/ul>\n<figure class=\"wp-block-image\"><img alt=\"REGEXEXTRACT lieto\u0161anas piem\u0113rs\" class=\"wp-image\" decoding=\"async\" height=\"439\" loading=\"lazy\" src=\"https:\/\/cdn.howtogeek.blog\/wp-content\/uploads\/2025\/01\/image-445-1.webp\" title=\"REGEXEXTRACT lieto\u0161anas piem\u0113rs\" width=\"780\"\/><\/figure>\n<ul>\n<li>Lai izvilktu t\u0101lru\u0146u numurus, izmantojiet: <code>=REGEXEXTRACT(A4, \"(\\\\d{3})?[-.\\s]?\\\\d{3}[-.\\s]?\\\\d{4}\")<\/code>\u0161\u016bn\u0101 C4.<\/li>\n<\/ul>\n<figure class=\"wp-block-image\"><img alt=\"REGEXEXTRACT ievade\" class=\"wp-image\" decoding=\"async\" height=\"517\" loading=\"lazy\" src=\"https:\/\/cdn.howtogeek.blog\/wp-content\/uploads\/2025\/01\/image-446-1.webp\" title=\"REGEXEXTRACT ievade\" width=\"919\"\/><\/figure>\n<ul>\n<li>Ievadot \u0161o formulu, ja atsauces \u0161\u016bnai ir t\u0101lru\u0146a numurs, tas tiks par\u0101d\u012bts k\u0101 izvade. Velciet formulu uz leju, lai lietotu \u0161o ekstrakciju cit\u0101m \u0161\u016bn\u0101m.<\/li>\n<\/ul>\n<figure class=\"wp-block-image\"><img alt=\"REGEXEXTRACT T\u0101lru\u0146a numuru izvade\" class=\"wp-image\" decoding=\"async\" height=\"445\" loading=\"lazy\" src=\"https:\/\/cdn.howtogeek.blog\/wp-content\/uploads\/2025\/01\/image-447-1.webp\" title=\"REGEXEXTRACT T\u0101lru\u0146a numuru izvade\" width=\"791\"\/><\/figure>\n<ul>\n<li>Lai ieg\u016btu papildu atbilst\u012bbas, mainiet uz: <code>=REGEXEXTRACT(A4, \"(\\\\d{3})?[-.\\s]?\\\\d{3}[-.\\s]?\\\\d{4}\", 1)<\/code>.<\/li>\n<\/ul>\n<figure class=\"wp-block-image\"><img alt=\"REGEXEXTRACT izmanto\u0161ana vair\u0101k\u0101m sp\u0113l\u0113m\" class=\"wp-image\" decoding=\"async\" height=\"483\" loading=\"lazy\" src=\"https:\/\/cdn.howtogeek.blog\/wp-content\/uploads\/2025\/01\/image-448-2.webp\" title=\"REGEXEXTRACT izmanto\u0161ana vair\u0101k\u0101m sp\u0113l\u0113m\" width=\"858\"\/><\/figure>\n<h2 id=\"using-the-regexreplace-function\">Mainiet datu mode\u013cus, izmantojot REGEXREPLACE<\/h2>\n<p>Funkcija REGEXREPLACE \u013cauj atrast konkr\u0113tus datu mode\u013cus un aizst\u0101t tos ar alternat\u012bvu form\u0101tu. Sintakse ir <code>REGEXREPLACE(value, pattern, replacement, [occurrence], [case_sensitive])<\/code>. Tas <code>value<\/code>ir tas, ko v\u0113laties aizst\u0101t, <code>pattern<\/code>ir tas, ko v\u0113laties atrast, un <code>replacement<\/code>tas nosaka, ar ko j\u016bs aizst\u0101jat.<\/p>\n<ul>\n<li>Izmantojot iepriek\u0161\u0113jos datus, izmantojiet funkciju \u0161\u0101di: <code>=REGEXREPLACE(A4, \"(\\\\d{3})?[-.\\s]?\\\\d{3}[-.\\s]?\\\\d{4}\", \"$1-$2-$3\")<\/code>\u0161\u016bn\u0101 C4, lai standartiz\u0113tu t\u0101lru\u0146a numuru form\u0101tus.<\/li>\n<\/ul>\n<figure class=\"wp-block-image\"><img alt=\"REGEXREPLACE piem\u0113rs t\u0101lru\u0146u numuru standartiz\u0113\u0161anai\" class=\"wp-image\" decoding=\"async\" height=\"493\" loading=\"lazy\" src=\"https:\/\/cdn.howtogeek.blog\/wp-content\/uploads\/2025\/01\/image-449-1.webp\" title=\"REGEXREPLACE piem\u0113rs t\u0101lru\u0146u numuru standartiz\u0113\u0161anai\" width=\"876\"\/><\/figure>\n<h3 id=\"practical-tips-for-regex\">B\u016btiski padomi REGEX funkciju lieto\u0161anai<\/h3>\n<ul>\n<li>Iepaz\u012bstieties ar t\u0101diem mar\u0137ieriem k\u0101 \u201c{}\u201d un \u201c[]\u201d, kas ir b\u016btiski, lai izveidotu efekt\u012bvus REGEX mode\u013cus.<\/li>\n<li>P\u0101rliecinieties, vai j\u016bsu dati ir labi struktur\u0113ti, lai nov\u0113rstu sare\u017e\u0123\u012bjumus, izmantojot REGEX funkcijas.<\/li>\n<li>Apsveriet iesp\u0113ju izmantot nosac\u012bjumformat\u0113\u0161anu kop\u0101 ar REGEX, lai uzlabotu datu vizualiz\u0101ciju un anal\u012bzi.<\/li>\n<li>Programma Excel pied\u0101v\u0101 citas datu ieguves metodes, piem\u0113ram, Flash Fill un TEXTSPLIT, lai v\u0113l vair\u0101k bag\u0101tin\u0101tu j\u016bsu datu apstr\u0101des r\u012bku komplektu.<\/li>\n<\/ul>\n<p>Tiem, kas v\u0113las padzi\u013cin\u0101t izpratni par REGEX funkcij\u0101m programm\u0101 Excel, skatiet ofici\u0101lo dokument\u0101ciju <a href=\"https:\/\/support.microsoft.com\/en-us\/office\/excel-help-55 Cbd404-814f-5300-8357-7697ff98bca4\" rel=\"noopener noreferrer nofollow\" target=\"_blank\">Microsoft Excel pal\u012bdz\u012bbas lap\u0101<\/a> vai izp\u0113tiet <a href=\"https:\/\/www.regular-expressions.info\/\" rel=\"noopener noreferrer nofollow\" target=\"_blank\">\u0161o visaptvero\u0161o REGEX rokasgr\u0101matu<\/a> .<\/p>\n<h2>Bie\u017ei uzdotie jaut\u0101jumi<\/h2>\n<h3><strong>1. Kam tiek izmantotas REGEX funkcijas programm\u0101 Excel?<\/strong><\/h3>\n<p>REGEX funkcijas programm\u0101 Excel \u013cauj lietot\u0101jiem atrast konkr\u0113tus mode\u013cus, ieg\u016bt inform\u0101ciju vai efekt\u012bvi aizst\u0101t tekstu \u0161\u016bn\u0101s. Tie var b\u016bt nenov\u0113rt\u0113jami, lai p\u0101rbaud\u012btu datus vai p\u0101rveidotu datu kopas, lai t\u0101s atbilstu noteiktiem format\u0113\u0161anas standartiem.<\/p>\n<h3><strong>2. K\u0101 nodro\u0161in\u0101t, lai REGEX mode\u013ci ir pareizi?<\/strong><\/h3>\n<p>REGEX mode\u013cu p\u0101rbaude atsevi\u0161\u0137\u0101 REGEX r\u012bk\u0101 vai tie\u0161saistes REGEX test\u0113t\u0101ju izmanto\u0161ana var pal\u012bdz\u0113t nodro\u0161in\u0101t precizit\u0101ti pirms to izmanto\u0161anas programm\u0101 Excel. Turkl\u0101t s\u0101ciet ar vienk\u0101r\u0161iem mode\u013ciem un pak\u0101peniski veidojiet sare\u017e\u0123\u012bt\u012bbu, lai izvair\u012btos no sintakses probl\u0113m\u0101m.<\/p>\n<h3><strong>3. Vai varu izmantot REGEX da\u017e\u0101da veida datiem, iz\u0146emot t\u0101lru\u0146a numurus?<\/strong><\/h3>\n<p>Piln\u012bgi noteikti! REGEX ir daudzpus\u012bgs, un to var izmantot, lai identific\u0113tu, ieg\u016btu vai aizst\u0101tu da\u017e\u0101dus datu tipus, tostarp e-pasta adreses, vietr\u0101\u017eus URL, produktu kodus un jebkuru teksta virkni, kas seko atpaz\u012bstamam modelim.<\/p>\n<p><a class=\"xiaomi\" href=\"https:\/\/allthings.how\/how-to-use-the-regex-functions-in-excel\/\" rel=\"noopener noreferrer nofollow\" target=\"_blank\">Avots un att\u0113li<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>2024.\u00a0gad\u0101 Microsoft uzlaboja Excel iesp\u0113jas, ievie\u0161ot tr\u012bs jaud\u012bgas funkcijas, kuru centr\u0101 ir regul\u0101r\u0101s izteiksmes (REGEX). \u0160\u012bs funkcijas, proti, REGEXTEST, REGEXEXTRACT un REGEXREPLACE, sniedz lietot\u0101jiem iesp\u0113ju efekt\u012bvi identific\u0113t, ieg\u016bt un aizst\u0101t sare\u017e\u0123\u012btus datu mode\u013cus. Tie ir pieejami Excel t\u012bmek\u013ca versij\u0101 un Microsoft\u00a0365, iev\u0113rojami uzlabojot datu manipul\u0101cijas lietot\u0101jiem. Izpratne par REGEX funkcij\u0101m programm\u0101 Excel Regul\u0101r\u0101s izteiksmes ir [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[130,286],"class_list":["post-7499","post","type-post","status-publish","format-standard","hentry","category-how-to","tag-microsoft","tag-microsoft-excel"],"acf":[],"_links":{"self":[{"href":"https:\/\/howtogeek.blog\/lv\/wp-json\/wp\/v2\/posts\/7499","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/howtogeek.blog\/lv\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/howtogeek.blog\/lv\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/howtogeek.blog\/lv\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/howtogeek.blog\/lv\/wp-json\/wp\/v2\/comments?post=7499"}],"version-history":[{"count":1,"href":"https:\/\/howtogeek.blog\/lv\/wp-json\/wp\/v2\/posts\/7499\/revisions"}],"predecessor-version":[{"id":7500,"href":"https:\/\/howtogeek.blog\/lv\/wp-json\/wp\/v2\/posts\/7499\/revisions\/7500"}],"wp:attachment":[{"href":"https:\/\/howtogeek.blog\/lv\/wp-json\/wp\/v2\/media?parent=7499"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/howtogeek.blog\/lv\/wp-json\/wp\/v2\/categories?post=7499"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/howtogeek.blog\/lv\/wp-json\/wp\/v2\/tags?post=7499"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}