我试图导入的Lotus Notes结构化文本的一些数据,我可以执行LINQ查询(I'm tr

2019-11-05 02:56发布

我“米甚至没有真的太知道如何处理这一点,但是这是我的问题如何处理这个:

我有这些实施例的许多(10000S),并且需要尽可能多的数据可能提取到一个数据类型的不同成员/列表。 因为它不是JSON或XML,我不认为我有反序列化选项。 也许正则表达式莫名其妙到用户定义的类数据?

Status:  In Process
Prefix:  18-
PlantLoc:  Lewiston
Date:  08/10/2018
Department:  FT
Time:  08/10/2018 02:08:30 PM
StationID:  177
Fixture:  initialization 
Supervisor:  Da Mi
PMOnly:  
PartNo:  0735
SerialNum:  
FailedStep:  Validate/Validate firmware
Reason:  Script
OtherReason:  
Details:  Initalization failure 
Urgency:  Script Problem
Date_1:  08/10/2018
Time_1:  08/10/2018 04:24:06 PM
Date_2:  
Time_2:  
ProblemFound:  
SolutionCode:  
Solution:  8/14/2018  TSR  SSR 18-07121 was also entered.  8/14/2018 GAH. The 735 units with B1492-6 boards fail during Test Flash possibly due to a timing issue in the script.  These particular board types have 1GB of flash and take longer for the flash test.  I will need to contact TMESoftware to see if the WAIT time can be increased for the 735 units with B1492-6-XX boards.  8/14/2018 GAH.  Details:  https://jira.metro.ad.selinc.com/browse/MTEN-1814
ServiceTechHrs:  
ServiceEngHrs:  
DocHistory:  Assignee #1 xxxxx xxxxx assigned by Alex xxxxx on 08/10/2018,Request submitted by xxxxx on 08/10/2018,Request created by xxxxx Olander on 08/10/2018
Mailed:  1
CloseDate:  
HoldOn:  
HoldOff:  
Authors:  *
ISAuthors:  IS Notes Developers; LocalDomainAdmins; LocalDomainServers
MgrData:  
SaveOptions:  1
IniDate:  08/10/2018
IniTime:  08/10/2018 02:08:30 PM
MOT:  
RequestNum:  07011
Initiator:  xxxxx xxxxx
Notification:  LWS Flex Leaders
ServiceTech:  xxxxx xxxxx
ServiceEng:  
SolutionCode_1:  
FixtureCheck:  Stop
Solution_1:  8/14/2018  TSR  SSR 18-07121 was also entered.  8/14/2018 GAH. The 735 units with B1492-6 boards fail during Test Flash possibly due to a timing issue in the script.  These particular board types have 1GB of flash and take longer for the flash test.  I will need to contact TMESofre to see if the WAIT time can be increased for the 735 units with B1492-6-XX boards.  8/14/2018 GAH.  Details:  https://jira.metro.ad.com/browse/MTEN-1814
$Revisions:  08/10/2018 02:17:28 PM,08/10/2018 02:17:29 PM,08/10/2018 04:24:06 PM,08/10/2018 04:24:07 PM,08/13/2018 08:34:47 AM,08/14/2018 02:59:06 PM,08/14/2018 03:02:59 PM

SupDoc:  SSR 18-07121 

这工作,但如何添加“仅值=” ServiceTech” &&重点=名为‘沃尔特’:

var bleh = SSRList.Where(x => x.ContainsKey("ServiceTechHrs"))                      
.Select(x => x["ServiceTechHrs"])                       
.Where(x => x != "")
.Sum(x => Convert.ToDouble(x))
.Dump("Total All Tech Hours");
文章来源: I'm trying to import Lotus Notes Structured Text as some data I can perform linq queries on