标题: [已结]文本 相同行数据分列输出 [打印本页]
作者: flybird2020 时间: 2009-5-21 05:42 标题: [已结]文本 相同行数据分列输出
A.txt内容如下：
期望输出结果到B.txt如下：
自己写了个笨代码，觉得十分丑陋。。。望达人指点
Last edited by flybird2020 on 2009-5-21 at 06:06 ]
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期望输出结果到B.txt如下：
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)Last edited by flybird2020 on 2009-5-21 at 06:06 ]
作者: tireless 时间: 2009-5-21 05:59
如果每列的字符不含空格：
@echo off
(for /f "tokens=1-3,*" %%1 in (a.txt) do (
for %%a in (%%4) do echo %%1 %%2 %%3 %%a
))>b.txt作者: flybird2020 时间: 2009-5-21 06:06
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
惭愧，FOR的用法我还是知道的太少了
完美的代码
作者: 26933062 时间: 2009-6-2 16:31
@gawk "{for(i=4;i<=NF;i+=1)print $1,$2,$3,$i}" a.txt>b.txt