1.0Wayne Sheffieldhttps://blog.waynesheffield.com/waynerich600338<blockquote class="wp-embedded-content" data-secret="npLMRGwrtO"><a href="https://blog.waynesheffield.com/wayne/archive/2018/01/block-selectreplace-day-11/">Block Select/Replace (Day 11)</a></blockquote><iframe sandbox="allow-scripts" security="restricted" src="https://blog.waynesheffield.com/wayne/archive/2018/01/block-selectreplace-day-11/embed/#?secret=npLMRGwrtO" width="600" height="338" title="“Block Select/Replace (Day 11)” — Wayne Sheffield" data-secret="npLMRGwrtO" frameborder="0" marginwidth="0" marginheight="0" scrolling="no" class="wp-embedded-content"></iframe><script type="text/javascript"> /* <![CDATA[ */ /*! This file is auto-generated */ !function(d,l){"use strict";l.querySelector&&d.addEventListener&&"undefined"!=typeof URL&&(d.wp=d.wp||{},d.wp.receiveEmbedMessage||(d.wp.receiveEmbedMessage=function(e){var t=e.data;if((t||t.secret||t.message||t.value)&&!/[^a-zA-Z0-9]/.test(t.secret)){for(var s,r,n,a=l.querySelectorAll('iframe[data-secret="'+t.secret+'"]'),o=l.querySelectorAll('blockquote[data-secret="'+t.secret+'"]'),c=new RegExp("^https?:$","i"),i=0;i<o.length;i++)o[i].style.display="none";for(i=0;i<a.length;i++)s=a[i],e.source===s.contentWindow&&(s.removeAttribute("style"),"height"===t.message?(1e3<(r=parseInt(t.value,10))?r=1e3:~~r<200&&(r=200),s.height=r):"link"===t.message&&(r=new URL(s.getAttribute("src")),n=new URL(t.value),c.test(n.protocol))&&n.host===r.host&&l.activeElement===s&&(d.top.location.href=t.value))}},d.addEventListener("message",d.wp.receiveEmbedMessage,!1),l.addEventListener("DOMContentLoaded",function(){for(var e,t,s=l.querySelectorAll("iframe.wp-embedded-content"),r=0;r<s.length;r++)(t=(e=s[r]).getAttribute("data-secret"))||(t=Math.random().toString(36).substring(2,12),e.src+="#?secret="+t,e.setAttribute("data-secret",t)),e.contentWindow.postMessage({message:"ready",secret:t},"*")},!1)))}(window,document); //# sourceURL=https://blog.waynesheffield.com/wayne/wp-includes/js/wp-embed.min.js /* ]]> */ </script> While Regular Expressions lets us work with text not cleanly formatted, if you are trying to work with text that lines up, there is an easier way to do things. Starting with SSMS 2012, you can use Block Select/Replace (note that this is actually a Windows feature, so it works in other programs that handle […]