{"id":48212,"date":"2014-05-23T12:10:22","date_gmt":"2014-05-23T12:10:22","guid":{"rendered":"https:\/\/silicondales.com\/?p=48212"},"modified":"2018-03-14T16:03:28","modified_gmt":"2018-03-14T16:03:28","slug":"scrub-html-openoffice-org-calc","status":"publish","type":"post","link":"https:\/\/silicondales.com\/tutorials\/scrub-html-openoffice-org-calc\/","title":{"rendered":"How to Scrub HTML from OpenOffice.org Calc"},"content":{"rendered":"<p>If you&#8217;re importing and exporting content from websites via CSV it can be useful to scrub the HTML or formatting from descriptions and product details.<\/p>\n<p>On OpenOffice.org Calc you can do this by going to Edit &gt; Find &amp; Replace<\/p>\n<figure id=\"attachment_48213\" aria-describedby=\"caption-attachment-48213\" style=\"width: 205px\" class=\"wp-caption aligncenter\"><img decoding=\"async\" class=\"size-full wp-image-48213\" src=\"https:\/\/silicondales.com\/wp-content\/uploads\/2014\/05\/openoffice-calc-find-and-replace-feature.jpg\" alt=\"OpenOffice.org Calc Find &amp; Replace option\" width=\"215\" height=\"535\" \/><figcaption id=\"caption-attachment-48213\" class=\"wp-caption-text\">OpenOffice.org Calc Find &amp; Replace option<\/figcaption><\/figure>\n<p>Search for\u00a0<span style=\"color: #ff0000;\">&lt;.*&gt;<\/span><\/p>\n<p>Replace with: nothing<\/p>\n<figure id=\"attachment_48214\" aria-describedby=\"caption-attachment-48214\" style=\"width: 425px\" class=\"wp-caption aligncenter\"><a href=\"https:\/\/silicondales.com\/wp-content\/uploads\/2014\/05\/find-and-replace-to-scrub-html-libreoffice-calc.jpg\"><img decoding=\"async\" class=\"size-full wp-image-48214\" src=\"https:\/\/silicondales.com\/wp-content\/uploads\/2014\/05\/find-and-replace-to-scrub-html-libreoffice-calc.jpg\" alt=\"Find and replace to scrub HTML from LibreOffice.org Calc\" width=\"435\" height=\"330\" \/><\/a><figcaption id=\"caption-attachment-48214\" class=\"wp-caption-text\">Find and replace to scrub HTML from LibreOffice.org Calc<\/figcaption><\/figure>\n<p>Your content will be scrubbed of HTML formatting &#8211; at least everything that was between the relevant tags will be taken out.<\/p>\n<p>This formula should also work in word processing and other documents, but be sure to save a copy before you try!<\/p>\n","protected":false},"excerpt":{"rendered":"<p>If you&#8217;re importing and exporting content from websites via CSV it can be useful to scrub the HTML or formatting from descriptions and product details. On OpenOffice.org Calc you can do this by going to Edit &gt; Find &amp; Replace Search for\u00a0&lt;.*&gt; Replace with: nothing Your content will be scrubbed of HTML formatting &#8211; at &#8230; <\/p>\n<p class=\"read-more-container\"><a title=\"How to Scrub HTML from OpenOffice.org Calc\" class=\"read-more button\" href=\"https:\/\/silicondales.com\/tutorials\/scrub-html-openoffice-org-calc\/#more-48212\" aria-label=\"Read more about How to Scrub HTML from OpenOffice.org Calc\">Read more<\/a><\/p>\n","protected":false},"author":2,"featured_media":49416,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[13,9],"tags":[259,815,989,1562],"acf":[],"amp_enabled":true,"_links":{"self":[{"href":"https:\/\/silicondales.com\/wp-json\/wp\/v2\/posts\/48212"}],"collection":[{"href":"https:\/\/silicondales.com\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/silicondales.com\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/silicondales.com\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/silicondales.com\/wp-json\/wp\/v2\/comments?post=48212"}],"version-history":[{"count":0,"href":"https:\/\/silicondales.com\/wp-json\/wp\/v2\/posts\/48212\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/silicondales.com\/wp-json\/wp\/v2\/media\/49416"}],"wp:attachment":[{"href":"https:\/\/silicondales.com\/wp-json\/wp\/v2\/media?parent=48212"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/silicondales.com\/wp-json\/wp\/v2\/categories?post=48212"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/silicondales.com\/wp-json\/wp\/v2\/tags?post=48212"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}