I'm incredibly new at this, and I've tried searching but nothing I've found has been able to work for me.
I have xml data that looks like this
<datainfo> <data> <info State="1" Reason="x" Start="01/01/2016 00:00:00.000" End="01/01/2016 02:00:00.000"></info> <info State="1" Reason="y" Start="01/01/2016 02:00:00.000" End="01/01/2016 02:01:00.000"> <moreinfo Start="01/01/2016 02:00:00.000" End="01/01/2016 02:00:30.000"/> <moreinfo Start="01/01/2016 02:00:30.000" End="01/01/2016 02:01:00.000"/> </info> <info State="2" Start="01/01/2016 02:01:00.000" End="01/01/2016 02:10:00.000"></info> ... </data> </datainfo> I want find how much time was spent in State {1,2,...} for reason {x,y,...} on a specific day and have that print to a .csv format to be latter read in excel.
The issue I'm having is I can't use static variables because there are hundreds of different states for hundreds of different reasons, and they change constantly.
If I'm not clear please tell me, I am brand new to this and really appreciate any and all help.
No comments:
Post a Comment