{"id":3233,"date":"2024-12-03T01:29:17","date_gmt":"2024-12-03T01:29:17","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/03\/tach-ky-tu-tach-so-tach-gmail-tu-mot-chuoi-su-dung-regular-expression\/"},"modified":"2024-12-03T01:29:17","modified_gmt":"2024-12-03T01:29:17","slug":"tach-ky-tu-tach-so-tach-gmail-tu-mot-chuoi-su-dung-regular-expression","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/03\/tach-ky-tu-tach-so-tach-gmail-tu-mot-chuoi-su-dung-regular-expression\/","title":{"rendered":"T\u00e1ch k\u00fd t\u1ef1, T\u00e1ch S\u1ed1, T\u00e1ch Gmail t\u1eeb m\u1ed9t Chu\u1ed7i s\u1eed d\u1ee5ng Regular Expression"},"content":{"rendered":"<div class=\"uk-panel uk-margin\" id=\"template-dQf5b79p#1\">\n<p><em><span style=\"vertical-align: inherit\"><span style=\"vertical-align: inherit\">Khi b\u1ea1n ch\u1ecdn m\u1ed9t \u0111o\u1ea1n v\u0103n b\u1ea3n(text) b\u1ea3o g\u1ed3m c\u1ea3 ch\u1eef, s\u1ed1 v\u00e0 Gmail b\u1ea1n c\u1ea7n t\u00e1ch n\u00f3 ra, \u0110\u1eebng lo l\u1eafng v\u00ec trong b\u00e0i vi\u1ebft n\u00e0y<\/span><span style=\"vertical-align: inherit\">\u00a0<\/span><\/span><span style=\"vertical-align: inherit\"><span style=\"vertical-align: inherit\"><strong><a href=\"http:\/\/blog.ezworkapp.com\/\">Hoc Excel Online<\/a>\u00a0<\/strong>s\u1ebd h\u01b0\u1edbng d\u1eabn b\u1ea1n l\u00e0m \u0111i\u1ec1u \u0111\u00f3 th\u00f4i.<\/span><\/span><\/em><\/p>\n<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_61 counter-hierarchy ez-toc-counter ez-toc-transparent ez-toc-container-direction\">\n<p class=\"ez-toc-title\">Xem nhanh<\/p>\n<p><label for=\"ez-toc-cssicon-toggle-item-674e5eece3fc8\" class=\"ez-toc-cssicon-toggle-label\"><span class=\"\"><span class=\"eztoc-hide\">Toggle<\/span><span class=\"ez-toc-icon-toggle-span\"><\/span><\/span><\/label><\/p>\n<nav>\n<ul class=\"ez-toc-list ez-toc-list-level-1 \">\n<li class=\"ez-toc-page-1 ez-toc-heading-level-1\"><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/blog.hocexcel.online\/tach-ky-tu-tach-tach-gmail-tu-mot-chuoi-su-dung-regular.html#Khai_niem\" title=\"Kh\u00e1i ni\u1ec7m\">Kh\u00e1i ni\u1ec7m<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-1\"><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/blog.hocexcel.online\/tach-ky-tu-tach-tach-gmail-tu-mot-chuoi-su-dung-regular.html#Cach_su_dung\" title=\"C\u00e1ch s\u1eed d\u1ee5ng\">C\u00e1ch s\u1eed d\u1ee5ng<\/a>\n<ul class=\"ez-toc-list-level-2\">\n<li class=\"ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/blog.hocexcel.online\/tach-ky-tu-tach-tach-gmail-tu-mot-chuoi-su-dung-regular.html#Buoc_1_Mo_cua_so_Visual_Basic_Application_VBA\" title=\"B\u01b0\u1edbc\u00a01: M\u1edf c\u1eeda s\u1ed5 Visual Basic Application (VBA)\">B\u01b0\u1edbc\u00a01: M\u1edf c\u1eeda s\u1ed5 Visual Basic Application (VBA)<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/blog.hocexcel.online\/tach-ky-tu-tach-tach-gmail-tu-mot-chuoi-su-dung-regular.html#Buoc_2_Tao_mot_module_moi\" title=\"B\u01b0\u1edbc 2: T\u1ea1o m\u1ed9t\u00a0module\u00a0m\u1edbi\">B\u01b0\u1edbc 2: T\u1ea1o m\u1ed9t\u00a0module\u00a0m\u1edbi<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-5\" href=\"https:\/\/blog.hocexcel.online\/tach-ky-tu-tach-tach-gmail-tu-mot-chuoi-su-dung-regular.html#Buoc_3_Copy_doan_ma_VBA_vua_tai_ve_vao_trong_module\" title=\"B\u01b0\u1edbc 3 : Copy \u0111o\u1ea1n m\u00e3 VBA v\u1eeba t\u1ea3i v\u1ec1 v\u00e0o\u00a0 trong module\">B\u01b0\u1edbc 3 : Copy \u0111o\u1ea1n m\u00e3 VBA v\u1eeba t\u1ea3i v\u1ec1 v\u00e0o\u00a0 trong module<\/a><\/li>\n<\/ul>\n<\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-1\"><a class=\"ez-toc-link ez-toc-heading-6\" href=\"https:\/\/blog.hocexcel.online\/tach-ky-tu-tach-tach-gmail-tu-mot-chuoi-su-dung-regular.html#Huong_dan_su_dung\" title=\"H\u01b0\u1edbng d\u1eabn s\u1eed d\u1ee5ng\">H\u01b0\u1edbng d\u1eabn s\u1eed d\u1ee5ng<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-1\"><a class=\"ez-toc-link ez-toc-heading-7\" href=\"https:\/\/blog.hocexcel.online\/tach-ky-tu-tach-tach-gmail-tu-mot-chuoi-su-dung-regular.html#Ket_luan\" title=\"K\u1ebft lu\u1eadn\">K\u1ebft lu\u1eadn<\/a><\/li>\n<\/ul>\n<\/nav>\n<\/div>\n<h1><span class=\"ez-toc-section\" id=\"Khai_niem\"><\/span><span style=\"vertical-align: inherit\"><span style=\"vertical-align: inherit\">Kh\u00e1i ni\u1ec7m<\/span><\/span><span class=\"ez-toc-section-end\"><\/span><\/h1>\n<p id=\"_bat-dau-su-dung-regular-expression-9\">B\u00e0i vi\u1ebft n\u00e0y Hoc Excel Online s\u1ebd h\u01b0\u1edbng d\u1eabn c\u00e1c b\u1ea1n s\u1eed d\u1ee5ng <a href=\"http:\/\/blog.ezworkapp.com\/excel-vba\"><strong>VBA Excel<\/strong><\/a> v\u00e0 Regular Expression \u0111\u1ec3 b\u1eaft m\u1ed7i chu\u1ed7i b\u1ea5t k\u1ef3 theo quy lu\u1eadt \u0111\u1ec3 t\u00e1ch ra theo y\u00eau c\u1ea7u<\/p>\n<h1><span class=\"ez-toc-section\" id=\"Cach_su_dung\"><\/span><span style=\"vertical-align: inherit\"><span style=\"vertical-align: inherit\">C\u00e1ch s\u1eed d\u1ee5ng<\/span><\/span><span class=\"ez-toc-section-end\"><\/span><\/h1>\n<p><span style=\"vertical-align: inherit\"><span style=\"vertical-align: inherit\">\u0110\u1ea7u ti\u00ean c\u00e1c b\u1ea1n c\u1ea7n t\u1ea3i \u0111o\u1ea1n code b\u1eb1ng VBA <a href=\"https:\/\/github.com\/TuanBaLuong\/VBA\/blob\/master\/ReGex\">t\u1ea1i \u0111\u00e2y<\/a><\/span><\/span><\/p>\n<h2><span class=\"ez-toc-section\" id=\"Buoc_1_Mo_cua_so_Visual_Basic_Application_VBA\"><\/span><span id=\"Buoc_1_Mo_cua_so_Visual_Basic_Application_VBA\"><span style=\"vertical-align: inherit\"><span style=\"vertical-align: inherit\">B\u01b0\u1edbc\u00a01: M\u1edf c\u1eeda s\u1ed5 Visual Basic Application (VBA)<\/span><\/span><\/span><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><span style=\"vertical-align: inherit\"><span style=\"vertical-align: inherit\">C\u00f3 2 c\u00e1ch v\u00e0 m\u1edf ra VBA:<\/span><\/span><\/p>\n<ul>\n<li>C\u00e1ch 1: B\u1ea5m t\u1ed5 h\u1ee3p ph\u00edm t\u1eaft Alt + F11<\/li>\n<li>C\u00e1ch 2: Trong tab Developer, b\u1ea5m ch\u1ecdn Visual Basic<\/li>\n<\/ul>\n<h2><span class=\"ez-toc-section\" id=\"Buoc_2_Tao_mot_module_moi\"><\/span><span style=\"vertical-align: inherit\"><span style=\"vertical-align: inherit\">B\u01b0\u1edbc 2: T\u1ea1o m\u1ed9t\u00a0<\/span><\/span>module<span style=\"vertical-align: inherit\"><span style=\"vertical-align: inherit\">\u00a0m\u1edbi<\/span><\/span><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>B\u1ea5m chu\u1ed9t ph\u1ea3i v\u00e0o m\u1ee5c Project \u2013 VBAProject r\u1ed3i ch\u1ecdn\u00a0Insert \/ Module<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-29902 size-full\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/screenshot-13.png\" alt=\"Tach-ky-tu-tach-so-tach-gmail-tu-mot-chuoi-su-dung-Regular-Expression-1\" width=\"994\" height=\"671\" title=\"screenshot-13\"><\/p>\n<h2><span class=\"ez-toc-section\" id=\"Buoc_3_Copy_doan_ma_VBA_vua_tai_ve_vao_trong_module\"><\/span>B\u01b0\u1edbc 3 : Copy \u0111o\u1ea1n m\u00e3 VBA v\u1eeba t\u1ea3i v\u1ec1 v\u00e0o\u00a0 trong module<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignleft wp-image-29904 size-full\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/module.png\" alt=\"Tach-ky-tu-tach-so-tach-gmail-tu-mot-chuoi-su-dung-Regular-Expression-2\" width=\"1439\" height=\"646\" title=\"module\"><\/p>\n<div class=\"code-block code-block-2\" style=\"margin: 8px 0;clear: both\">\n<div class=\"ad-inserterpro\">\n<a href=\"https:\/\/hocexcel.online\/course\/preview\/vba101-tu-dong-hoa-excel-voi-lap-trinh-vba-cho-nguoi-moi-bat-dau\"><br \/>\n<img decoding=\"async\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/vba101_92019-nho-106.gif\" title=\"vba101_92019-nho-106\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<div class=\"code-block code-block-1\" style=\"margin: 8px 0;clear: both\">\n<div class=\"ad-inserterpro\">\n<a href=\"https:\/\/hocexcel.online\/course\/preview\/ex101-excel-tu-co-ban-den-chuyen-gia-danh-cho-nguoi-di-lam\"><br \/>\n<img decoding=\"async\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/ex101_92019-nho-247.gif\" title=\"ex101_92019-nho-247\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<p>Gi\u1edd th\u00ec c\u00e1c b\u1ea1n quay l\u1ea1i c\u1eeda s\u1ed5 Excel v\u00e0 s\u1eed d\u1ee5ng th\u00f4i ALT+Q.<\/p>\n<h1><span class=\"ez-toc-section\" id=\"Huong_dan_su_dung\"><\/span>H\u01b0\u1edbng d\u1eabn s\u1eed d\u1ee5ng<span class=\"ez-toc-section-end\"><\/span><\/h1>\n<blockquote>\n<p>ReGex (Chu\u1ed7i c\u1ea7n t\u00e1ch,\u00a0Chu\u1ed7i b\u1eaft)<\/p>\n<\/blockquote>\n<p>Chu\u1ed7i c\u1ea7n t\u00e1ch l\u00e0 chu\u1ed7i text g\u1ed3m ch\u1eef, s\u1ed1, Email\u2026<\/p>\n<p>Chu\u1ed7i b\u1eaft l\u00e0 matching c\u1ee7a Regular Expression<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-29903 size-full\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/rexex.png\" alt=\"Tach-ky-tu-tach-so-tach-gmail-tu-mot-chuoi-su-dung-Regular-Expression-3\" width=\"1420\" height=\"208\" title=\"rexex\"><\/p>\n<p>Chu\u1ed7i b\u1eaft: Gmail<\/p>\n<blockquote>\n<p>(W|^)[w.+-]*@gmail.com(W|$)<\/p>\n<\/blockquote>\n<p>Chu\u1ed7i b\u1eaft: S\u1ed1<\/p>\n<blockquote>\n<p>d+<\/p>\n<\/blockquote>\n<p>Chu\u1ed7i b\u1eaft: K\u00fd t\u1ef1 kh\u00e1c v\u1edbi b\u1ea3ng ch\u1eef Latinh(Ti\u1ebfng Anh)<\/p>\n<blockquote>\n<p>W+<\/p>\n<\/blockquote>\n<p>Chu\u1ed7i b\u1eaft : L\u00e0 ki\u1ec3u ch\u1eef b\u1ea3ng m\u00e3 LaTinh<\/p>\n<blockquote>\n<p>[A-Za-z]<\/p>\n<\/blockquote>\n<h1><span class=\"ez-toc-section\" id=\"Ket_luan\"><\/span>K\u1ebft lu\u1eadn<span class=\"ez-toc-section-end\"><\/span><\/h1>\n<p>Qua b\u00e0i vi\u1ebft n\u00e0y hy\u00a0v\u1ecdng c\u00e1c b\u1ea1n \u00e1p d\u1ee5ng Regular Expression v\u00e0o c\u00f4ng vi\u1ec7c c\u1ee7a m\u00ecnh hi\u1ec7u qu\u1ea3 nh\u1ea5t.<\/p>\n<p>H\u00e3y theo d\u00f5i\u00a0<strong>Hoc Excel Online\u00a0<\/strong>\u0111\u1ec3 c\u00f3 nhi\u1ec1u b\u00e0i vi\u1ebft b\u1ed5 \u00edch h\u01a1n nh\u00e9, n\u1ebfu th\u1ea5y hay h\u00e3y chia s\u1ebb cho nhi\u1ec1u ng\u01b0\u1eddi bi\u1ebft \u0111\u1ebfn h\u01a1n nh\u00e9<\/p>\n<p>Ngo\u00e0i ra \u0111\u1ec3 hi\u1ec3u r\u00f5 h\u01a1n v\u1ec1c\u00e1c s\u1eed d\u1ee5ng Regular Expression c\u00e1c b\u1ea1n s\u1ebd tham kh\u1ea3o nh\u00e9.<\/p>\n<hr>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/cach-su-dung-regular-expression-trong-vba.html\">C\u00e1ch s\u1eed d\u1ee5ng Regular Expression trong VBA<\/a><\/p>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/thiet-lap-rang-buoc-voi-yeu-cau-nhap-thong-tin-voi-google-form-bieu-mau.html\">Thi\u1ebft l\u1eadp x\u00e1c th\u1ef1c ph\u1ea3n h\u1ed3i v\u1edbi Google Form (bi\u1ec3u m\u1eabu)<\/a><\/p>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/huong-dan-loc-lay-dia-chi-email-khach-hang-tu-danh-sach-co-chua-nhieu-chu-khong-mong-muon.html\">H\u01b0\u1edbng d\u1eabn l\u1ecdc l\u1ea5y \u0111\u1ecba ch\u1ec9 email kh\u00e1ch h\u00e0ng t\u1eeb danh s\u00e1ch c\u00f3 ch\u1ee9a nhi\u1ec1u ch\u1eef kh\u00f4ng mong mu\u1ed1n<\/a><\/p>\n<p>\u00a0<\/p>\n<p>\u00a0<\/p>\n<\/div>\n<div class=\"uk-panel uk-margin uk-width-xlarge\">\n<p>Click \u0111\u0103ng k\u00fd h\u1ecdc t\u1ea1i:<\/p>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/khoa-hoc\" target=\"_blank\" rel=\"noopener\">T\u1ea5t c\u1ea3 kho\u00e1 h\u1ecdc\u00a0<span>\ud83d\udcd6<\/span><\/a><\/p>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/huong-dan-kich-hoat-khoa-hoc-tai-hoc-excel-online.html\" target=\"_blank\" rel=\"noopener\">H\u01b0\u1edbng d\u1eabn k\u00edch ho\u1ea1t<\/a><\/p>\n<p>HKD H\u1ecdc Excel Online<br \/>S\u1ed1 \u0110K: 17A80048102<\/p>\n<\/div>\n<div class=\"uk-panel uk-text-small uk-margin uk-margin-remove-bottom uk-text-center\">\n<p>\u00a9  document.currentScript.insertAdjacentHTML(&#8216;afterend&#8217;, &#8221; + new Intl.DateTimeFormat(document.documentElement.lang, {year: &#8216;numeric&#8217;}).format() + &#8221;);  H\u1ecdc Excel Online. All rights reserved.<\/p>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<div class=\"ad-inserterpro\">\n<a href=\"https:\/\/hocexcel.online\/course\/preview\/vba101-tu-dong-hoa-excel-voi-lap-trinh-vba-cho-nguoi-moi-bat-dau\"><br \/>\n<img decoding=\"async\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/vba101_92019-nho-106.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":3234,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3],"tags":[],"class_list":["post-3233","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-excel-nang-cao"],"_links":{"self":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/3233","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/comments?post=3233"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/3233\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/3234"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=3233"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=3233"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=3233"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}