{"id":369,"date":"2018-02-14T19:02:28","date_gmt":"2018-02-14T19:02:28","guid":{"rendered":"https:\/\/career0to1.wordpress.com\/?p=369"},"modified":"2018-02-16T05:51:43","modified_gmt":"2018-02-16T05:51:43","slug":"batch-change-txt-to-csv","status":"publish","type":"post","link":"https:\/\/career0to1.com\/?p=369","title":{"rendered":"Batch change .txt to .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>@echo off<br \/>\nsetlocal enabledelayedexpansion<\/p>\n<p>for %%F in (*.txt) do (<br \/>\nset \/p .=Processing [%%~F] &#8230; &lt;nul<br \/>\nset &#8220;firstline=&#8221;<\/p>\n<p>(for \/f &#8220;tokens=* usebackq&#8221; %%a in (&#8220;%%~nxF&#8221;) do (<br \/>\nif not defined firstline (<br \/>\nset firstline=%%a<br \/>\necho !firstline:&#8221;=!<br \/>\n) else (<br \/>\necho %%a<br \/>\n)<br \/>\n))&gt;&#8221;%%~nF.CSV&#8221;<\/p>\n<p>echo [%%~nF.CSV]<br \/>\n)<br \/>\n<img loading=\"lazy\" class=\"alignnone size-full wp-image-370\" src=\"https:\/\/career0to1.com\/wp-content\/uploads\/2018\/02\/picture21.png\" alt=\"Picture2\" width=\"1094\" height=\"773\" srcset=\"https:\/\/career0to1.com\/wp-content\/uploads\/2018\/02\/picture21.png 1094w, https:\/\/career0to1.com\/wp-content\/uploads\/2018\/02\/picture21-600x424.png 600w, https:\/\/career0to1.com\/wp-content\/uploads\/2018\/02\/picture21-300x212.png 300w, https:\/\/career0to1.com\/wp-content\/uploads\/2018\/02\/picture21-768x543.png 768w, https:\/\/career0to1.com\/wp-content\/uploads\/2018\/02\/picture21-1024x724.png 1024w, https:\/\/career0to1.com\/wp-content\/uploads\/2018\/02\/picture21-150x106.png 150w\" sizes=\"(max-width: 1094px) 100vw, 1094px\" \/>Place it in your folder, together with all other .txt file.<br \/>\nDouble click .bat file, it will generate the .txt file the same name as the .csv file.<br \/>\n<img loading=\"lazy\" class=\"alignnone size-full wp-image-371\" src=\"https:\/\/career0to1.com\/wp-content\/uploads\/2018\/02\/capture2.png\" alt=\"Capture\" width=\"334\" height=\"482\" srcset=\"https:\/\/career0to1.com\/wp-content\/uploads\/2018\/02\/capture2.png 334w, https:\/\/career0to1.com\/wp-content\/uploads\/2018\/02\/capture2-208x300.png 208w, https:\/\/career0to1.com\/wp-content\/uploads\/2018\/02\/capture2-104x150.png 104w\" sizes=\"(max-width: 334px) 100vw, 334px\" \/><\/p>\n<\/div><\/div>","protected":false},"excerpt":{"rendered":"<p>Please copy the following into the notepad, change the suffix to .bat @echo off setlocal enabledelayedexpansion for %%F in (*.txt) do ( set \/p .=Processing [%%~F] &#8230; &lt;nul set &#8220;firstline=&#8221; (for \/f &#8220;tokens=* usebackq&#8221; %%a in (&#8220;%%~nxF&#8221;) do ( if not defined firstline ( set firstline=%%a echo !firstline:&#8221;=! ) else &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\/369"}],"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=369"}],"version-history":[{"count":1,"href":"https:\/\/career0to1.com\/index.php?rest_route=\/wp\/v2\/posts\/369\/revisions"}],"predecessor-version":[{"id":488,"href":"https:\/\/career0to1.com\/index.php?rest_route=\/wp\/v2\/posts\/369\/revisions\/488"}],"wp:attachment":[{"href":"https:\/\/career0to1.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=369"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/career0to1.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=369"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/career0to1.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=369"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}