  {"id":45259,"date":"2025-03-27T14:55:08","date_gmt":"2025-03-27T19:55:08","guid":{"rendered":"https:\/\/uwm.edu\/libraries\/?post_type=tribe_events&#038;p=45259"},"modified":"2025-03-27T14:55:08","modified_gmt":"2025-03-27T19:55:08","slug":"using-openrefine","status":"publish","type":"tribe_events","link":"https:\/\/uwm.edu\/libraries\/event\/using-openrefine\/","title":{"rendered":"Using OpenRefine to Clean Your Data: Regular Expressions"},"content":{"rendered":"<div class=\"x_elementToProof\">Workshop led by Nathan Humpal.<\/p>\n<\/div>\n<div class=\"x_elementToProof\"><a class=\"x_OWAAutoLink\" title=\"Original URL: https:\/\/openrefine.org\/. Click or tap if you trust this link.\" href=\"https:\/\/nam02.safelinks.protection.outlook.com\/?url=https%3A%2F%2Fopenrefine.org%2F&amp;data=05%7C02%7Csburnham%40uwm.edu%7Ce2c751d19b644968a8ee08dd6ad8ab46%7C0bca7ac3fcb64efd89eb6de97603cf21%7C0%7C0%7C638784201027880870%7CUnknown%7CTWFpbGZsb3d8eyJFbXB0eU1hcGkiOnRydWUsIlYiOiIwLjAuMDAwMCIsIlAiOiJXaW4zMiIsIkFOIjoiTWFpbCIsIldUIjoyfQ%3D%3D%7C0%7C%7C%7C&amp;sdata=SCj2vxb2HxqD401dpcX8wkbxfK0VVZmrv9oJ6Vw8y3A%3D&amp;reserved=0\" rel=\"noopener noreferrer\" target=\"_blank\" data-auth=\"NotApplicable\" data-linkindex=\"3\">OpenRefine<\/a>\u00a0is a free, powerful tool for cleaning up data in lots of formats. One especially powerful feature is using regular expressions to search for patterns in your data to convert, clean, and identify. Join us to learn more about how to use OpenRefine and get the most out of using regular expressions. We will be using the Library Carpentries OpenRefine lesson, focusing on Transformations:\u00a0<a class=\"x_OWAAutoLink\" title=\"Original URL: https:\/\/librarycarpentry.github.io\/lc-open-refine\/07-introduction-to-transformations.html. Click or tap if you trust this link.\" href=\"https:\/\/nam02.safelinks.protection.outlook.com\/?url=https%3A%2F%2Flibrarycarpentry.github.io%2Flc-open-refine%2F07-introduction-to-transformations.html&amp;data=05%7C02%7Csburnham%40uwm.edu%7Ce2c751d19b644968a8ee08dd6ad8ab46%7C0bca7ac3fcb64efd89eb6de97603cf21%7C0%7C0%7C638784201027893390%7CUnknown%7CTWFpbGZsb3d8eyJFbXB0eU1hcGkiOnRydWUsIlYiOiIwLjAuMDAwMCIsIlAiOiJXaW4zMiIsIkFOIjoiTWFpbCIsIldUIjoyfQ%3D%3D%7C0%7C%7C%7C&amp;sdata=xxKzbY0s00hQ9xw0irYotTr2EZA5gqv%2FZGf8QzZRXkw%3D&amp;reserved=0\" rel=\"noopener noreferrer\" target=\"_blank\" data-auth=\"NotApplicable\" data-linkindex=\"4\">https:\/\/librarycarpentry.github.io\/lc-open-refine\/07-introduction-to-transformations.html<\/a><\/div>\n<div><\/div>\n<div>VIRTUAL ONLY<\/div>\n<div><\/div>\n<div class=\"x_elementToProof\">Register here:\u00a0<a class=\"x_OWAAutoLink\" title=\"https:\/\/uwm.edu\/libraries\/digital-humanities\/dh-lab-events\/dh-event-registration-using-openrefine-to-clean-data\/\" href=\"https:\/\/uwm.edu\/libraries\/digital-humanities\/dh-lab-events\/dh-event-registration-using-openrefine-to-clean-data\/\" rel=\"noopener noreferrer\" target=\"_blank\" data-auth=\"NotApplicable\" data-linkindex=\"5\">https:\/\/uwm.edu\/libraries\/digital-humanities\/dh-lab-events\/dh-event-registration-using-openrefine-to-clean-data\/<\/a><\/div>\n","protected":false},"excerpt":{"rendered":"<p>Workshop led by Nathan Humpal. OpenRefine\u00a0is a free, powerful tool for cleaning up data in lots of formats. One especially powerful feature is using regular expressions to search for patterns in your data to convert, clean, and identify. Join us &hellip;<\/p>\n","protected":false},"author":155,"featured_media":0,"template":"","meta":{"_acf_changed":false,"_tribe_events_status":"","_tribe_events_status_reason":"","_tribe_events_is_hybrid":"","_tribe_events_is_virtual":"","_tribe_events_virtual_video_source":"","_tribe_events_virtual_embed_video":"","_tribe_events_virtual_linked_button_text":"","_tribe_events_virtual_linked_button":"","_tribe_events_virtual_show_embed_at":"","_tribe_events_virtual_show_embed_to":[],"_tribe_events_virtual_show_on_event":"","_tribe_events_virtual_show_on_views":"","_tribe_events_virtual_url":"","footnotes":"","uwm_wg_additional_authors":[]},"tags":[],"tribe_events_cat":[52,75,51,49],"class_list":["post-45259","tribe_events","type-tribe_events","status-publish","hentry","tribe_events_cat-faculty-and-staff","tribe_events_cat-front-page-event","tribe_events_cat-students","tribe_events_cat-uwm-campus-events","cat_faculty-and-staff","cat_front-page-event","cat_students","cat_uwm-campus-events"],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v27.3 (Yoast SEO v27.3) - https:\/\/yoast.com\/product\/yoast-seo-premium-wordpress\/ -->\n<title>51ÁÔÆæ Libraries<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/uwm.edu\/libraries\/event\/using-openrefine\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Using OpenRefine to Clean Your Data: Regular Expressions\" \/>\n<meta property=\"og:description\" content=\"Workshop led by Nathan Humpal. OpenRefine\u00a0is a free, powerful tool for cleaning up data in lots of formats. One especially powerful feature is using regular expressions to search for patterns in your data to convert, clean, and identify. Join us &hellip;\" \/>\n<meta property=\"og:url\" content=\"https:\/\/uwm.edu\/libraries\/event\/using-openrefine\/\" \/>\n<meta property=\"og:site_name\" content=\"51ÁÔÆæ Libraries\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data1\" content=\"1 minute\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/uwm.edu\\\/libraries\\\/event\\\/using-openrefine\\\/\",\"url\":\"https:\\\/\\\/uwm.edu\\\/libraries\\\/event\\\/using-openrefine\\\/\",\"name\":\"Using OpenRefine to Clean Your Data: Regular Expressions - 51ÁÔÆæ Libraries\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/uwm.edu\\\/libraries\\\/#website\"},\"datePublished\":\"2025-03-27T19:55:08+00:00\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/uwm.edu\\\/libraries\\\/event\\\/using-openrefine\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/uwm.edu\\\/libraries\\\/event\\\/using-openrefine\\\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/uwm.edu\\\/libraries\\\/event\\\/using-openrefine\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/uwm.edu\\\/libraries\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Events\",\"item\":\"https:\\\/\\\/uwm.edu\\\/libraries\\\/events\\\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"Using OpenRefine to Clean Your Data: Regular Expressions\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/uwm.edu\\\/libraries\\\/#website\",\"url\":\"https:\\\/\\\/uwm.edu\\\/libraries\\\/\",\"name\":\"51ÁÔÆæ Libraries\",\"description\":\"\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/uwm.edu\\\/libraries\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"51ÁÔÆæ Libraries","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/uwm.edu\/libraries\/event\/using-openrefine\/","og_locale":"en_US","og_type":"article","og_title":"Using OpenRefine to Clean Your Data: Regular Expressions","og_description":"Workshop led by Nathan Humpal. OpenRefine\u00a0is a free, powerful tool for cleaning up data in lots of formats. One especially powerful feature is using regular expressions to search for patterns in your data to convert, clean, and identify. Join us &hellip;","og_url":"https:\/\/uwm.edu\/libraries\/event\/using-openrefine\/","og_site_name":"51ÁÔÆæ Libraries","twitter_card":"summary_large_image","twitter_misc":{"Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/uwm.edu\/libraries\/event\/using-openrefine\/","url":"https:\/\/uwm.edu\/libraries\/event\/using-openrefine\/","name":"Using OpenRefine to Clean Your Data: Regular Expressions - 51ÁÔÆæ Libraries","isPartOf":{"@id":"https:\/\/uwm.edu\/libraries\/#website"},"datePublished":"2025-03-27T19:55:08+00:00","breadcrumb":{"@id":"https:\/\/uwm.edu\/libraries\/event\/using-openrefine\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/uwm.edu\/libraries\/event\/using-openrefine\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/uwm.edu\/libraries\/event\/using-openrefine\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/uwm.edu\/libraries\/"},{"@type":"ListItem","position":2,"name":"Events","item":"https:\/\/uwm.edu\/libraries\/events\/"},{"@type":"ListItem","position":3,"name":"Using OpenRefine to Clean Your Data: Regular Expressions"}]},{"@type":"WebSite","@id":"https:\/\/uwm.edu\/libraries\/#website","url":"https:\/\/uwm.edu\/libraries\/","name":"51ÁÔÆæ Libraries","description":"","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/uwm.edu\/libraries\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"}]}},"acf":[],"_links":{"self":[{"href":"https:\/\/uwm.edu\/libraries\/wp-json\/wp\/v2\/tribe_events\/45259","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/uwm.edu\/libraries\/wp-json\/wp\/v2\/tribe_events"}],"about":[{"href":"https:\/\/uwm.edu\/libraries\/wp-json\/wp\/v2\/types\/tribe_events"}],"author":[{"embeddable":true,"href":"https:\/\/uwm.edu\/libraries\/wp-json\/wp\/v2\/users\/155"}],"version-history":[{"count":1,"href":"https:\/\/uwm.edu\/libraries\/wp-json\/wp\/v2\/tribe_events\/45259\/revisions"}],"predecessor-version":[{"id":45260,"href":"https:\/\/uwm.edu\/libraries\/wp-json\/wp\/v2\/tribe_events\/45259\/revisions\/45260"}],"wp:attachment":[{"href":"https:\/\/uwm.edu\/libraries\/wp-json\/wp\/v2\/media?parent=45259"}],"wp:term":[{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/uwm.edu\/libraries\/wp-json\/wp\/v2\/tags?post=45259"},{"taxonomy":"tribe_events_cat","embeddable":true,"href":"https:\/\/uwm.edu\/libraries\/wp-json\/wp\/v2\/tribe_events_cat?post=45259"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}