{"id":42,"date":"2017-04-17T07:37:39","date_gmt":"2017-04-17T07:37:39","guid":{"rendered":"http:\/\/basicwebsitesolutions.com\/blog\/?p=42"},"modified":"2017-04-17T07:37:39","modified_gmt":"2017-04-17T07:37:39","slug":"php-tip-how-to-remove-columns-and-save-to-another-file","status":"publish","type":"post","link":"https:\/\/basicwebsitesolutions.com\/blog\/2017\/04\/17\/php-tip-how-to-remove-columns-and-save-to-another-file\/","title":{"rendered":"PHP tip : how to remove columns and save to another file"},"content":{"rendered":"<p>Hello guys,<\/p>\n<p>Had a special request to trim the csv fields in the file.<\/p>\n<p>After searching, found a code to satisfy the request.<\/p>\n<p>Posted the URL from the original link<\/p>\n<p>Enjoy,<\/p>\n<p>Coffee Cup<\/p>\n<p><a href=\"http:\/\/stackoverflow.com\/questions\/8608970\/writing-to-csv-using-fgetcsv\">http:\/\/stackoverflow.com\/questions\/8608970\/writing-to-csv-using-fgetcsv<\/a><\/p>\n<pre class=\"lang-php prettyprint prettyprinted\"><code><span class=\"pln\">$input <\/span><span class=\"pun\">=<\/span> <span class=\"str\">'input.txt'<\/span><span class=\"pun\">;<\/span><span class=\"pln\">\r\n$output <\/span><span class=\"pun\">=<\/span> <span class=\"str\">'output.txt'<\/span><span class=\"pun\">;<\/span>\r\n\r\n<span class=\"kwd\">if<\/span> <span class=\"pun\">(<\/span><span class=\"kwd\">false<\/span> <span class=\"pun\">!==<\/span> <span class=\"pun\">(<\/span><span class=\"pln\">$ih <\/span><span class=\"pun\">=<\/span><span class=\"pln\"> fopen<\/span><span class=\"pun\">(<\/span><span class=\"pln\">$input<\/span><span class=\"pun\">,<\/span> <span class=\"str\">'r'<\/span><span class=\"pun\">)))<\/span> <span class=\"pun\">{<\/span><span class=\"pln\">\r\n    $oh <\/span><span class=\"pun\">=<\/span><span class=\"pln\"> fopen<\/span><span class=\"pun\">(<\/span><span class=\"pln\">$output<\/span><span class=\"pun\">,<\/span> <span class=\"str\">'w'<\/span><span class=\"pun\">);<\/span>\r\n\r\n    <span class=\"kwd\">while<\/span> <span class=\"pun\">(<\/span><span class=\"kwd\">false<\/span> <span class=\"pun\">!==<\/span> <span class=\"pun\">(<\/span><span class=\"pln\">$data <\/span><span class=\"pun\">=<\/span><span class=\"pln\"> fgetcsv<\/span><span class=\"pun\">(<\/span><span class=\"pln\">$ih<\/span><span class=\"pun\">)))<\/span> <span class=\"pun\">{<\/span>\r\n        <span class=\"com\">\/\/ this is where you build your new row<\/span><span class=\"pln\">\r\n        $outputData <\/span><span class=\"pun\">=<\/span><span class=\"pln\"> array<\/span><span class=\"pun\">(<\/span><span class=\"pln\">$data<\/span><span class=\"pun\">[<\/span><span class=\"lit\">0<\/span><span class=\"pun\">],<\/span><span class=\"pln\"> $data<\/span><span class=\"pun\">[<\/span><span class=\"lit\">1<\/span><span class=\"pun\">],<\/span><span class=\"pln\"> $data<\/span><span class=\"pun\">[<\/span><span class=\"lit\">4<\/span><span class=\"pun\">],<\/span><span class=\"pln\"> $data<\/span><span class=\"pun\">[<\/span><span class=\"lit\">5<\/span><span class=\"pun\">],<\/span><span class=\"pln\"> $data<\/span><span class=\"pun\">[<\/span><span class=\"lit\">6<\/span><span class=\"pun\">]);<\/span><span class=\"pln\">\r\n        fputcsv<\/span><span class=\"pun\">(<\/span><span class=\"pln\">$oh<\/span><span class=\"pun\">,<\/span><span class=\"pln\"> $outputData<\/span><span class=\"pun\">);<\/span>\r\n    <span class=\"pun\">}<\/span><span class=\"pln\">\r\n\r\n    fclose<\/span><span class=\"pun\">(<\/span><span class=\"pln\">$ih<\/span><span class=\"pun\">);<\/span><span class=\"pln\">\r\n    fclose<\/span><span class=\"pun\">(<\/span><span class=\"pln\">$oh<\/span><span class=\"pun\">);<\/span>\r\n<span class=\"pun\">}<\/span><\/code><\/pre>\n","protected":false},"excerpt":{"rendered":"<p>Hello guys, Had a special request to trim the csv fields in the file. After searching, found a code to satisfy the request. Posted the URL from the original link Enjoy, Coffee Cup http:\/\/stackoverflow.com\/questions\/8608970\/writing-to-csv-using-fgetcsv $input = &#8216;input.txt&#8217;; $output = &#8216;output.txt&#8217;; if (false !== ($ih = fopen($input, &#8216;r&#8217;))) { $oh = fopen($output, &#8216;w&#8217;); while (false !== &hellip; <\/p>\n<p class=\"link-more\"><a href=\"https:\/\/basicwebsitesolutions.com\/blog\/2017\/04\/17\/php-tip-how-to-remove-columns-and-save-to-another-file\/\" class=\"more-link\">Continue reading<span class=\"screen-reader-text\"> &#8220;PHP tip : how to remove columns and save to another file&#8221;<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[11],"tags":[43,48,45,46,47,42,44],"class_list":["post-42","post","type-post","status-publish","format-standard","hentry","category-php-and-mysql","tag-csv","tag-fclose","tag-fgetcsv","tag-fopen","tag-fputcsv","tag-php","tag-remove-columns"],"_links":{"self":[{"href":"https:\/\/basicwebsitesolutions.com\/blog\/wp-json\/wp\/v2\/posts\/42","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/basicwebsitesolutions.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/basicwebsitesolutions.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/basicwebsitesolutions.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/basicwebsitesolutions.com\/blog\/wp-json\/wp\/v2\/comments?post=42"}],"version-history":[{"count":1,"href":"https:\/\/basicwebsitesolutions.com\/blog\/wp-json\/wp\/v2\/posts\/42\/revisions"}],"predecessor-version":[{"id":43,"href":"https:\/\/basicwebsitesolutions.com\/blog\/wp-json\/wp\/v2\/posts\/42\/revisions\/43"}],"wp:attachment":[{"href":"https:\/\/basicwebsitesolutions.com\/blog\/wp-json\/wp\/v2\/media?parent=42"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/basicwebsitesolutions.com\/blog\/wp-json\/wp\/v2\/categories?post=42"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/basicwebsitesolutions.com\/blog\/wp-json\/wp\/v2\/tags?post=42"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}