{"id":1674,"date":"2021-10-24T05:38:13","date_gmt":"2021-10-24T05:38:13","guid":{"rendered":"https:\/\/lgildv5i97.onrocket.site\/answers\/?post_type=question&p=1674"},"modified":"2021-10-24T05:38:36","modified_gmt":"2021-10-24T05:38:36","slug":"read-from-csv-file-using-batch-script","status":"publish","type":"question","link":"https:\/\/computing.net\/answers\/programming\/read-from-csv-file-using-batch-script\/29918.html","title":{"rendered":"Read From CSV File Using Batch Script"},"content":{"rendered":"

I have csv files with 4 rows:
\njohn,16,male,9898989898
\ntom,19,male,8787878787
\ntia,22,female,6767676767<\/p>\n

if i used below command:
\n@echo off
\ncls
\nsetlocal enabledelayedexpansion<\/p>\n

set \/p header=<test.csv<\/p>\n

for \/f “skip=1 tokens=*” %%A in (test.csv) do (
\nset inline=%%A<\/p>\n

for \/f “tokens=1-4 delims=,” %%1 in (“!inline!”) do (
\nset col1=%%1&set; col2=%%2&set; col3=%%3&set; col4=%%$
\necho %%1,%%2,%%3,%%4>output2.csv<\/p>\n

)
\n)<\/p>\n

type output2.csv<\/p>\n

The result will be:
\ntia,22,female,6767676767<\/p>\n

what if i have 100 lines and i want to display maybe few lines?<\/p>\n

i want to display 4 columns but i want to display like this:<\/p>\n

First person = john,16,male,9898989898
\nSecond person = tom,19,male,8787878787
\nThird person = tia,22,female,6767676767<\/p>\n

any help?<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"inline_featured_image":false,"iawp_total_views":4},"question-category":[55],"question_tags":[],"class_list":["post-1674","question","type-question","status-publish","hentry","question-category-programming"],"jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/computing.net\/answers\/wp-json\/wp\/v2\/question\/1674","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/computing.net\/answers\/wp-json\/wp\/v2\/question"}],"about":[{"href":"https:\/\/computing.net\/answers\/wp-json\/wp\/v2\/types\/question"}],"author":[{"embeddable":true,"href":"https:\/\/computing.net\/answers\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/computing.net\/answers\/wp-json\/wp\/v2\/comments?post=1674"}],"wp:attachment":[{"href":"https:\/\/computing.net\/answers\/wp-json\/wp\/v2\/media?parent=1674"}],"wp:term":[{"taxonomy":"question-category","embeddable":true,"href":"https:\/\/computing.net\/answers\/wp-json\/wp\/v2\/question-category?post=1674"},{"taxonomy":"question_tags","embeddable":true,"href":"https:\/\/computing.net\/answers\/wp-json\/wp\/v2\/question_tags?post=1674"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}