{"id":364,"date":"2018-02-14T18:54:57","date_gmt":"2018-02-14T18:54:57","guid":{"rendered":"https:\/\/career0to1.wordpress.com\/?p=364"},"modified":"2018-02-14T18:54:57","modified_gmt":"2018-02-14T18:54:57","slug":"batch-merge-csv","status":"publish","type":"post","link":"https:\/\/career0to1.com\/?p=364","title":{"rendered":"Batch merge csv"},"content":{"rendered":"<div id=\"dslc-theme-content\"><div id=\"dslc-theme-content-inner\"><p>Please copy the following into the notepad, change the suffix to .bat<\/p>\n<p>for \/f %%a in (&#8216;dir \/b *.CSV&#8217;) do for \/f &#8220;tokens=*&#8221; %%b in (%%a) do echo %%b,%%a &gt;&gt; all.csv<br \/>\n<img loading=\"lazy\" class=\"alignnone  wp-image-366\" src=\"https:\/\/career0to1.com\/wp-content\/uploads\/2018\/02\/picture11.png\" alt=\"Picture1\" width=\"698\" height=\"117\" srcset=\"https:\/\/career0to1.com\/wp-content\/uploads\/2018\/02\/picture11.png 2300w, https:\/\/career0to1.com\/wp-content\/uploads\/2018\/02\/picture11-600x100.png 600w, https:\/\/career0to1.com\/wp-content\/uploads\/2018\/02\/picture11-300x50.png 300w, https:\/\/career0to1.com\/wp-content\/uploads\/2018\/02\/picture11-768x128.png 768w, https:\/\/career0to1.com\/wp-content\/uploads\/2018\/02\/picture11-1024x171.png 1024w, https:\/\/career0to1.com\/wp-content\/uploads\/2018\/02\/picture11-150x25.png 150w\" sizes=\"(max-width: 698px) 100vw, 698px\" \/>Place it in your folder, together with all other .csv file.<br \/>\nDouble click .bat file, it will generate the all.csv file with all if the csv merged with the source listed.<br \/>\n<img loading=\"lazy\" class=\"alignnone  wp-image-367\" src=\"https:\/\/career0to1.com\/wp-content\/uploads\/2018\/02\/picture12.png\" alt=\"Picture1\" width=\"725\" height=\"417\" srcset=\"https:\/\/career0to1.com\/wp-content\/uploads\/2018\/02\/picture12.png 2000w, https:\/\/career0to1.com\/wp-content\/uploads\/2018\/02\/picture12-600x345.png 600w, https:\/\/career0to1.com\/wp-content\/uploads\/2018\/02\/picture12-300x173.png 300w, https:\/\/career0to1.com\/wp-content\/uploads\/2018\/02\/picture12-768x442.png 768w, https:\/\/career0to1.com\/wp-content\/uploads\/2018\/02\/picture12-1024x589.png 1024w, https:\/\/career0to1.com\/wp-content\/uploads\/2018\/02\/picture12-150x86.png 150w\" sizes=\"(max-width: 725px) 100vw, 725px\" \/><\/p>\n<p>&nbsp;<\/p>\n<\/div><\/div>","protected":false},"excerpt":{"rendered":"<p>Please copy the following into the notepad, change the suffix to .bat for \/f %%a in (&#8216;dir \/b *.CSV&#8217;) do for \/f &#8220;tokens=*&#8221; %%b in (%%a) do echo %%b,%%a &gt;&gt; all.csv Place it in your folder, together with all other .csv file. Double click .bat file, it will generate the &hellip;<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0},"categories":[5],"tags":[9],"_links":{"self":[{"href":"https:\/\/career0to1.com\/index.php?rest_route=\/wp\/v2\/posts\/364"}],"collection":[{"href":"https:\/\/career0to1.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/career0to1.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/career0to1.com\/index.php?rest_route=\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/career0to1.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=364"}],"version-history":[{"count":0,"href":"https:\/\/career0to1.com\/index.php?rest_route=\/wp\/v2\/posts\/364\/revisions"}],"wp:attachment":[{"href":"https:\/\/career0to1.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=364"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/career0to1.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=364"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/career0to1.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=364"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}