{"id":33373,"date":"2023-02-07T08:58:41","date_gmt":"2023-02-07T03:28:41","guid":{"rendered":"https:\/\/jassweb.com\/solved\/solved-regex-to-remove-leading-9-from-a-phone-number-that-isnt-at-the-start-of-the-line-closed\/"},"modified":"2023-02-07T08:58:41","modified_gmt":"2023-02-07T03:28:41","slug":"solved-regex-to-remove-leading-9-from-a-phone-number-that-isnt-at-the-start-of-the-line-closed","status":"publish","type":"post","link":"https:\/\/jassweb.com\/solved\/solved-regex-to-remove-leading-9-from-a-phone-number-that-isnt-at-the-start-of-the-line-closed\/","title":{"rendered":"[Solved] Regex to remove leading 9 from a phone number, that isn&#8217;t at the start of the line [closed]"},"content":{"rendered":"<p> [ad_1]<br \/>\n<\/p>\n<div id=\"answer-17951087\" class=\"answer js-answer accepted-answer js-accepted-answer\" data-answerid=\"17951087\" data-parentid=\"17950711\" data-score=\"3\" data-position-on-page=\"1\" data-highest-scored=\"1\" data-question-has-accepted-highest-score=\"1\" itemprop=\"acceptedAnswer\" itemscope itemtype=\"https:\/\/schema.org\/Answer\">\n<div class=\"post-layout\">\n<div class=\"votecell post-layout--left\"><\/div>\n<div class=\"answercell post-layout--right\">\n<div class=\"s-prose js-post-body\" itemprop=\"text\">\n<p>The following command should do what you want:<\/p>\n<pre><code>%s\/^\\d\\{3} \\zs9\/\n<\/code><\/pre>\n<p>Note that this will only work if the phone numbers have the exact format you give.  The regex is very specific, to make it a little more unlikely to screw up anything else in the file.<\/p>\n<hr>\n<p>Since you said you were having trouble, I&#8217;ll explain what&#8217;s going on in this regex, so that even if you don&#8217;t decide to use it, you can at least learn a bit.<\/p>\n<p><code>%s<\/code> means &#8220;do the substitution on every line.&#8221;  This isn&#8217;t really part of the regex.  It&#8217;s a standard vim command.<\/p>\n<p><code>^<\/code> is an anchor, meaning &#8220;this must be the location of the start of the line&#8221; \u2013 or, in other words, &#8220;nothing may precede the following stuff on the line.&#8221;<\/p>\n<p><code>\\d\\{3}<\/code> means &#8220;there must be exactly three digits here,&#8221; which means that the first three characters of the line must be digits.<\/p>\n<p><code><\/code>(space) means there must be a literal space next.  Go figure.<\/p>\n<p><code>\\zs<\/code> means &#8220;actually start the match here.&#8221;  The stuff before must match, but don&#8217;t &#8220;select&#8221; anything previous.<\/p>\n<p><code>9<\/code> means there must be a literal <code>9<\/code> next.  This is what you&#8217;ll match.<\/p>\n<p><code>\/<\/code>, the last character, means &#8220;everything next is what you should replace the match with.&#8221;  Since nothing follows it, it means &#8220;replace the match with nothing.&#8221;  <\/p>\n<p>Done!<\/p>\n<p><strong>Edit:<\/strong><\/p>\n<p>Apparently, the data file in question did not have exactly one space between the first group of digits and the second.  To account for this, change the part of the regex that affects the match on the whitespace.<\/p>\n<p>Thus, the space in the regex should be replaced by <code>\\s\\+<\/code>, meaning &#8220;match any whitespace character one or more times.&#8221;  So, the regex would be:<\/p>\n<pre><code>%s\/^\\d\\{3}\\s\\+\\zs9\/\n<\/code><\/pre>\n<\/p><\/div>\n<div class=\"mt24\"><\/div>\n<\/div>\n<p>            <span class=\"d-none\" itemprop=\"commentCount\">6<\/span> <\/p><\/div>\n<\/div>\n<p>[ad_2]<\/p>\n<p>solved Regex to remove leading 9 from a phone number, that isn&#8217;t at the start of the line [closed] <\/p>\n","protected":false},"excerpt":{"rendered":"<p>[ad_1] The following command should do what you want: %s\/^\\d\\{3} \\zs9\/ Note that this will only work if the phone numbers have the exact format you give. The regex is very specific, to make it a little more unlikely to screw up anything else in the file. Since you said you were having trouble, I&#8217;ll &#8230; <a title=\"[Solved] Regex to remove leading 9 from a phone number, that isn&#8217;t at the start of the line [closed]\" class=\"read-more\" href=\"https:\/\/jassweb.com\/solved\/solved-regex-to-remove-leading-9-from-a-phone-number-that-isnt-at-the-start-of-the-line-closed\/\" aria-label=\"More on [Solved] Regex to remove leading 9 from a phone number, that isn&#8217;t at the start of the line [closed]\">Read more<\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[320],"tags":[347,877],"class_list":["post-33373","post","type-post","status-publish","format-standard","hentry","category-solved","tag-regex","tag-vim"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v26.5 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>[Solved] Regex to remove leading 9 from a phone number, that isn&#039;t at the start of the line [closed] - JassWeb<\/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:\/\/jassweb.com\/solved\/solved-regex-to-remove-leading-9-from-a-phone-number-that-isnt-at-the-start-of-the-line-closed\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"[Solved] Regex to remove leading 9 from a phone number, that isn&#039;t at the start of the line [closed] - JassWeb\" \/>\n<meta property=\"og:description\" content=\"[ad_1] The following command should do what you want: %s\/^d{3} zs9\/ Note that this will only work if the phone numbers have the exact format you give. The regex is very specific, to make it a little more unlikely to screw up anything else in the file. Since you said you were having trouble, I&#8217;ll ... Read more\" \/>\n<meta property=\"og:url\" content=\"https:\/\/jassweb.com\/solved\/solved-regex-to-remove-leading-9-from-a-phone-number-that-isnt-at-the-start-of-the-line-closed\/\" \/>\n<meta property=\"og:site_name\" content=\"JassWeb\" \/>\n<meta property=\"article:published_time\" content=\"2023-02-07T03:28:41+00:00\" \/>\n<meta name=\"author\" content=\"Kirat\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Kirat\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/jassweb.com\/solved\/solved-regex-to-remove-leading-9-from-a-phone-number-that-isnt-at-the-start-of-the-line-closed\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/jassweb.com\/solved\/solved-regex-to-remove-leading-9-from-a-phone-number-that-isnt-at-the-start-of-the-line-closed\/\"},\"author\":{\"name\":\"Kirat\",\"@id\":\"https:\/\/jassweb.com\/solved\/#\/schema\/person\/65c9c7b7958150c0dc8371fa35dd7c31\"},\"headline\":\"[Solved] Regex to remove leading 9 from a phone number, that isn&#8217;t at the start of the line [closed]\",\"datePublished\":\"2023-02-07T03:28:41+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/jassweb.com\/solved\/solved-regex-to-remove-leading-9-from-a-phone-number-that-isnt-at-the-start-of-the-line-closed\/\"},\"wordCount\":319,\"publisher\":{\"@id\":\"https:\/\/jassweb.com\/solved\/#organization\"},\"keywords\":[\"regex\",\"vim\"],\"articleSection\":[\"Solved\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/jassweb.com\/solved\/solved-regex-to-remove-leading-9-from-a-phone-number-that-isnt-at-the-start-of-the-line-closed\/\",\"url\":\"https:\/\/jassweb.com\/solved\/solved-regex-to-remove-leading-9-from-a-phone-number-that-isnt-at-the-start-of-the-line-closed\/\",\"name\":\"[Solved] Regex to remove leading 9 from a phone number, that isn't at the start of the line [closed] - JassWeb\",\"isPartOf\":{\"@id\":\"https:\/\/jassweb.com\/solved\/#website\"},\"datePublished\":\"2023-02-07T03:28:41+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/jassweb.com\/solved\/solved-regex-to-remove-leading-9-from-a-phone-number-that-isnt-at-the-start-of-the-line-closed\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/jassweb.com\/solved\/solved-regex-to-remove-leading-9-from-a-phone-number-that-isnt-at-the-start-of-the-line-closed\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/jassweb.com\/solved\/solved-regex-to-remove-leading-9-from-a-phone-number-that-isnt-at-the-start-of-the-line-closed\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/jassweb.com\/solved\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"[Solved] Regex to remove leading 9 from a phone number, that isn&#8217;t at the start of the line [closed]\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/jassweb.com\/solved\/#website\",\"url\":\"https:\/\/jassweb.com\/solved\/\",\"name\":\"JassWeb\",\"description\":\"Build High-quality Websites\",\"publisher\":{\"@id\":\"https:\/\/jassweb.com\/solved\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/jassweb.com\/solved\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/jassweb.com\/solved\/#organization\",\"name\":\"Jass Web\",\"url\":\"https:\/\/jassweb.com\/solved\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/jassweb.com\/solved\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/jassweb.com\/wp-content\/uploads\/2021\/02\/jass-website-logo-1.png\",\"contentUrl\":\"https:\/\/jassweb.com\/wp-content\/uploads\/2021\/02\/jass-website-logo-1.png\",\"width\":693,\"height\":132,\"caption\":\"Jass Web\"},\"image\":{\"@id\":\"https:\/\/jassweb.com\/solved\/#\/schema\/logo\/image\/\"}},{\"@type\":\"Person\",\"@id\":\"https:\/\/jassweb.com\/solved\/#\/schema\/person\/65c9c7b7958150c0dc8371fa35dd7c31\",\"name\":\"Kirat\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/jassweb.com\/solved\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/jassweb.com\/solved\/wp-content\/litespeed\/avatar\/1261af3c9451399fa1336d28b98ea3bb.jpg?ver=1776403586\",\"contentUrl\":\"https:\/\/jassweb.com\/solved\/wp-content\/litespeed\/avatar\/1261af3c9451399fa1336d28b98ea3bb.jpg?ver=1776403586\",\"caption\":\"Kirat\"},\"sameAs\":[\"http:\/\/jassweb.com\"],\"url\":\"https:\/\/jassweb.com\/solved\/author\/jaspritsinghghumangmail-com\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"[Solved] Regex to remove leading 9 from a phone number, that isn't at the start of the line [closed] - JassWeb","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:\/\/jassweb.com\/solved\/solved-regex-to-remove-leading-9-from-a-phone-number-that-isnt-at-the-start-of-the-line-closed\/","og_locale":"en_US","og_type":"article","og_title":"[Solved] Regex to remove leading 9 from a phone number, that isn't at the start of the line [closed] - JassWeb","og_description":"[ad_1] The following command should do what you want: %s\/^d{3} zs9\/ Note that this will only work if the phone numbers have the exact format you give. The regex is very specific, to make it a little more unlikely to screw up anything else in the file. Since you said you were having trouble, I&#8217;ll ... Read more","og_url":"https:\/\/jassweb.com\/solved\/solved-regex-to-remove-leading-9-from-a-phone-number-that-isnt-at-the-start-of-the-line-closed\/","og_site_name":"JassWeb","article_published_time":"2023-02-07T03:28:41+00:00","author":"Kirat","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Kirat","Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/jassweb.com\/solved\/solved-regex-to-remove-leading-9-from-a-phone-number-that-isnt-at-the-start-of-the-line-closed\/#article","isPartOf":{"@id":"https:\/\/jassweb.com\/solved\/solved-regex-to-remove-leading-9-from-a-phone-number-that-isnt-at-the-start-of-the-line-closed\/"},"author":{"name":"Kirat","@id":"https:\/\/jassweb.com\/solved\/#\/schema\/person\/65c9c7b7958150c0dc8371fa35dd7c31"},"headline":"[Solved] Regex to remove leading 9 from a phone number, that isn&#8217;t at the start of the line [closed]","datePublished":"2023-02-07T03:28:41+00:00","mainEntityOfPage":{"@id":"https:\/\/jassweb.com\/solved\/solved-regex-to-remove-leading-9-from-a-phone-number-that-isnt-at-the-start-of-the-line-closed\/"},"wordCount":319,"publisher":{"@id":"https:\/\/jassweb.com\/solved\/#organization"},"keywords":["regex","vim"],"articleSection":["Solved"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/jassweb.com\/solved\/solved-regex-to-remove-leading-9-from-a-phone-number-that-isnt-at-the-start-of-the-line-closed\/","url":"https:\/\/jassweb.com\/solved\/solved-regex-to-remove-leading-9-from-a-phone-number-that-isnt-at-the-start-of-the-line-closed\/","name":"[Solved] Regex to remove leading 9 from a phone number, that isn't at the start of the line [closed] - JassWeb","isPartOf":{"@id":"https:\/\/jassweb.com\/solved\/#website"},"datePublished":"2023-02-07T03:28:41+00:00","breadcrumb":{"@id":"https:\/\/jassweb.com\/solved\/solved-regex-to-remove-leading-9-from-a-phone-number-that-isnt-at-the-start-of-the-line-closed\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/jassweb.com\/solved\/solved-regex-to-remove-leading-9-from-a-phone-number-that-isnt-at-the-start-of-the-line-closed\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/jassweb.com\/solved\/solved-regex-to-remove-leading-9-from-a-phone-number-that-isnt-at-the-start-of-the-line-closed\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/jassweb.com\/solved\/"},{"@type":"ListItem","position":2,"name":"[Solved] Regex to remove leading 9 from a phone number, that isn&#8217;t at the start of the line [closed]"}]},{"@type":"WebSite","@id":"https:\/\/jassweb.com\/solved\/#website","url":"https:\/\/jassweb.com\/solved\/","name":"JassWeb","description":"Build High-quality Websites","publisher":{"@id":"https:\/\/jassweb.com\/solved\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/jassweb.com\/solved\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/jassweb.com\/solved\/#organization","name":"Jass Web","url":"https:\/\/jassweb.com\/solved\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/jassweb.com\/solved\/#\/schema\/logo\/image\/","url":"https:\/\/jassweb.com\/wp-content\/uploads\/2021\/02\/jass-website-logo-1.png","contentUrl":"https:\/\/jassweb.com\/wp-content\/uploads\/2021\/02\/jass-website-logo-1.png","width":693,"height":132,"caption":"Jass Web"},"image":{"@id":"https:\/\/jassweb.com\/solved\/#\/schema\/logo\/image\/"}},{"@type":"Person","@id":"https:\/\/jassweb.com\/solved\/#\/schema\/person\/65c9c7b7958150c0dc8371fa35dd7c31","name":"Kirat","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/jassweb.com\/solved\/#\/schema\/person\/image\/","url":"https:\/\/jassweb.com\/solved\/wp-content\/litespeed\/avatar\/1261af3c9451399fa1336d28b98ea3bb.jpg?ver=1776403586","contentUrl":"https:\/\/jassweb.com\/solved\/wp-content\/litespeed\/avatar\/1261af3c9451399fa1336d28b98ea3bb.jpg?ver=1776403586","caption":"Kirat"},"sameAs":["http:\/\/jassweb.com"],"url":"https:\/\/jassweb.com\/solved\/author\/jaspritsinghghumangmail-com\/"}]}},"_links":{"self":[{"href":"https:\/\/jassweb.com\/solved\/wp-json\/wp\/v2\/posts\/33373","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/jassweb.com\/solved\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/jassweb.com\/solved\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/jassweb.com\/solved\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/jassweb.com\/solved\/wp-json\/wp\/v2\/comments?post=33373"}],"version-history":[{"count":0,"href":"https:\/\/jassweb.com\/solved\/wp-json\/wp\/v2\/posts\/33373\/revisions"}],"wp:attachment":[{"href":"https:\/\/jassweb.com\/solved\/wp-json\/wp\/v2\/media?parent=33373"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/jassweb.com\/solved\/wp-json\/wp\/v2\/categories?post=33373"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/jassweb.com\/solved\/wp-json\/wp\/v2\/tags?post=33373"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}