{"id":5817,"date":"2015-08-28T12:00:47","date_gmt":"2015-08-28T11:00:47","guid":{"rendered":"http:\/\/www.markwilson.co.uk\/blog\/?p=5817"},"modified":"2015-08-25T21:58:37","modified_gmt":"2015-08-25T20:58:37","slug":"short-takes-search-for-new-lines-in-word-exporting-exchangeexchange-online-transport-rules","status":"publish","type":"post","link":"https:\/\/www.markwilson.co.uk\/blog\/2015\/08\/short-takes-search-for-new-lines-in-word-exporting-exchangeexchange-online-transport-rules.htm","title":{"rendered":"Short takes: search for new lines in Word; fix HTML <code> text wrapping in CSS; hidden elements in a WordPress theme"},"content":{"rendered":"

Another mini-blog post under the “short takes” banner…<\/p>\n

Search for new lines when reformatting text\u00a0in Word<\/h3>\n

Unix admins will probably scoff at me as they\u00a0can probably cat<\/code>, awk<\/code> and sed<\/code> this (or something like that)\u00a0but I needed to take a list of values from a web page and convert them to a list in a single command earlier this week. The basic steps I used were:<\/p>\n

    \n
  1. Copy text from table on HTML page<\/li>\n
  2. Paste into Excel<\/li>\n
  3. Delete unrequired columns<\/li>\n
  4. Save as text<\/li>\n<\/ol>\n

    That gave me a file with a list of values (in this case a list of audio or video file formats) but it was one column and I wanted a row to\u00a0include within some very long PowerShell commands<\/a>.<\/p>\n

      \n
    1. Open in Word<\/li>\n
    2. Find ^p<\/code> and replace with ,<\/code><\/li>\n<\/ol>\n

      The way that this works is that ^p<\/code> will search for new lines in Word (actually, it’s looking for new paragraphs, and ^l<\/code> will find a new line)<\/a>. This worked for me in Word, but not in WordPad.<\/p>\n

      Wrapping text in HTML code snippets<\/h3>\n

      For years (ever since Garry Martin wrote a one of his guest posts<\/a> on this blog), I’ve been using a WordPress plug-in called DirtyCode<\/a>\u00a0to format code snippets that wrap to multiple lines.<\/p>\n

      The plug-in is no longer maintained though, and\u00a0WordPress’s visual editor strips out the <dirtycode><\/code> tags so I’ve been wanting to fall back to the standard HTML <code><\/code> tag. Unfortunately that doesn’t text wrap in my theme, so I had to find a way to stop long lines of code running out of the frame.<\/p>\n

      The fix (or maybe it’s a fudge – if I could work out how to make custom CSS stick on theme changes, I would) was to edit my WordPress theme’s stylesheet (style.css) to include\u00a0the following inside the existing code { }<\/code> line:<\/p>\n

      word-break: break-all; white-space: pre-wrap;<\/code><\/p>\n

      Hidden elements in a WordPress theme<\/h3>\n

      On a related note, I had some issues with elements not displaying properly in my new theme either<\/a>. The WordPress forums came to my rescue though – it seems the tag line that I couldn’t see was there but hidden, until I added the following code to the custom CSS:<\/p>\n

      .site-description {\u00a0color: #CCCCCC;\u00a0display: block;\u00a0}<\/code><\/p>\n","protected":false},"excerpt":{"rendered":"

      Another mini-blog post under the “short takes” banner… Search for new lines when reformatting text\u00a0in Word Unix admins will probably scoff at me as they\u00a0can probably cat, awk and sed this (or something like that)\u00a0but I needed to take a list of values from a web page and convert them to a list in a … Continue reading Short takes: search for new lines in Word; fix HTML <code> text wrapping in CSS; hidden elements in a WordPress theme<\/span><\/a><\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_exactmetrics_skip_tracking":false,"_exactmetrics_sitenote_active":false,"_exactmetrics_sitenote_note":"","_exactmetrics_sitenote_category":0,"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[218],"tags":[154,29,15],"class_list":["post-5817","post","type-post","status-publish","format-standard","hentry","category-technology","tag-word","tag-website-development","tag-wordpress"],"yoast_head":"\nShort takes: search for new lines in Word; fix HTML <code> text wrapping in CSS; hidden elements in a WordPress theme - markwilson.it<\/title>\n<meta name=\"description\" content=\"Search for new lines in Word when hacking lists to create one-line commands; and some CSS to fix formatting issues with HTML code tags and WordPress themes\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.markwilson.co.uk\/blog\/2015\/08\/short-takes-search-for-new-lines-in-word-exporting-exchangeexchange-online-transport-rules.htm\" \/>\n<meta property=\"og:locale\" content=\"en_GB\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Short takes: search for new lines in Word; fix HTML <code> text wrapping in CSS; hidden elements in a WordPress theme - markwilson.it\" \/>\n<meta property=\"og:description\" content=\"Search for new lines in Word when hacking lists to create one-line commands; and some CSS to fix formatting issues with HTML code tags and WordPress themes\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.markwilson.co.uk\/blog\/2015\/08\/short-takes-search-for-new-lines-in-word-exporting-exchangeexchange-online-transport-rules.htm\" \/>\n<meta property=\"og:site_name\" content=\"markwilson.it\" \/>\n<meta property=\"article:published_time\" content=\"2015-08-28T11:00:47+00:00\" \/>\n<meta name=\"author\" content=\"Mark Wilson\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@markwilsonit\" \/>\n<meta name=\"twitter:site\" content=\"@markwilsonit\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Mark Wilson\" \/>\n\t<meta name=\"twitter:label2\" content=\"Estimated 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:\\\/\\\/www.markwilson.co.uk\\\/blog\\\/2015\\\/08\\\/short-takes-search-for-new-lines-in-word-exporting-exchangeexchange-online-transport-rules.htm#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.markwilson.co.uk\\\/blog\\\/2015\\\/08\\\/short-takes-search-for-new-lines-in-word-exporting-exchangeexchange-online-transport-rules.htm\"},\"author\":{\"name\":\"Mark Wilson\",\"@id\":\"https:\\\/\\\/www.markwilson.co.uk\\\/blog\\\/#\\\/schema\\\/person\\\/98f61365e7c39d6be942174b8c4de468\"},\"headline\":\"Short takes: search for new lines in Word; fix HTML <code> text wrapping in CSS; hidden elements in a WordPress theme\",\"datePublished\":\"2015-08-28T11:00:47+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.markwilson.co.uk\\\/blog\\\/2015\\\/08\\\/short-takes-search-for-new-lines-in-word-exporting-exchangeexchange-online-transport-rules.htm\"},\"wordCount\":384,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\\\/\\\/www.markwilson.co.uk\\\/blog\\\/#\\\/schema\\\/person\\\/98f61365e7c39d6be942174b8c4de468\"},\"keywords\":[\"Microsoft Word\",\"Website Development\",\"WordPress\"],\"articleSection\":[\"Technology\"],\"inLanguage\":\"en-GB\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/www.markwilson.co.uk\\\/blog\\\/2015\\\/08\\\/short-takes-search-for-new-lines-in-word-exporting-exchangeexchange-online-transport-rules.htm#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.markwilson.co.uk\\\/blog\\\/2015\\\/08\\\/short-takes-search-for-new-lines-in-word-exporting-exchangeexchange-online-transport-rules.htm\",\"url\":\"https:\\\/\\\/www.markwilson.co.uk\\\/blog\\\/2015\\\/08\\\/short-takes-search-for-new-lines-in-word-exporting-exchangeexchange-online-transport-rules.htm\",\"name\":\"Short takes: search for new lines in Word; fix HTML <code> text wrapping in CSS; hidden elements in a WordPress theme - markwilson.it\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.markwilson.co.uk\\\/blog\\\/#website\"},\"datePublished\":\"2015-08-28T11:00:47+00:00\",\"description\":\"Search for new lines in Word when hacking lists to create one-line commands; and some CSS to fix formatting issues with HTML code tags and WordPress themes\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.markwilson.co.uk\\\/blog\\\/2015\\\/08\\\/short-takes-search-for-new-lines-in-word-exporting-exchangeexchange-online-transport-rules.htm#breadcrumb\"},\"inLanguage\":\"en-GB\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.markwilson.co.uk\\\/blog\\\/2015\\\/08\\\/short-takes-search-for-new-lines-in-word-exporting-exchangeexchange-online-transport-rules.htm\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.markwilson.co.uk\\\/blog\\\/2015\\\/08\\\/short-takes-search-for-new-lines-in-word-exporting-exchangeexchange-online-transport-rules.htm#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/www.markwilson.co.uk\\\/blog\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Short takes: search for new lines in Word; fix HTML <code> text wrapping in CSS; hidden elements in a WordPress theme\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/www.markwilson.co.uk\\\/blog\\\/#website\",\"url\":\"https:\\\/\\\/www.markwilson.co.uk\\\/blog\\\/\",\"name\":\"markwilson.it\",\"description\":\"get-info -class technology | write-output > \\\/dev\\\/web\",\"publisher\":{\"@id\":\"https:\\\/\\\/www.markwilson.co.uk\\\/blog\\\/#\\\/schema\\\/person\\\/98f61365e7c39d6be942174b8c4de468\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/www.markwilson.co.uk\\\/blog\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-GB\"},{\"@type\":[\"Person\",\"Organization\"],\"@id\":\"https:\\\/\\\/www.markwilson.co.uk\\\/blog\\\/#\\\/schema\\\/person\\\/98f61365e7c39d6be942174b8c4de468\",\"name\":\"Mark Wilson\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-GB\",\"@id\":\"https:\\\/\\\/i0.wp.com\\\/www.markwilson.co.uk\\\/blog\\\/uploads\\\/image-4.png?fit=800%2C800&ssl=1\",\"url\":\"https:\\\/\\\/i0.wp.com\\\/www.markwilson.co.uk\\\/blog\\\/uploads\\\/image-4.png?fit=800%2C800&ssl=1\",\"contentUrl\":\"https:\\\/\\\/i0.wp.com\\\/www.markwilson.co.uk\\\/blog\\\/uploads\\\/image-4.png?fit=800%2C800&ssl=1\",\"width\":800,\"height\":800,\"caption\":\"Mark Wilson\"},\"logo\":{\"@id\":\"https:\\\/\\\/i0.wp.com\\\/www.markwilson.co.uk\\\/blog\\\/uploads\\\/image-4.png?fit=800%2C800&ssl=1\"},\"description\":\"A Chartered IT Professional, with recent experience in technology leadership, IT strategy and practice management roles, Mark Wilson is an Enterprise Architect in the Advisory and Management Group at risual. During a career spanning more than two decades, Mark has gained widespread recognition as an expert in his field including both industry and national press exposure. In addition to certifications from Microsoft, VMware, Red Hat, The Open Group and Axelos, Mark held a Microsoft Most Valuable Professional (MVP) award for three years and is now part of the MVP Reconnect programme. Mark is also well-known on social media and maintains an award-winning blog.\",\"sameAs\":[\"http:\\\/\\\/www.markwilson.co.uk\\\/\",\"https:\\\/\\\/www.instagram.com\\\/markwilsonuk\\\/\",\"https:\\\/\\\/www.linkedin.com\\\/in\\\/markawilson\\\/\",\"https:\\\/\\\/x.com\\\/markwilsonit\",\"https:\\\/\\\/www.youtube.com\\\/channel\\\/UCWHlZCoHRTocdvtrOJ2IL4A\"],\"url\":\"https:\\\/\\\/www.markwilson.co.uk\\\/blog\\\/author\\\/mark-wilson\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Short takes: search for new lines in Word; fix HTML <code> text wrapping in CSS; hidden elements in a WordPress theme - markwilson.it","description":"Search for new lines in Word when hacking lists to create one-line commands; and some CSS to fix formatting issues with HTML code tags and WordPress themes","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:\/\/www.markwilson.co.uk\/blog\/2015\/08\/short-takes-search-for-new-lines-in-word-exporting-exchangeexchange-online-transport-rules.htm","og_locale":"en_GB","og_type":"article","og_title":"Short takes: search for new lines in Word; fix HTML <code> text wrapping in CSS; hidden elements in a WordPress theme - markwilson.it","og_description":"Search for new lines in Word when hacking lists to create one-line commands; and some CSS to fix formatting issues with HTML code tags and WordPress themes","og_url":"https:\/\/www.markwilson.co.uk\/blog\/2015\/08\/short-takes-search-for-new-lines-in-word-exporting-exchangeexchange-online-transport-rules.htm","og_site_name":"markwilson.it","article_published_time":"2015-08-28T11:00:47+00:00","author":"Mark Wilson","twitter_card":"summary_large_image","twitter_creator":"@markwilsonit","twitter_site":"@markwilsonit","twitter_misc":{"Written by":"Mark Wilson","Estimated reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.markwilson.co.uk\/blog\/2015\/08\/short-takes-search-for-new-lines-in-word-exporting-exchangeexchange-online-transport-rules.htm#article","isPartOf":{"@id":"https:\/\/www.markwilson.co.uk\/blog\/2015\/08\/short-takes-search-for-new-lines-in-word-exporting-exchangeexchange-online-transport-rules.htm"},"author":{"name":"Mark Wilson","@id":"https:\/\/www.markwilson.co.uk\/blog\/#\/schema\/person\/98f61365e7c39d6be942174b8c4de468"},"headline":"Short takes: search for new lines in Word; fix HTML <code> text wrapping in CSS; hidden elements in a WordPress theme","datePublished":"2015-08-28T11:00:47+00:00","mainEntityOfPage":{"@id":"https:\/\/www.markwilson.co.uk\/blog\/2015\/08\/short-takes-search-for-new-lines-in-word-exporting-exchangeexchange-online-transport-rules.htm"},"wordCount":384,"commentCount":0,"publisher":{"@id":"https:\/\/www.markwilson.co.uk\/blog\/#\/schema\/person\/98f61365e7c39d6be942174b8c4de468"},"keywords":["Microsoft Word","Website Development","WordPress"],"articleSection":["Technology"],"inLanguage":"en-GB","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.markwilson.co.uk\/blog\/2015\/08\/short-takes-search-for-new-lines-in-word-exporting-exchangeexchange-online-transport-rules.htm#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.markwilson.co.uk\/blog\/2015\/08\/short-takes-search-for-new-lines-in-word-exporting-exchangeexchange-online-transport-rules.htm","url":"https:\/\/www.markwilson.co.uk\/blog\/2015\/08\/short-takes-search-for-new-lines-in-word-exporting-exchangeexchange-online-transport-rules.htm","name":"Short takes: search for new lines in Word; fix HTML <code> text wrapping in CSS; hidden elements in a WordPress theme - markwilson.it","isPartOf":{"@id":"https:\/\/www.markwilson.co.uk\/blog\/#website"},"datePublished":"2015-08-28T11:00:47+00:00","description":"Search for new lines in Word when hacking lists to create one-line commands; and some CSS to fix formatting issues with HTML code tags and WordPress themes","breadcrumb":{"@id":"https:\/\/www.markwilson.co.uk\/blog\/2015\/08\/short-takes-search-for-new-lines-in-word-exporting-exchangeexchange-online-transport-rules.htm#breadcrumb"},"inLanguage":"en-GB","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.markwilson.co.uk\/blog\/2015\/08\/short-takes-search-for-new-lines-in-word-exporting-exchangeexchange-online-transport-rules.htm"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.markwilson.co.uk\/blog\/2015\/08\/short-takes-search-for-new-lines-in-word-exporting-exchangeexchange-online-transport-rules.htm#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.markwilson.co.uk\/blog"},{"@type":"ListItem","position":2,"name":"Short takes: search for new lines in Word; fix HTML <code> text wrapping in CSS; hidden elements in a WordPress theme"}]},{"@type":"WebSite","@id":"https:\/\/www.markwilson.co.uk\/blog\/#website","url":"https:\/\/www.markwilson.co.uk\/blog\/","name":"markwilson.it","description":"get-info -class technology | write-output > \/dev\/web","publisher":{"@id":"https:\/\/www.markwilson.co.uk\/blog\/#\/schema\/person\/98f61365e7c39d6be942174b8c4de468"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.markwilson.co.uk\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-GB"},{"@type":["Person","Organization"],"@id":"https:\/\/www.markwilson.co.uk\/blog\/#\/schema\/person\/98f61365e7c39d6be942174b8c4de468","name":"Mark Wilson","image":{"@type":"ImageObject","inLanguage":"en-GB","@id":"https:\/\/i0.wp.com\/www.markwilson.co.uk\/blog\/uploads\/image-4.png?fit=800%2C800&ssl=1","url":"https:\/\/i0.wp.com\/www.markwilson.co.uk\/blog\/uploads\/image-4.png?fit=800%2C800&ssl=1","contentUrl":"https:\/\/i0.wp.com\/www.markwilson.co.uk\/blog\/uploads\/image-4.png?fit=800%2C800&ssl=1","width":800,"height":800,"caption":"Mark Wilson"},"logo":{"@id":"https:\/\/i0.wp.com\/www.markwilson.co.uk\/blog\/uploads\/image-4.png?fit=800%2C800&ssl=1"},"description":"A Chartered IT Professional, with recent experience in technology leadership, IT strategy and practice management roles, Mark Wilson is an Enterprise Architect in the Advisory and Management Group at risual. During a career spanning more than two decades, Mark has gained widespread recognition as an expert in his field including both industry and national press exposure. In addition to certifications from Microsoft, VMware, Red Hat, The Open Group and Axelos, Mark held a Microsoft Most Valuable Professional (MVP) award for three years and is now part of the MVP Reconnect programme. Mark is also well-known on social media and maintains an award-winning blog.","sameAs":["http:\/\/www.markwilson.co.uk\/","https:\/\/www.instagram.com\/markwilsonuk\/","https:\/\/www.linkedin.com\/in\/markawilson\/","https:\/\/x.com\/markwilsonit","https:\/\/www.youtube.com\/channel\/UCWHlZCoHRTocdvtrOJ2IL4A"],"url":"https:\/\/www.markwilson.co.uk\/blog\/author\/mark-wilson"}]}},"jetpack_featured_media_url":"","jetpack-related-posts":[{"id":5649,"url":"https:\/\/www.markwilson.co.uk\/blog\/2015\/05\/short-takes-symbols-in-office-applications-and-converting-numbers-to-text-in-excel.htm","url_meta":{"origin":5817,"position":0},"title":"Short takes: Symbols in Office applications and converting numbers to text in Excel","author":"Mark Wilson","date":"Sunday 17 May 2015","format":false,"excerpt":"A few snippets I found on scraps of paper whilst sorting\u00a0out my office this\u00a0week... Shortcuts to\u00a0symbols in Office applications Many people will be familiar with typing (c) to generate a \u00a9 symbol in Microsoft Office applications but you can also use (R) or (TM) for trademark symbols \u00ae and \u2122.\u2026","rel":"","context":"In "Technology"","block_context":{"text":"Technology","link":"https:\/\/www.markwilson.co.uk\/blog\/topic\/technology"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":4043,"url":"https:\/\/www.markwilson.co.uk\/blog\/2012\/06\/creating-a-dashboard-using-sharepoint-lists-part-1-colour-coded-status-indicators.htm","url_meta":{"origin":5817,"position":1},"title":"Creating a dashboard using a SharePoint list (part 1): colour coded status indicators","author":"Mark Wilson","date":"Tuesday 12 June 2012","format":false,"excerpt":"I've been having some fun over the last couple of weeks, developing a dashboard in SharePoint to track a number of activities that I'm co-ordinating. Within our company there are some people who criticise SharePoint as a platform, largely because of some of the confusing messaging around some of the\u2026","rel":"","context":"In "Technology"","block_context":{"text":"Technology","link":"https:\/\/www.markwilson.co.uk\/blog\/topic\/technology"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/www.markwilson.co.uk\/blog\/images\/sharepoint-kpidefault-0.gif?resize=350%2C200&ssl=1","width":350,"height":200},"classes":[]},{"id":8106,"url":"https:\/\/www.markwilson.co.uk\/blog\/2020\/11\/getting-started-with-markdown.htm","url_meta":{"origin":5817,"position":2},"title":"Getting started with Markdown","author":"Mark Wilson","date":"Monday 30 November 2020","format":false,"excerpt":"The problem One of my recent projects has been to build out a repository of architecture artefacts for my team to use in delivery of our engagements. I wanted something quick, simple to use, and my budget was... zero. I probably could have used Github or Azure DevOps but I\u2026","rel":"","context":"In "Technology"","block_context":{"text":"Technology","link":"https:\/\/www.markwilson.co.uk\/blog\/topic\/technology"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":8421,"url":"https:\/\/www.markwilson.co.uk\/blog\/2022\/05\/sorting-a-word-table-of-names-in-excel.htm","url_meta":{"origin":5817,"position":3},"title":"Sorting a Word table of names, in Excel","author":"Mark Wilson","date":"Tuesday 24 May 2022","format":false,"excerpt":"I'm going to share a secret with you all, dear readers. I really like Microsoft Excel. There, I've said it. Excel may not be the perfect tool in some scenarios (take my example last year, which should almost certainly have used Power BI) but it is the \"Swiss Army Knife\"\u2026","rel":"","context":"In "Technology"","block_context":{"text":"Technology","link":"https:\/\/www.markwilson.co.uk\/blog\/topic\/technology"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/www.markwilson.co.uk\/blog\/uploads\/army-2185_1920.jpg?fit=1200%2C800&ssl=1&resize=350%2C200","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/www.markwilson.co.uk\/blog\/uploads\/army-2185_1920.jpg?fit=1200%2C800&ssl=1&resize=350%2C200 1x, https:\/\/i0.wp.com\/www.markwilson.co.uk\/blog\/uploads\/army-2185_1920.jpg?fit=1200%2C800&ssl=1&resize=525%2C300 1.5x, https:\/\/i0.wp.com\/www.markwilson.co.uk\/blog\/uploads\/army-2185_1920.jpg?fit=1200%2C800&ssl=1&resize=700%2C400 2x, https:\/\/i0.wp.com\/www.markwilson.co.uk\/blog\/uploads\/army-2185_1920.jpg?fit=1200%2C800&ssl=1&resize=1050%2C600 3x"},"classes":[]},{"id":4209,"url":"https:\/\/www.markwilson.co.uk\/blog\/2012\/08\/creating-a-sharepoint-calculated-column-that-uses-information-from-a-lookup-column.htm","url_meta":{"origin":5817,"position":4},"title":"Creating a SharePoint calculated column that uses information from a lookup column","author":"Mark Wilson","date":"Thursday 2 August 2012","format":false,"excerpt":"A few months ago, Klout suggested I knew something about SharePoint. I laughed at the time but the last few weeks have seen me spending far more time working on a couple of SharePoint-based systems than I would like, so maybe Klout is less of a measure of social influence\u2026","rel":"","context":"In "Technology"","block_context":{"text":"Technology","link":"https:\/\/www.markwilson.co.uk\/blog\/topic\/technology"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/www.markwilson.co.uk\/blog\/images\/sharepoint-workflow-lookup-plaintext.png?resize=350%2C200&ssl=1","width":350,"height":200},"classes":[]},{"id":344,"url":"https:\/\/www.markwilson.co.uk\/blog\/2004\/10\/windows-autoplay-on-usb-flash-drive.htm","url_meta":{"origin":5817,"position":5},"title":"Windows AutoPlay on a USB flash drive","author":"Mark Wilson","date":"Monday 11 October 2004","format":false,"excerpt":"I've been looking at using the AutoPlay functionality in Windows to launch an HTML document each time I insert a USB flash drive. Controlled using a file called autorun.inf, AutoPlay is designed for CDs, but I see no reason why it should not work with other removable media. There is\u2026","rel":"","context":"In \"Microsoft Windows\"","block_context":{"text":"Microsoft Windows","link":"https:\/\/www.markwilson.co.uk\/blog\/tag\/windows"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]}],"jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/www.markwilson.co.uk\/blog\/wp-json\/wp\/v2\/posts\/5817","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.markwilson.co.uk\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.markwilson.co.uk\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.markwilson.co.uk\/blog\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.markwilson.co.uk\/blog\/wp-json\/wp\/v2\/comments?post=5817"}],"version-history":[{"count":10,"href":"https:\/\/www.markwilson.co.uk\/blog\/wp-json\/wp\/v2\/posts\/5817\/revisions"}],"predecessor-version":[{"id":5930,"href":"https:\/\/www.markwilson.co.uk\/blog\/wp-json\/wp\/v2\/posts\/5817\/revisions\/5930"}],"wp:attachment":[{"href":"https:\/\/www.markwilson.co.uk\/blog\/wp-json\/wp\/v2\/media?parent=5817"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.markwilson.co.uk\/blog\/wp-json\/wp\/v2\/categories?post=5817"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.markwilson.co.uk\/blog\/wp-json\/wp\/v2\/tags?post=5817"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}