中国DOS联盟

a	A	aa	1	2	3	4	5	6	7	8	9	10	11	12	13	14	15	16

b	B	bb	1	2

c	C	cc	1

d	D	dd	1	2	3	4	5

a	A	aa	1

a	A	aa	2

a	A	aa	3

a	A	aa	4

a	A	aa	5

a	A	aa	6

a	A	aa	7

a	A	aa	8

a	A	aa	9

a	A	aa	10

a	A	aa	11

a	A	aa	12

a	A	aa	13

a	A	aa	14

a	A	aa	15

a	A	aa	16

b	B	bb	1

b	B	bb	2

c	C	cc	1

d	D	dd	1

d	D	dd	2

d	D	dd	3

d	D	dd	4

d	D	dd	5

@echo off&&setlocal enabledelayedexpansion

for /f "tokens=1-20 delims=	" %%a in (A.txt) do (

>>A_1.txt echo %%a	%%b	%%c	%%d

>>A_1.txt echo %%a	%%b	%%c	%%e

>>A_1.txt echo %%a	%%b	%%c	%%f

>>A_1.txt echo %%a	%%b	%%c	%%g

>>A_1.txt echo %%a	%%b	%%c	%%h

>>A_1.txt echo %%a	%%b	%%c	%%i

>>A_1.txt echo %%a	%%b	%%c	%%j

>>A_1.txt echo %%a	%%b	%%c	%%k

>>A_1.txt echo %%a	%%b	%%c	%%l

>>A_1.txt echo %%a	%%b	%%c	%%m

>>A_1.txt echo %%a	%%b	%%c	%%n

>>A_1.txt echo %%a	%%b	%%c	%%o

>>A_1.txt echo %%a	%%b	%%c	%%p

>>A_1.txt echo %%a	%%b	%%c	%%q

>>A_1.txt echo %%a	%%b	%%c	%%r

>>A_1.txt echo %%a	%%b	%%c	%%s

>>A_1.txt echo %%a	%%b	%%c	%%t

	)

for /f "tokens=1-20 delims=	" %%a in (A_1.txt) do (

	if "%%d" neq "" >>B.txt echo %%a	%%b	%%c	%%d)

@echo off

(for /f "tokens=1-3,*" %%1 in (a.txt) do (

  for %%a in (%%4) do echo %%1 %%2 %%3 %%a

))>b.txt

Originally posted by tireless at 2009-5-21 05:59 AM:
如果每列的字符不含空格：

@echo off

(for /f "tokens=1-3,*" %%1 in (a.txt) do (

  for %%a in (%%4) do echo %%1 %%2 %%3 %%a

))>b.txt

 

@gawk "{for(i=4;i<=NF;i+=1)print $1,$2,$3,$i}" a.txt>b.txt