ExcelHome技术论坛

 找回密码
 免费注册

QQ登录

只需一步,快速开始

快捷登录

搜索
EH技术汇-专业的职场技能充电站 妙哉!函数段子手趣味讲函数 Excel服务器-会Excel,做管理系统 Excel Home精品图文教程库
HR薪酬管理数字化实战 Excel 2021函数公式学习大典 Excel数据透视表实战秘技 打造核心竞争力的职场宝典
300集Office 2010微视频教程 数据工作者的案头书 免费直播课集锦 ExcelHome出品 - VBA代码宝免费下载
用ChatGPT与VBA一键搞定Excel WPS表格从入门到精通 Excel VBA经典代码实践指南
查看: 2458|回复: 13

[求助] 求解析下面文件的方法

[复制链接]

TA的精华主题

TA的得分主题

发表于 2018-2-10 15:49 | 显示全部楼层 |阅读模式
求解析下面文件的方法,我按照文本来解析,似乎只能都第一行,后面就安装EOF(1)退出循环了
希望能够解析到【】字段的信息,并能够方便后面的数据引用
各位大神支支招!
都来挑战一下吧!
[Index]
Format=ProductReport
Version=1.0000
Machine=NPM
Date=2018/02/08,00:00:02
AuthorType=Machine
Author=
Diff=
MJSID="DT474-NMB08110S_D202-7TQ10"
Comment=""

[Information]
Stage=1
Lane=1
Serial=3153435
SerialStatus=0
Code="1181780200685"
BcrStatus=0
ProductID="14165"
Rev=53
PlanID="0"
Output=3
LotName="NMB08110S_D202-F"
LotNumber=1

[Time]
PowerON=11569.66
Change=11.61
ProdView=0.00
Mente=0.00
DataEdit=0.00
UnitAdjust=0.00
Idle=0.00
Prod=11558.05
Actual=3946.29
Load=919.50
BRcg=261.06
Mount=3685.23
TotalStop=6692.26
Fwait=4369.80
Rwait=1354.22
Swait=0.00
Cwait=0.00
Bwait=0.00
Pwait=0.00
SCStop=79.03
SCEStop=58.81
OthrStop=0.00
CnvStop=0.00
BRcgStop=0.00
Trbl=0.00
MHRcgStop=0.00
FBStop=0.00
BNDRcgStop=0.00
CPErr=138.31
CRErr=16.95
CDErr=0.00
CMErr=0.00
CTErr=0.00
TRSErr=0.00
PRDStop=158.75
JudgeStop=0.00
OtherLStop=675.14
BNDStop=0.00
McFwait=1831.63
McRwait=649.66
JointPassWait=0.00

[CycleTime]
CTime1=23.40
CTime2=59.35
CTime3=23.89

[Count]
Board=170
Module=340
Fwait=126
Rwait=11
Swait=0
Cwait=0
Bwait=0
Pwait=0
SCStop=19
SCEStop=2
OthrStop=0
CnvStop=0
BRcgStop=0
Trbl=0
MHRcgStop=0
FBStop=0
BNDRcgStop=0
CPErr=6
CRErr=1
CDErr=0
CMErr=0
CTErr=0
TRSErr=0
TPickup=18367
TPMiss=6
TRMiss=1
TDMiss=0
TMMiss=0
THMiss=0
TRSMiss=0
JudgeStop=0
OtherLStop=120
BNDStop=0
TDispense=0
TPriming=0
LotBoard=170
LotModule=340
McFwait=88
McRwait=5
JointPassWait=0
TMount=18360

[Dispenser]
Head NHAdd BLKCode BLKSerial UseN NozzleName BondID UseB BondLibName Dispense Priming PSRErr

[MountPickupFeeder]
BLKCode BLKSerial UseF PartsName FAdd FSAdd ReelID UseR Pickup PMiss RMiss DMiss MMiss HMiss TRSMiss Mount LName TGSerial
"FB10" "FA0210AHD401261" 0 "SH000016M00" 20005 1 "JPIT1S7510D52Q" 0 341 1 0 0 0 0 0 340 "LCFC" "0000000000"
"FB10" "FA0210AKF403635" 0 "SD000016Z0T" 20008 1 "JZNH1H7500022X" 0 2040 0 0 0 0 0 0 2040 "LCFC" "0000000000"
"FB10" "FA0210AHD401261" 0 "SD00001YF0T" 20005 2 "JYAG2P75000B89" 0 340 0 0 0 0 0 0 340 "LCFC" "0000000000"
"FB10" "FA0210AZA472857" 0 "SC50000EY00" 20007 2 "12345H752008C6" 0 340 0 0 0 0 0 0 340 "LCFC" "0000000000"
"FB10" "FA0210AKF403635" 0 "SD028270A8T" 20008 2 "JYAG2P802001MY" 0 680 0 0 0 0 0 0 680 "LCFC" "0000000000"
"FB10" "FA0210AHF432457" 0 "SC50000G300" 10006 2 "12345H802013FS" 0 340 0 0 0 0 0 0 340 "LCFC" "0000000000"
"FB10" "FA0210BAA450464" 0 "SD03430118T" 20011 1 "JYAG2P75100LAK" 0 340 0 0 0 0 0 0 340 "LCFC" "0000000000"
"FB10" "FA0210AHF434317" 0 "SD00001YE0T" 20009 1 "JYAG2P80300EQY" 0 340 0 0 0 0 0 0 340 "LCFC" "0000000000"
"FB10" "FA0210AGF415967" 0 "SC300001G0J" 20010 1 "12345H806004DN" 0 340 0 0 0 0 0 0 340 "LCFC" "0000000000"
"FB10" "FA0210AKF400454" 0 "SA00005T00J" 10009 2 "12345H80300PT6" 0 340 0 0 0 0 0 0 340 "LCFC" "0000000000"
"FB10" "FA0210AHF434324" 0 "SC300003900" 20012 1 "12345H80300CBD" 0 340 0 0 0 0 0 0 340 "LCFC" "0000000000"
"FB10" "FA0210AKF400454" 0 "SHI0000G80J" 10009 1 "12345H80201C69" 0 341 0 1 0 0 0 0 340 "LCFC" "0000000000"
"FB20" "FA0220AFA592257" 0 "SA00007Q700" 20013 0 "JWTS1H8010EJX7" 0 340 0 0 0 0 0 0 340 "LCFC" "0000000000"
"FB20" "FA0220AAF313498" 0 "SJ10000J900" 10012 0 "JTXC1180105771" 0 340 0 0 0 0 0 0 340 "LCFC" "0000000000"
"FB20" "FA0220AHA350286" 0 "SA000084800" 10013 0 "12345H752005VF" 0 340 0 0 0 0 0 0 340 "LCFC" "0000000000"
"FB10" "FA0210AHF434317" 0 "SD00001678T" 20009 2 "JTAT1S80001835" 0 322 0 0 0 0 0 0 322 "LCFC" "0000000000"
"FB10" "FA0210AHF433009" 0 "SE00000PL0T" 10007 1 "12345H750004NZ" 0 936 0 0 0 0 0 0 936 "LCFC" "0000000000"
"FB10" "FA0210BBA452203" 0 "SA00005US0J" 10005 2 "12345H80500JHO" 0 620 0 0 0 0 0 0 620 "LCFC" "0000000000"
"FB10" "FA0210AHF433009" 0 "SP040004T0J" 10007 2 "JMCH1S75100014" 0 608 0 0 0 0 0 0 608 "LCFC" "0000000000"
"FB10" "FA0210BAA451065" 0 "SD00001V80T" 20006 1 "12345H804009O1" 0 1208 0 0 0 0 0 0 1208 "LCFC" "0000000000"
"FB10" "FA0210BAA451065" 0 "SE000010H0T" 20006 2 "JWAL1A75000086" 0 300 0 0 0 0 0 0 300 "LCFC" "0000000000"
"FB10" "FA0210AHF434729" 0 "SC30000340J" 10010 1 "12345H806000UU" 0 252 0 0 0 0 0 0 252 "LCFC" "0000000000"
"FB10" "FA0210AHF432457" 0 "SE00000QKMT" 10006 1 "JPIT1S8021LA9U" 0 1200 0 0 0 0 0 0 1200 "LCFC" "0000000000"
"FB10" "FA0210BBA452427" 0 "SHI0000JG00" 10011 2 "JCYN1C75140310" 0 226 0 0 0 0 0 0 226 "LCFC" "0000000000"
"FB10" "FA0210BBA452427" 0 "SH000011D00" 10011 1 "JCYN1C80146324" 0 214 0 0 0 0 0 0 214 "LCFC" "0000000000"
"FB10" "FA0210BBA452203" 0 "SC300003R00" 10005 1 "12345H80500RQ2" 0 330 0 0 0 0 0 0 330 "LCFC" "0000000000"
"FB10" "FA0210AZA472857" 0 "SD00001DV0T" 20007 1 "JCYN1C80352394" 0 484 1 0 0 0 0 0 483 "LCFC" "0000000000"
"FB10" "FA0210AGF415967" 0 "SC300002V0J" 20010 2 "JSAC1380301LR6" 0 126 0 0 0 0 0 0 126 "LCFC" "0000000000"
"FB10" "FA0210AHF402664" 0 "SB00001EY00" 10008 2 "12345H806008XH" 0 120 0 0 0 0 0 0 120 "LCFC" "0000000000"
"FB10" "FA0210AHF402664" 0 "SB00001AZ00" 10008 1 "12345H75200SB9" 0 332 0 0 0 0 0 0 332 "LCFC" "0000000000"

[MountPickupNozzle]
Head NHAdd NCAdd BLKCode BLKSerial UseR NozzleName Pickup PMiss RMiss DMiss MMiss HMiss TRSMiss Mount
2 1 221 "" "" 0 240 681 1 0 0 0 0 0 680
2 3 223 "" "" 0 230 1361 0 0 0 0 0 0 1361
2 2 222 "" "" 0 235 1192 0 0 0 0 0 0 1192
2 4 224 "" "" 0 230 1360 0 0 0 0 0 0 1360
2 5 211 "" "" 0 240 680 0 0 0 0 0 0 680
2 6 212 "" "" 0 235 1190 0 0 0 0 0 0 1190
2 7 213 "" "" 0 235 1018 0 0 0 0 0 0 1018
2 8 214 "" "" 0 230 1360 1 0 0 0 0 0 1359
1 1 121 "" "" 0 235 1193 0 0 0 0 0 0 1193
1 2 122 "" "" 0 235 1191 2 0 0 0 0 0 1189
1 3 123 "" "" 0 235 1191 1 0 0 0 0 0 1190
1 4 124 "" "" 0 235 1190 0 0 0 0 0 0 1190
1 5 111 "" "" 0 235 1190 0 0 0 0 0 0 1190
1 6 112 "" "" 0 235 1190 1 0 0 0 0 0 1189
1 7 113 "" "" 0 235 1190 0 0 0 0 0 0 1190
1 8 114 "" "" 0 235 1190 0 1 0 0 0 0 1189

[InspectionData]
Block=0
BadBoard=0
BadBlock=0
BadParts=0
OKParts=0
RetryBoard=0
LotBlock=0
LotBadBoard=0
LotBadBlock=0
LotBadParts=0
LotOKParts=0
LotRetryBoard=0

20180208000002000-09-1-1-3-NMB08110S_D202-F.zip

2.08 KB, 下载次数: 6

TA的精华主题

TA的得分主题

 楼主| 发表于 2018-2-10 18:03 | 显示全部楼层

TA的精华主题

TA的得分主题

发表于 2018-2-10 18:48 来自手机 | 显示全部楼层

TA的精华主题

TA的得分主题

 楼主| 发表于 2018-2-10 18:56 | 显示全部楼层

TA的精华主题

TA的得分主题

发表于 2018-2-10 20:47 | 显示全部楼层

因为根本 不知所云。。。。。。。。。。。。

TA的精华主题

TA的得分主题

 楼主| 发表于 2018-2-11 15:19 | 显示全部楼层
[广告] Excel易用宝 - 提升Excel的操作效率 · Excel / WPS表格插件       ★免费下载 ★       ★ 使用帮助
duquancai 发表于 2018-2-10 20:47
因为根本 不知所云。。。。。。。。。。。。

哪里不懂呀,亲

TA的精华主题

TA的得分主题

 楼主| 发表于 2018-2-11 15:56 | 显示全部楼层
需求其实很简单,就是解析带“【】”的节点下面的,各字段的信息
如:
[Index]
Format=ProductReport
Version=1.0000
Machine=NPM
Date=2018/02/08,00:00:02
AuthorType=Machine
Author=

要解析【Index】下,“format”,"version","machine“...等信息,存储在数组或者其他地方,因为后面会调用相关的信息



解析.PNG

TA的精华主题

TA的得分主题

发表于 2018-2-12 15:52 | 显示全部楼层

TA的精华主题

TA的得分主题

发表于 2018-2-12 16:00 | 显示全部楼层
[广告] VBA代码宝 - VBA编程加强工具 · VBA代码随查随用  · 内置多项VBA编程加强工具       ★ 免费下载 ★      ★使用手册
问问题的时候尽量把问题模型化表述,你写这么一堆东西重点在哪都不知道,大家没心思一行一行看

TA的精华主题

TA的得分主题

 楼主| 发表于 2018-2-21 21:42 | 显示全部楼层
您需要登录后才可以回帖 登录 | 免费注册

本版积分规则

手机版|关于我们|联系我们|ExcelHome

GMT+8, 2024-4-27 02:51 , Processed in 0.038281 second(s), 9 queries , Gzip On, MemCache On.

Powered by Discuz! X3.4

© 1999-2023 Wooffice Inc.

沪公网安备 31011702000001号 沪ICP备11019229号-2

本论坛言论纯属发表者个人意见,任何违反国家相关法律的言论,本站将协助国家相关部门追究发言者责任!     本站特聘法律顾问:李志群律师

快速回复 返回顶部 返回列表