{"id":63967,"date":"2024-05-29T12:58:02","date_gmt":"2024-05-29T11:58:02","guid":{"rendered":"https:\/\/hlrnet.com\/technoblog\/inicio\/?p=63967"},"modified":"2024-05-31T11:57:27","modified_gmt":"2024-05-31T10:57:27","slug":"reguliere-expressies-in-excel","status":"publish","type":"post","link":"https:\/\/hlrnet.com\/technoblog\/inicio\/reguliere-expressies-in-excel\/","title":{"rendered":"Reguliere expressies in Excel"},"content":{"rendered":"<p>Er zijn een aantal nieuwe functies in Excel die het werken met strings ernstig vergemakkelijken, omdat ze reguliere expressies gebruiken.<\/p>\n<p>Dit is wat het is:<\/p>\n<p>Reguliere expressie &#8211; Wikipedia<br \/>\n<a href=\"https:\/\/nl.wikipedia.org\/wiki\/Reguliere_expressie\" rel=\"nofollow\">https:\/\/nl.wikipedia.org\/wiki\/Reguliere_expressie<\/a><\/p>\n<p>En in Excel is dit op komst:<\/p>\n<p>What&#8217;s New in Excel (May 2024) &#8211; Microsoft Community Hub<br \/>\n<a href=\"https:\/\/techcommunity.microsoft.com\/t5\/excel-blog\/what-s-new-in-excel-may-2024\/ba-p\/4133490\" rel=\"nofollow\">https:\/\/techcommunity.microsoft.com\/t5\/excel-blog\/what-s-new-in-excel-may-2024\/ba-p\/4133490<\/a><\/p>\n<p>New Regular expression (Regex) functions in Excel<br \/>\n<a href=\"https:\/\/insider.microsoft365.com\/en-us\/blog\/new-regular-expression-regex-functions-in-excel?ocid=TC\" rel=\"nofollow\">https:\/\/insider.microsoft365.com\/en-us\/blog\/new-regular-expression-regex-functions-in-excel?ocid=TC<\/a><\/p>\n<p>What&#8217;s New in Excel (May 2024) &#8211; Microsoft Community Hub<br \/>\nREGEX<br \/>\n<a href=\"https:\/\/techcommunity.microsoft.com\/t5\/excel-blog\/what-s-new-in-excel-may-2024\/ba-p\/4133490\" rel=\"nofollow\">https:\/\/techcommunity.microsoft.com\/t5\/excel-blog\/what-s-new-in-excel-may-2024\/ba-p\/4133490<\/a><\/p>\n<p>REGEXREPLACE Function &#8211; Microsoft Support<br \/>\n<a href=\"https:\/\/support.microsoft.com\/en-us\/office\/regexreplace-function-9c030bb2-5e47-4efc-bad5-4582d7100897\" rel=\"nofollow\">https:\/\/support.microsoft.com\/en-us\/office\/regexreplace-function-9c030bb2-5e47-4efc-bad5-4582d7100897<\/a><\/p>\n<p>REGEXEXTRACT Function &#8211; Microsoft Support<br \/>\n<a href=\"https:\/\/support.microsoft.com\/en-us\/office\/regexextract-function-4b96c140-9205-4b6e-9fbe-6aa9e783ff57\" rel=\"nofollow\">https:\/\/support.microsoft.com\/en-us\/office\/regexextract-function-4b96c140-9205-4b6e-9fbe-6aa9e783ff57<\/a><\/p>\n<p>Enkele demo&#8217;s:<\/p>\n<p>Introducing REGEX Excel Functions &#8211; Extract, Clean, and Format Data Easily! (NEW!) &#8211; YouTube<br \/>\n<iframe loading=\"lazy\" title=\"Introducing REGEX Excel Functions - Extract, Clean, and Format Data Easily! (NEW!)\" width=\"900\" height=\"506\" src=\"https:\/\/www.youtube.com\/embed\/YFnXV2be9eg?start=267&#038;feature=oembed\" frameborder=\"0\" allow=\"accelerometer; autoplay; clipboard-write; encrypted-media; gyroscope; picture-in-picture; web-share\" referrerpolicy=\"strict-origin-when-cross-origin\" allowfullscreen><\/iframe><\/p>\n<p>Easy Data Cleaning with NEW Regex Functions in Excel &#8211; YouTube<br \/>\n<iframe loading=\"lazy\" title=\"Easy Data Cleaning with NEW Regex Functions in Excel\" width=\"900\" height=\"506\" src=\"https:\/\/www.youtube.com\/embed\/B7yv8fOzL68?feature=oembed\" frameborder=\"0\" allow=\"accelerometer; autoplay; clipboard-write; encrypted-media; gyroscope; picture-in-picture; web-share\" referrerpolicy=\"strict-origin-when-cross-origin\" allowfullscreen><\/iframe><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Er zijn een aantal nieuwe functies in Excel die het werken met strings ernstig vergemakkelijken, omdat ze reguliere expressies gebruiken. Dit is wat het is: Reguliere expressie &#8211; Wikipedia https:\/\/nl.wikipedia.org\/wiki\/Reguliere_expressie En in Excel is dit op komst: What&#8217;s New in Excel (May 2024) &#8211; Microsoft Community Hub https:\/\/techcommunity.microsoft.com\/t5\/excel-blog\/what-s-new-in-excel-may-2024\/ba-p\/4133490 New Regular<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"iawp_total_views":5,"footnotes":""},"categories":[54,10],"tags":[],"class_list":["post-63967","post","type-post","status-publish","format-standard","hentry","category-excel","category-office"],"publishpress_future_action":{"enabled":false,"date":"2026-05-02 20:07:53","action":"delete","newStatus":"draft","terms":[],"taxonomy":"category","extraData":[]},"publishpress_future_workflow_manual_trigger":{"enabledWorkflows":[]},"_links":{"self":[{"href":"https:\/\/hlrnet.com\/technoblog\/inicio\/wp-json\/wp\/v2\/posts\/63967","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/hlrnet.com\/technoblog\/inicio\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/hlrnet.com\/technoblog\/inicio\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/hlrnet.com\/technoblog\/inicio\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/hlrnet.com\/technoblog\/inicio\/wp-json\/wp\/v2\/comments?post=63967"}],"version-history":[{"count":0,"href":"https:\/\/hlrnet.com\/technoblog\/inicio\/wp-json\/wp\/v2\/posts\/63967\/revisions"}],"wp:attachment":[{"href":"https:\/\/hlrnet.com\/technoblog\/inicio\/wp-json\/wp\/v2\/media?parent=63967"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/hlrnet.com\/technoblog\/inicio\/wp-json\/wp\/v2\/categories?post=63967"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/hlrnet.com\/technoblog\/inicio\/wp-json\/wp\/v2\/tags?post=63967"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}