我想请问一个bat取CSV中某几列的值
天使会疯狂 2017-01-18 01:15:28 我想请问一个bat取CSV中某几列的值,但是CSV列有43个,取的也要38个。。超过个26的限定。。
用户ID,省份,性别,年龄,注册日期,1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33
112260,内蒙古,男,22,2011/2/6,f2,g2,h2,i2,j2,k2,l2,m2,n2,o2,p2,q2,r2,s2,t2,u2,v2,w2,x2,y2,z2,aa2,ab2,ac2,ad2,ae2,af2,ag2,ah2,ai2,aj2,ak2,al2
以下是我的代码,可以取出一些列。。但是超出限定。。找了很多资料都搞不定。。。求高手指点下
for /f "delims=" %%a in ('dir /b *.csv') do (
for /f "tokens=1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39 delims=," %%b in ('type "%%a"') do (
echo %%b,%%c,%%d,%%e,%%f,%%g,%%h,%%i,%%j,%%k,%%l,%%m,%%n,%%o,%%p,%%q,%%r,%%s,%%t,%%u,%%v,%%w,%%x,%%y,%%z,"%%aa",%%2,%%3>>csv.txt
)
)
pause