- 帖子
- 8
- 积分
- 23
- 技术
- 0
- 捐助
- 0
- 注册时间
- 2018-11-25
|
[文本处理] .bat解析TXT多行多列显示,并生成.csv
"VarName" "TimeString" "VarValue" "Validity" "Time_ms"
"data1" "2018-11-24 22:14:21" 11.000000 1 43428926634.120369
"data2" "2018-11-24 22:14:21" 12.000000 1 43428926634.120369
"data3" "2018-11-24 22:14:21" 13.000000 1 43428926634.120369
"data4" "2018-11-24 22:14:21" 14.000000 1 43428926634.120369
"data5" "2018-11-24 22:14:21" 15.000000 1 43428926634.120369
"data6" "2018-11-24 22:14:21" 16.000000 1 43428926634.120369
"data7" "2018-11-24 22:14:21" 17.000000 1 43428926634.120369
"data8" "2018-11-24 22:14:21" 18.000000 1 43428926634.120369
"data1" "2018-11-24 22:14:52" 21.000000 1 43428926998.761574
"data2" "2018-11-24 22:14:52" 22.000000 1 43428926998.773148
"data3" "2018-11-24 22:14:52" 23.000000 1 43428926998.773148
"data4" "2018-11-24 22:14:52" 24.000000 1 43428926998.773148
"data5" "2018-11-24 22:14:52" 25.000000 1 43428926998.773148
"data6" "2018-11-24 22:14:52" 26.000000 1 43428926998.773148
"data7" "2018-11-24 22:14:52" 27.000000 1 43428926998.773148
"data8" "2018-11-24 22:14:52" 28.000000 1 43428926998.773148
"data1" "2018-11-24 22:15:20" 30.000000 1 43428927324.918976
"data2" "2018-11-24 22:15:20" 31.000000 1 43428927324.918976
"data3" "2018-11-24 22:15:20" 32.000000 1 43428927324.918976
"data4" "2018-11-24 22:15:20" 33.000000 1 43428927324.918976
"data5" "2018-11-24 22:15:20" 34.000000 1 43428927324.918976
"data6" "2018-11-24 22:15:20" 35.000000 1 43428927324.918976
"data7" "2018-11-24 22:15:20" 36.000000 1 43428927324.918976
"data8" "2018-11-24 22:15:20" 37.000000 1 43428927324.918976
"data1" "2018-11-24 22:15:49" 41.000000 1 43428927661.435181
"data2" "2018-11-24 22:15:49" 42.000000 1 43428927661.435181
"data3" "2018-11-24 22:15:49" 43.000000 1 43428927661.435181
"data4" "2018-11-24 22:15:49" 44.000000 1 43428927661.435181
"data5" "2018-11-24 22:15:49" 45.000000 1 43428927661.435181
"data6" "2018-11-24 22:15:49" 46.000000 1 43428927661.435181
"data7" "2018-11-24 22:15:49" 47.000000 1 43428927661.435181
"data8" "2018-11-24 22:15:49" 48.000000 1 43428927661.435181
"$RT_OFF$" "2018-11-24 22:15:53" 0 2 43428927698.993057
"$RT_COUNT$" 33
以上内容为TXT 如何通过.bat解析,并让其8行8列数据显示(显示如下,依次循环),并生成csv
data1 data2 data3 data4 data5 data6 data7 data8 time
11 12 13 14 15 16 17 18 2018/11/24 22:14
21 22 23 24 25 26 27 28 2018/11/24 22:14 |
|