|
I'm not sure about your issue and what you want to get ... but I think you should create your own (customized) de-serializer for the Text-file which creates the datatable in the way you need.
For that it coud be necessary the read the file line by line and put the Content into the cells od the datatable where you want to have it.
|
|
|
|
|
Hi Ralf,
I am very very new to programming and do it on a private basis to make my work easier.
My problems are:
1. I do not know how to use C# in a Winform to search for the dates in a text file that I open.
2. I do not know how to combine the date with the amount it finds for that date in a combobox.
3. I do not know how to automatically create a columns and fill it with 1 to 100 for the amount of records found in the text file.
4. I do not know how to get the information for the date into a datagridview.
I have been busy with this little program for over 3 weeks and have searched and searched and cannot find any solution.
Regards
|
|
|
|
|
You misunderstood ...
What I suggest to you is :
- build a method which reads your file (line by line) - there are several information for this to be found with Google
- all your lines are Strings
- if there are multiple information in one string(-line) then separate it
- now put you information-parts, which are relevant for you, into the DGV (directly or by a datatable - both ways exists)
|
|
|
|
|
I have managed to get some of the information into the combo box using the following code.
private void Historybutton_Click(object sender, EventArgs e)
{
DataTable HFdt = new DataTable();
DialogResult result3 = openFileDialog2.ShowDialog();
if (result3 == DialogResult.OK)
{
String Fname = openFileDialog2.FileName;
DateTime d = DateTime.Now;
var format = "yy/MM/dd-HH:mm:ss";
var fileDates = System.IO.File.ReadAllLines(Fname)
.Where(l => l.Length >= format.Length
&& DateTime.TryParseExact(l.Substring(0, format.Length)
, format
, CultureInfo.InvariantCulture
, DateTimeStyles.None
, out d)
)
.Select(l => d)
.OrderBy(dt => dt);
if (fileDates.Any())
{
DatecomboBox.Items.Add(fileDates.First());
DatecomboBox.Items.Add(fileDates.Last());
}
}
}
I am not sure if I am moving in the right direction or not.
Only snag now is I cannot get all the dates only the first and last.
When I change the last 2 to:
DatecomboBox.Items.Add(fileDates);
My result in my Combobox is:
System.Linq.OrderedEnumerable`2[System.DateTime,System.DateTime]
Any suggestions are welcome.
|
|
|
|
|
Have you seen the Suggestion of Bill Woodruff ?
In my opinion you go completly into the wrong direction.
PLEASE - do it step by step.
I suggest :
- build a method which reads your text-file into an List(of string) - or an Array of string - like you want
- build some Variables which represent the data you are interested in - perhaps in the right type-Format
- look into your list (with the Debugger) which entry has which Information
- try to extract the Information you want out of the List-Element, if necessaery cast it into the right Format and now assign it to the right Variable
- if the first Variable is succesful assigned do the same with the next Variable (and so on)
- do the complete work at the beginning with the Debugger - it's a very mighty tool which Shows you what REALLY happens
Of course I could write the code for you - but I think that would be not helpful for you because you must understand it ...
|
|
|
|
|
I have taken your advise to heart and have managed some breakthrough, but now do really not know what to do next.
My code to read the txt file is as follows:
String Fname = openFileDialog2.FileName;
string[] raw_text = System.IO.File.ReadAllLines(Fname);
var lines = new List<string>();
foreach (var line in File.ReadLines(Fname))
{
listBox1.Items.Add(line);
}
I return the lines to a hidden listbox as I do not know how to return it to a datatable.
I then find the dates in the txt file and return it to the combobox as follows:
List<DateTime> logDates = new List<DateTime>();
string dets;
string pattern = @"(?<logDate>(\d){2}/(\d){2}/(\d){2})";
Regex reg = new Regex(pattern);
string logContent = File.ReadAllText(Fname);
MatchCollection matches = reg.Matches(logContent);
foreach (Match m in matches)
{
DateTime logTime = DateTime.Parse(m.Groups["logDate"].Value);
logDates.Add(logTime);
DatecomboBox.Items.Add(logTime);
object[] distinctItems = (from object o in DatecomboBox.Items select o).Distinct().ToArray();
DatecomboBox.Items.Clear();
DatecomboBox.Items.AddRange(distinctItems);
}
I really appreciate that you do not write the code for me as I am enjoying learning this.
BUT, am I now going in the right direction?
How do I now combine the amount of dets with the dates in the combobox?
More importantly, how do I only show the information between the combobox selected date and the next date in the listbox?
I strongly believe that if I get someone to explain how regex works or how to search the txt file for the information I need and extract the information I can work on and try to figure out the rest myself.
As for the rules:
1. Read the txt file into lines - DONE
2. Find all distinct dates in the txt file - DONE (Still need to use time as well as dates could be same)
3. Show only information for the selected date and time in the listbox - NOT DONE
4. Find the amount of dets in the listbox usually in this format: 1 PU, 00234 DETS where 1 could be 2 or 3 and 00234 could be from 00001 to 04500 and show in second combobox - NOT DONE
5. Extract the detonator information from the list box for the amount of dets selected into a datagridview. - CAN BE DONE - Extract to Datatable using parser and then to Datagridview.
Help please.
|
|
|
|
|
One Step after the other ...
You could read your file into a Combobox or Listbox to have a look at the content. But you could also read it into a List(of String).
Now you have (also in the Combobox) perhaps 50 lines.
Now you should not try to convert each line into a date and look which date matches - you better analyse the content of your lines and do the necessary Action.
I think, you don't understand what I mean / how I think ... 
Let's start from the beginning (step by step).
You have posted the content of your textfile. Now tell me which part's of it are important for you (and which later format do/should they have).
|
|
|
|
|
Quote:
17/04/20-17:27:30:BLAST DRIVER ON
-
BLASTING PLAN
PU0527 (0295 DETS):
1539/F53F23;2031/115544;1588/117A35;2080/11541C;1637/F5363C;2129/11921B;1686/119026;2178/F59E70;1735/F5729B;2227/F57D20;
1784/F61B6B;2276/F5EE45;1833/F536D8;2325/F57F47;1882/F548E5;2374/F53E56;1931/F5B4C7;2423/F5937F;1980/F58F0F;2472/F5A73F;
2029/F5FDDE;2521/F5A179;2078/F57D0E;2570/F5978B;2127/F5EED3;2619/F5D16E;2176/F593F4;2668/F5787D;2225/F59955;2717/F5E8FD;
2274/F5A463;2766/F5ECF7;2323/F60166;2815/F5404D;2372/F54295;2864/F53964;2421/F59F94;2913/F591DD;2470/F59494;2962/F5E7D2;
1155/F59B81;1347/F542EA;1204/F53E47;1396/F52FA6;1253/F61F2D;1445/F540EC;1302/F5EBBB;1494/F5E9CF;1351/F52F0C;1543/F53CE4;
1400/F5356D;1592/F5E232;1449/F57047;1641/F54849;1498/F541B9;1690/F5860C;1547/F5387B;1739/F5E765;1596/F5999C;1788/F5F3A8;
1645/F572DB;1837/F5B238;1694/F5F378;1886/F5F205;1743/F537CC;1935/F53DFD;1792/F5C886;1984/F5776A;1841/F56E6C;2033/F58688;
1890/F5AB3D;2082/F598BB;1939/F542D4;2131/F5F4F1;1988/F57DFA;2180/F57C7C;2037/F53477;2229/F57762;2086/F53121;2278/F539DA;
771/F53B40;963/F530DB;820/F5326B;1012/F5358E;869/F546F4;1061/F53FC1;918/F541E0;1110/F5382C;967/F53E72;1159/11E241;
1016/115568;1208/F57880;1065/11E700;1257/118E17;1114/1152FF;1306/1155EB;1163/F56FFB;1355/11FE42;1212/F5717E;1404/F54D1E;
1261/F570B7;1453/F53A85;1310/F574E4;1502/F574CD;1359/F5356A;1551/F53926;1408/F53CAD;1600/F53F3B;1457/F572B5;1649/F53060;
1506/F5F2BB;1698/F5A921;1555/F5F2B5;1747/F5B1F2;1604/F537D3;1796/F58111;1653/F61A00;1845/F5742E;1702/F5750D;1894/F53C31;
387/F53C7C;579/F5734E;436/F53C60;628/F57021;485/F5E5CF;677/F5E94F;534/F57792;726/F53DA1;583/F5E5E6;775/F5B34F;
632/F53C41;824/F53CBE;681/F57763;873/F57723;730/F57182;922/F57701;779/F53A83;971/F534D0;828/F547A7;1020/F5B598;
877/F53E13;1069/F53686;926/F5462F;1118/F5720F;975/F533C7;1167/F57308;1024/F5702F;1216/F58233;1073/F5E30D;1265/F5726B;
1122/F53745;1314/F57545;1171/F58E6A;1363/F5987D;1220/F54D91;1412/F5ABF3;1269/F54440;1461/F537F4;1318/F57C31;1510/F57749;
1367/F56EC2;1559/F5EF73;1416/F59059;1608/F59D79;1465/F5493E;1657/F56ED2;1514/F53235;1706/F543FD;1563/F61C7C;1755/F52F99;
1612/F5467C;1804/F57877;1661/F543C3;1853/F5F5E3;1710/F58CDA;1902/F5F651;1759/F545EE;1951/F57023;1808/F58099;2000/F534DA;
1751/F59824;1943/F57B0E;1800/F5490C;1992/F54532;1849/F541C6;2041/F59309;1898/F53E9D;2090/F53BBD;1947/F5FB8D;2139/F56E31;
1996/F57FDD;2188/F59B54;2045/F598E4;2237/F597A0;2094/F5703E;2286/F5F2FF;2143/F57326;2335/F572BE;2192/F54086;2384/F53C22;
2135/F61800;2327/F58249;2184/F571C0;2376/F5816A;2233/F61F28;2425/F573FC;2282/F60FEE;2474/F58974;2331/F5972B;2523/F59711;
2380/F57403;2572/F53769;2429/F61BC5;2621/F5E4D8;2478/F57CB7;2670/F53ADF;2527/F59FF7;2719/F5E07F;2576/F5ED50;2768/F5952E;
2519/F5B499;3011/F58F1E;2568/F5394E;3060/F599E7;2617/F57976;3109/F548FE;2666/F5AECE;3158/F540DB;2715/F5B2BE;3207/F537B3;
2764/F5AE12;3256/F61A28;2813/F548EE;3305/F57A99;2862/F61DF2;3354/F5AA16;2911/F5901C;3403/F57D9F;2960/F54D4F;3452/F5997E;
3009/F57A3F;3501/F59FB3;3058/F59A2B;3550/F5BDF6;3107/F5763A;3599/F53055;3156/F5A115;3648/F577EF;3205/F54117;3997/F5F542;
3554/F61B24;2625/F59DF7;2817/F576F2;2674/F57F5B;2866/F5A03C;2723/F5E514;2915/F61FC3;2772/F59C84;2964/F5C82E;2821/F5342D;
3013/F5F1B1;2870/F570C0;3362/F54206;3219/F5EDC2;2241/F56F81;2433/F59F2A;2290/F53528;2482/F54550;2339/F57F1B;2531/F57FDC;
2388/F5EE98;2580/F572FA;2437/F53B6C;2486/F5B0B7;2486/F5A84A;2294/F53F7C;2629/F53726;2678/F57E70;2678/F57AFA;2835/F61778;
3027/F5B596;3027/F5B2E0;1857/F57FD5;2049/F5F69E;1906/F5813D;2098/F57933;1955/F5868B;2147/F57975;2004/F5AA5E;2196/F54B1E;
2053/F57120;2245/F53DBE;2102/F58F77;2451/F5AD8F;2643/F53160;
PU0528 (0272 DETS):
2029/F58D7F;1537/F5AA3F;2078/F5AB37;1586/F57F5C;2127/F5B00E;1635/F53F41;2176/F53F5D;1684/F54236;2225/F53079;1733/F56F35;
2274/F581A0;1782/12F43C;2323/12C912;1831/1315B0;2372/12EC84;1880/12CFE6;2421/12EC57;1929/12F4A9;2470/12ECAC;1978/131A82;
2519/131D1A;2027/12D392;2568/12C961;2076/12CB4B;2617/1316C9;2125/12CFAA;2666/12CA7E;2174/12D423;2715/1153CE;2223/1151DB;
2764/115334;2272/12D473;2813/131975;2321/115381;2862/117A0D;2370/131AF0;2911/114AB8;2419/115482;2960/119A66;2468/128098;
3009/1191A7;2517/12ED0B;3058/115645;2566/13156A;3107/11D9ED;2615/12CFF4;3156/12CFB3;2664/13196A;3205/12D53A;2713/131B16;
3254/115638;2762/11538E;3303/12CF54;2811/12D55A;3352/115683;2860/114B30;3401/114A73;2909/1319F9;3450/11DA6A;2958/131A52;
3499/114027;3007/131A08;3548/11BCF2;3056/117945;3597/131AA8;3105/1179B7;3646/119222;3154/131AA0;3995/1150DA;3503/117911;
1345/F53CC8;1153/F5B196;1394/F57499;1202/F54AC4;1443/F587AE;1251/F59B42;1492/12F417;1300/131A84;1541/12F40D;1349/12D6DA;
1590/12C41D;1398/12ED14;1639/12F3F7;1447/131A76;1688/131C2C;1496/12D424;1737/12C5D6;1545/131D5B;1786/12EC91;1594/12C9DC;
1835/131CCD;1643/12CA16;1884/12B8CE;1692/12C3D3;1933/12D372;1741/12CA87;1982/131AED;1790/12CE89;2031/131C03;1839/1322E3;
2080/13235C;1888/1322B7;2129/1314B6;1937/1322A8;2178/132333;1986/1315B1;2227/1314FC;2035/13234B;2276/1315AA;2084/1322C3;
2325/13232B;2133/1323DC;2374/12D022;2182/1316A2;2423/12CB39;2231/12CDDC;2472/131AE1;2280/12CE10;2521/1315E6;2329/12CC72;
2570/12EBFC;2378/12EC19;2619/12CE6B;2427/12EC43;2668/12CA62;2476/12CE52;2717/12CE99;2525/12CAF4;2766/12F402;2574/12D051;
2815/12CE03;2623/12CB15;2864/131A2C;2672/12EC59;2913/115618;2721/12EC13;2962/125658;3070/115108;3311/12CFA4;3311/12CF89;
961/F5702A;769/F5E34A;1010/F57710;818/F5741C;1059/F544A6;867/F53685;1108/F5D7CD;916/1324E5;1157/12EC71;965/131A5B;
1206/131A88;1014/12CB1B;1255/12ECE8;1063/12F3E6;1304/131AD0;1112/12C9B4;1353/131D1D;1161/12ECC7;1402/12C90F;1210/12EC10;
1451/131CF5;1259/12B852;1500/12ECED;1308/13163D;1549/12EC2D;1357/12EBDF;1598/12CDF9;1406/1314C7;1647/131701;1455/131586;
1696/132389;1504/131E4B;1745/1322E4;1553/1326B0;1794/132325;1602/1326E6;1843/1322BC;1651/11E696;1892/1153DE;1700/119147;
1941/119D53;1749/11568F;1990/1315EC;1798/11530D;2039/131474;1847/131AEC;2088/12CED1;1896/12CE2E;2137/12CC67;1945/12CDFA;
2186/12CBD0;1994/12CE48;2235/12EBD3;2043/12EBE5;2284/12EC40;2092/131953;2333/12EC29;2141/12D02F;2382/12F373;2190/12CE0B;
2431/12C925;2239/12ED0A;2480/12CE30;2288/12CB02;2529/12D53D;2637/12CB67;2878/12C949;577/F56FCC;385/F53B45;626/F54405;
434/F54BFA;675/F5E5D6;483/F53FD5;724/F54AC6;532/F54298;773/12C95F;581/12C934;822/131A60;630/12CAB7;871/12C955;
679/131956;920/132055;728/13161F;969/131C7F;777/12C551;1018/12C55D;826/12EC94;1067/12B939;875/12EC26;1116/132092;
924/12CF06;1165/131FA3;973/12D0D2;1214/132294;1022/1322BE;1263/132352;1071/13238B;1312/131527;1120/131DBC;1361/13154D;
1169/1323D1;1410/1326B3;1218/1322D9;1459/132309;1267/1150D0;1508/1155E2;1316/11519B;1557/118EB9;1365/115234;1606/115463;
1414/12CE56;1655/12CEBD;1463/12CBBF;1704/12CB58;1512/12CE2F;1753/12F357;1561/12F41B;1802/131B04;1610/12CEEC;1851/12C8B8;
1659/12F38B;1900/12CC1C;1708/12CE38;1949/12CC40;1757/12CBC7;1998/12CC2D;1806/12D238;2047/12C8FE;2155/12D4E5;2155/12D160;
2396/12C8DC;2396/12D0A0;
-
BLAST SUMMARY
2 PU, 00567 DETS
DELAYS MIN/MAX IN MS : 00385 / 03997
GAP MIN/MAX IN MS : 00000 / 00347
-
17:27:56:LINE TEST
-
CALIBRATION
-
EXTRA DETS :None
INTERMITTENT CONNECTION DETS :None
-
TEST DETS
MISSING DETS :None
OUT OF ORDER DETS :None
INCOHERENT DETS :None
DELAY ERRORS DETS :None
-
17:32:35:TEST END
-
17:33:20:CHARGE
-
CHECK ENERGIE
ADDITIONAL MISSING DETS :None
LOW ENERGY DETS :None
ADDITIONAL INCOHERENT DETS :None
-
17:33:50:FIRE
-
USER SOFTWARE : 1.5.02
DRIVER SOFTWARE : 1.3.02
RTOS SOFTWARE : 1.60
-
17/04/22-13:05:14:BLAST DRIVER ON
-
BLASTING PLAN
PU0528 (0234 DETS):
1347/E61584;1839/E5E447;1396/E64089;1888/E60359;1445/E63E4C;1937/E60A88;1494/E64125;1986/E5E8BF;1543/E680AB;2035/E670B1;
1592/E62A71;2084/E68338;1641/E683E6;2133/E67776;1690/E629CA;2182/E67A3A;1739/E68061;2231/E67DAF;1788/E67421;2280/E67094;
1837/E67E9E;2329/E5F800;1886/E64C74;2378/E6ABA0;1935/E6744D;2427/E67A0D;1984/E67884;2476/E65819;2033/E62965;2525/E67C83;
2082/E5D1C5;2574/E6AD6C;963/E5F987;1155/E5C9AC;1012/E64F8F;1204/E5DF63;1061/E5FDF0;1253/E63CEC;1110/E5C9B0;1302/E63C09;
1159/E5D4B6;1351/E5F7A2;1208/E6A8E0;1400/E680B1;1257/E60D81;1449/E621BC;1306/E6A71C;1498/E69F70;1355/E62E8D;1547/E60CF0;
1404/E64CAE;1596/E5FD4D;1453/E5EDF1;1645/E6A5B9;1502/E62850;1694/E67F0B;1551/E6A961;1743/E608AF;1600/E62617;1792/E671E3;
1649/E6AC1B;1841/E68B7C;1698/E67C36;1890/E68A27;579/E5F14A;771/E64170;628/E63D5B;820/E5D2B0;677/E5ECC3;869/E5C1D7;
726/E642A8;918/E5C7A2;775/E67C62;967/E627EA;824/E6273D;1016/E6A77B;873/E656A1;1065/E61E81;922/E6A3DD;1114/E67F89;
971/E699CC;1163/E65558;1020/E69B82;1212/E5F9EE;1069/E67970;1261/E64CD1;1118/E64D72;1310/E65181;1167/E64C6D;1359/E62D70;
1216/E62E09;1408/E6840B;1265/E6847C;1457/E6257B;1314/E654CE;1506/E689B4;387/E628A5;436/E5E0EF;485/E6037E;534/E62CEB;
583/E67B6A;632/E688B6;681/E6A8D3;730/E67C6D;779/E68C73;828/E6A7C6;877/E66F70;926/E649AC;975/E686EB;1024/E65373;
1073/E670B5;385/E5F56B;577/E5BE9F;434/E61D55;626/E5DBD3;483/E60183;675/E61998;532/E5D730;724/E5FDEE;581/E6189D;
773/E5F8D7;630/E5BF30;822/9DB373;679/9D90E6;871/9DCB63;728/9D9317;920/9E4E52;777/9E0732;969/9D8444;826/9D7DAB;
1018/9E5B83;875/9D72DD;875/9D87DE;1067/9D8627;924/9D82E3;1116/9E18B4;973/9DAA01;1165/9E2371;1022/9E18D7;1071/9DCB5A;
1120/9E3187;1169/9E3499;389/E5DBBC;246/9DFD0D;438/9D8ED6;295/9DB2C8;487/9DFA71;344/9E13F3;393/9E028F;442/9E14F2;
491/9DD1C7;769/E63A9D;961/E620D7;818/E5DF2D;1010/E5DF50;867/E62069;1059/E5C71E;916/E603FE;1108/E643A5;965/E5C115;
1157/E5D34D;1014/E618A7;1206/9D71E9;1063/9D6FB9;1255/9E0A62;1112/9D6DA4;1304/9E586C;1161/9E5828;1353/9E48F4;1210/9D745E;
1402/9E0384;1259/9E08B7;1451/9DFECA;1308/9E24D3;1500/9DEE3B;1357/9D6315;1549/9E02D0;1406/9DB179;1598/9E169B;1455/9E3C40;
1647/9D71D1;1504/9D6FD2;1696/9D856D;1504/9E333B;1153/E5E034;1345/E5CA45;1202/E61D63;1394/E60B0F;1251/E6416E;1443/E63B3D;
1300/E6059C;1492/E61FE8;1349/E600B8;1541/E5DBE0;1398/E63B3E;1590/E63B6E;1447/9DE584;1639/E63BDC;1496/9E187D;1688/E65708;
1545/E62442;1737/E60491;1594/9D6771;1786/E5DF58;1643/9E2D9B;1835/E5C154;1692/9D8006;1884/9DDFE4;1741/9DB2B0;1933/9E3C91;
1790/9D8B65;1982/9D832E;1839/9D8BD3;2031/9DF899;1888/9E4C9F;1888/9D6D7B;2080/9D69E3;1837/E641F2;1886/E5C6E8;1935/E620F9;
1984/E623E3;2033/E6049B;2082/E61038;2131/E5C6F3;2180/E5EEA0;2229/E61581;2278/E60167;2327/9E2C02;2376/9D8378;2425/9E30A8;
2474/9E3F83;2523/9D8667;2572/9D6560;2621/9D64A9;
-
BLAST SUMMARY
1 PU, 00234 DETS
DELAYS MIN/MAX IN MS : 00246 / 02621
GAP MIN/MAX IN MS : 00000 / 00049
-
13:05:36:LINE TEST
-
CALIBRATION
-
EXTRA DETS :None
INTERMITTENT CONNECTION DETS :None
-
TEST DETS
MISSING DETS :None
OUT OF ORDER DETS :None
INCOHERENT DETS :None
DELAY ERRORS DETS :None
-
13:08:16:TEST END
-
13:09:03:CHARGE
-
CHECK ENERGIE
ADDITIONAL MISSING DETS :None
LOW ENERGY DETS :None
ADDITIONAL INCOHERENT DETS :None
-
13:09:31:FIRE
-
13:09:35: HIST.FILE.TRANSFERED
-
USER SOFTWARE : 1.5.02
DRIVER SOFTWARE : 1.3.02
RTOS SOFTWARE : 1.60
-
TRAME DU BECK =
DONE
-
TRAME DU BECK =
DONE
-
10:15:46:WIRING CHECK :
DONE
-
17/04/28-10:18:41:BLAST DRIVER SLAVE ON
-
BLASTING PLAN
PU0527 (0603 DETS):
5028/2D090C;4536/2CD320;5077/2D111C;4585/2CAF17;5126/2C9292;4634/2C8F45;5175/2C9FD8;4683/2D07A0;5224/2CD077;4732/2D06CE;
5273/2D06B9;4781/2CCE9C;5322/2D05C4;4830/2CD20C;5371/2CD0D8;4879/2CAE5E;5420/2C998B;4928/2D0610;5469/2D078A;4977/2D0776;
5518/E68768;5026/E6ACD2;5567/E62D30;5075/E6478E;5616/E64C25;5124/E6822D;5665/E65292;5173/E62BF8;5714/E684C0;5222/E67A94;
5763/E68C5F;5271/E6507F;5812/E65597;5320/E6AC01;5861/E67EF6;5369/8E887C;5910/E5E636;5418/8DF49F;5959/E67880;5467/987D3C;
6008/8E4FD2;5516/98BECD;6057/8DA8E8;5565/98B878;6106/8DAEC1;5614/98B91A;6155/8E11A9;5663/9880B3;6204/8E1BC0;5712/98BB2C;
6253/8DC89E;5761/989B05;6302/8DE921;5810/987978;6351/8C9632;5859/99091B;6400/8E2148;5908/994E27;6449/8D12B6;5957/9873BD;
6498/8DCC6E;6006/98742B;6547/8E898A;6055/9873DE;6596/8E79EE;6104/986FDA;6645/8DE707;6153/99375F;6694/8DF43E;6202/98805C;
6743/8DED0D;6251/994EF6;6792/8D6985;6300/9955B6;6841/8E84AD;6349/9955F6;6890/8CF1C9;6398/990220;6939/8E19A4;6447/987D4B;
6988/8E7D6D;6496/987E59;7037/8DC175;6545/989E96;7086/8E7312;6594/98D393;7135/8E7C3E;6643/987351;7184/8DBD66;6692/98A385;
7233/8E57FF;6741/98766B;7282/8E0665;6790/9E3B3C;7331/8DD15D;6839/9E14D9;7380/8DC1F2;6888/9E10A0;7429/8DD344;6937/9DEACC;
7478/8E211A;6986/9DE9E7;7527/8E16B1;7035/9DF29E;7576/8DC323;7084/9DF231;7625/8D8EE3;7133/9DEFA0;7674/8E82B2;7182/9E03F0;
7723/8D6DC9;7231/9E13E2;7772/8E1C74;7280/9E0806;7821/8E29D6;7329/9E5086;7870/8DEBDA;7378/8E1FEA;7919/8E7049;7427/8DAB65;
7968/8E0D46;7476/8D1AE7;8017/8E1D34;7525/8E1E18;8066/8E3431;7574/8DAF3F;8115/8DAE37;7623/8E2C62;8164/8D88E5;7672/8E5FC1;
8213/8E1F87;7721/8E4C98;8262/8DC332;7770/8E41BB;8311/8E6E57;7819/8DC811;8660/8DE4B0;8168/8E58B1;4344/2D0861;4152/2D04E2;
4393/2CD9A0;4201/2CD1FE;4442/2CD331;4250/2D08D8;4491/2CD29D;4299/2CCFB9;4540/2D0831;4348/2D079F;4589/2CCFB8;4397/2CD38B;
4638/2D0559;4446/2CAE2B;4687/2CD6E3;4495/2D05AB;4736/2C917D;4544/2CAEFF;4785/2D066B;4593/2CD293;4834/E67F82;4642/E685F3;
4883/E64919;4691/E67C5C;4932/E682AF;4740/E5EB33;4981/E6AC9C;4789/E687F2;5030/E69D42;4838/E60A8F;5079/E651D7;4887/E69A55;
5128/E60C87;4936/E64F8D;5177/E6567B;4985/E647A7;5226/E67D3B;5034/E62B6F;5275/E67114;5083/98296F;5324/9827D5;5132/9775ED;
5373/9780F5;5181/98299E;5422/985B3B;5230/98016E;5471/9DE60E;5279/9E2F20;5520/9E35E7;5328/9E017E;5569/9E2A2E;5377/989DE0;
5618/98C245;5426/994D83;5667/9954CC;5475/98BC74;5716/986E68;5524/98992E;5765/994EF0;5573/9875BC;5814/98BD2B;5622/98732A;
5863/98808D;5671/98ABCA;5912/9902AC;5720/9878F3;5961/989DE4;5769/990DC6;6010/98BAF2;5818/994BD0;6059/98A131;5867/99552B;
6108/9873BA;5916/987781;6157/989F3E;5965/989EAD;6206/993D74;6014/987B5D;6255/98797B;6063/987A35;6304/9882D3;6112/98BF38;
6353/987770;6161/98812E;6402/9953FE;6210/987D52;6451/98BD08;6259/9882BA;6500/987E92;6308/98745A;6549/98BBEF;6357/9DDFD5;
6598/98744E;6406/987CC3;6647/98A3FB;6455/9DAF0A;6696/9DF01C;6504/9DFAA5;6745/9E0554;6553/9E0E5A;6794/9DEA61;6602/9DECE5;
6843/9DF03C;6651/9E0997;6892/9DF159;6700/9E103D;6941/9E5079;6749/9E4F67;6990/9E03AC;6798/9E2E70;7039/9DF2AA;6847/9DF69D;
7088/9E00CB;6896/9E07CE;7137/9E1167;6945/9E1BC1;7186/9E4069;6994/9E3069;7235/9E0A3E;7043/9DE285;7284/9DEF7B;7092/9E44F7;
7333/9E0AB5;7141/9E01B0;7382/9DED7F;7190/9E1CFC;7431/9E0708;7239/9E0BE6;7480/9E00FA;7288/9DEB62;7529/9E0E88;7337/9E03A0;
7578/9E0A5E;7386/9E0BDB;7627/9E0477;7435/9E0F1B;7676/9DEF2F;7484/9E012E;8025/9E002B;7833/9DF2B7;3960/E62167;3768/E64AC6;
4009/E5D3BE;3817/E62854;4058/E65474;3866/E625E1;4107/E62B94;3915/E65118;4156/E5D7D9;3964/E64BAE;4205/E6813F;4013/2C8E57;
4254/2D0556;4062/2D0902;4303/2D0669;4111/2CD67D;4352/2CAEC5;4160/2CCFCA;4401/2C9614;4209/2D07DB;4450/E67842;4258/E68BB3;
4499/E64CA1;4307/E628A7;4548/E5ED91;4356/E6879C;4597/E62845;4405/E64842;4646/E6895B;4454/E67BB9;4695/E627D5;4503/E64B71;
4744/E60BE0;4552/E64DB0;4793/E672AF;4601/E64F6B;4842/E6AB17;4650/E64749;4891/E67528;4699/978437;4940/978959;4748/978E5F;
4989/985E23;4797/9E38C8;5038/982AE5;4846/9E2B57;5087/985C09;4895/9D857B;5136/9DE20C;4944/9D67F2;5185/9E2D2E;4993/9D73FC;
5234/9E4F7F;5042/9D91DB;5283/9E2789;5091/9D73A7;5332/9DE46E;5140/9D8876;5381/9E1240;5189/9D6780;5430/9DB30A;5238/9D8FE4;
5479/9DF49B;5287/9D684E;5528/986B8B;5336/9D69EA;5577/9DE3D1;5385/9D7179;5626/9E408C;5434/9D619D;5675/9DEF31;5483/9D6F85;
5724/9E2B14;5532/9E28D5;5773/9E2AA9;5581/9E39DD;5822/9E0541;5630/9DE4BF;5871/9E364D;5679/9E0A55;5920/9E0E59;5728/9E3BC3;
5969/9E3917;5777/9DE139;6018/9E2AFA;5826/9DF2D6;6067/9E3CAA;5875/9E3F2C;6116/9DB112;5924/9E34A0;6165/9E2D52;5973/9DFFA0;
6214/9E0A5C;6022/9E3FCE;6263/9E44F9;6071/9E1671;6312/9E33F9;6120/9E06CB;6361/9E3987;6169/9DF4AA;6410/9E3963;6218/9E3672;
6459/9E2B6F;6267/9E1635;6508/9DE5DF;6316/9DE98E;6557/9DE209;6365/9DE674;6606/9E39CF;6414/9DE243;6655/9E1816;6463/9E46B2;
6704/9E2F73;6512/9DFF54;6753/9DFA4E;6561/9E40B1;6802/9E1802;6610/9E3C9E;6851/9DAC3D;6659/9E4F69;6900/9E2A96;6708/9E10FB;
6949/9E3F0D;6757/9DF034;6998/9E46CE;6806/9E4FAD;7047/9E3539;6855/9E2EFF;7096/9E4628;6904/9DEA73;7145/9E3FA4;6953/9DF06A;
7194/9DFAD1;7002/9DEF5D;7243/9E455C;7051/9E1661;7292/9DAB8B;7100/9E09DC;7641/9DE5F9;7449/9E2DC0;3576/E64B80;3384/985DCD;
3625/E62959;3433/97B2AD;3674/E64940;3482/97A825;3723/E651EE;3531/9827B4;3772/E65900;3580/978A73;3821/E67EAC;3629/986BB8;
3870/E5EA25;3678/982E38;3919/E656EB;3727/97F057;3968/E64194;3776/979921;4017/E64A83;3825/97B8D1;4066/E62EFA;3874/97AF95;
4115/E654A2;3923/9826BC;4164/E6AA12;3972/9860AF;4213/E62F12;4021/98211F;4262/E672A0;4070/983169;4311/E6A612;4119/9813C3;
4360/E6739A;4168/985D7C;4409/6460BB;4217/9829B9;4458/E5D7F5;4266/9801CA;4507/9789E0;4315/985BBE;4556/981D9A;4364/981298;
4605/9D8E1A;4413/9D85FC;4654/9D8DC1;4462/9D8425;4703/9D8950;4511/9D8B6B;4752/9D93AD;4560/9D618C;4801/9D6F5F;4609/9D9078;
4850/9D73B8;4658/9D8D15;4899/9D6075;4707/9D86DE;4948/9D836C;4756/9D7FE3;4997/9D82A3;4805/9D7006;5046/9D8F5A;4854/9D7FB9;
5095/9D8FF0;4903/9D9366;5144/9D8810;4952/9D6880;5193/9D73EF;5001/9E3F4F;5242/9D6E02;5050/9DE03D;5291/9E2851;5099/9D8A36;
5340/9E3A6D;5148/9E1174;5389/9E505D;5197/9E4F6B;5438/9E2B2F;5246/9DEE2F;5487/9E006D;5295/9DF24F;5536/9D6F68;5344/9D6260;
5585/9D6690;5393/9D6503;5634/9D601A;5442/9D644E;5683/9D66AD;5491/9E3783;5732/9E3A8F;5540/9D841D;5781/9D69E9;5589/9D8B12;
5830/9D6485;5638/9DEDE4;5879/9E0965;5687/9E1347;5928/9E2D96;5736/9E2D5E;5977/9DFF66;5785/9DEFB8;6026/9DEB82;5834/9E11C4;
6075/9E3FF3;5883/9E29E3;6124/9E3B29;5932/9E149B;6173/9E44E2;5981/9E1384;6222/9E06CE;6030/9E4FA1;6271/9E117A;6079/9DF04B;
6320/9DF2C8;6128/9E0A3A;6369/9E1442;6177/9E0AE6;6418/9E0A6C;6226/9E363D;6467/9DF059;6275/9DEC19;6516/9DF225;6324/9DEF29;
6565/9E0030;6373/9E1710;6614/9E13F8;6422/9E092A;6663/9DEEA4;6471/9E0624;6712/9DFF69;6520/9E0726;6761/9E5197;6569/9DEF2B;
6810/9E1001;6618/9DF268;7159/9E03F7;6967/9DF17F;3192/98277D;3241/986197;3290/97C30D;3339/981201;3388/982968;3437/979ABF;
3486/984CE1;3535/985CB7;3584/986085;3633/985627;3682/985BF3;3731/9809F3;3780/979B6A;3829/983074;3878/9814F2;3927/978FE6;
3976/9776A5;4025/9827B9;4074/97E58E;4123/985B10;4172/9791EB;4221/985BF8;4270/9D9332;4319/9D7291;4368/9D893F;4417/9D7F9F;
4466/9D629E;4515/9D66D0;4564/9D88F5;4613/9D707A;4662/9D6F79;4711/9D86ED;4760/9E2F49;4809/9E312F;4858/9DE071;4907/9D8F54;
4956/9DFF0B;5005/9E1004;5054/9E03B6;5103/9D8F3C;5589/9E29EC;6275/9E081A;6132/9DF011;6181/9E0205;6230/9E145D;6279/9DEECF;
6328/9DFFA5;6377/9E03DB;6726/9E0FB2;
PU0528 (0596 DETS):
4539/2CE718;5031/2C8E16;4588/2C963A;5080/2D0765;4637/2CAC5B;5129/2C8E92;4686/2CE729;5178/2CAE62;4735/2CDA41;5227/2D1519;
4784/2C9671;5276/2C8DBE;4833/2D07ED;5325/2D0640;4882/2CAC5F;5374/2C9B13;4931/2D0777;5423/2C963D;4980/2D06C7;5472/2D076E;
5029/2CD244;5521/2CD098;5078/2C9640;5570/2C964F;5127/2C957E;5619/2CD992;5176/2C960B;5668/2CE721;5225/2CAFB8;5717/2CAF9E;
5274/2CAD3A;5766/2C95E6;5323/2CDA69;5815/2D07BC;5372/2C956D;5864/2CE73C;5421/2D3C6C;5913/2C8F20;5470/646E34;5962/64DB1B;
5519/64643E;5568/64DE6E;6060/646E79;5617/64E2C0;6109/646B62;5666/64D114;6158/64BF0F;5715/64E2F1;6207/64BF0B;5764/646EE5;
6256/64C751;5813/63BF94;6305/64DE85;5862/64D49A;6354/64C329;5911/64F2E5;6403/64D3C6;5960/64BA33;6452/63CF3B;6009/64D00C;
6501/64D60C;6058/7029D2;6550/6FBFB1;6107/7076D4;6599/709463;6156/6FD18B;6648/708D1D;6205/6FF7CF;6697/702B7C;6254/7027FB;
6746/6FFEEE;6303/6FAF06;6795/6FEF6D;6352/6FF7BF;6844/709021;6401/7073DD;6893/6FD6FA;6450/702286;6942/7092A8;6499/70170A;
6991/702ADC;6548/70248B;7040/702295;6597/6FAF3E;7089/7075C6;6646/6FF778;7138/6FBFF1;6695/701C21;7187/7090A7;6744/702C28;
7236/2CAF68;6793/709B05;7285/2CAF7D;6842/708D60;7334/2D3B15;6891/701F5A;7383/2C99FA;6940/706DC5;7432/2D083A;6989/2CD2BC;
7481/2D065E;7038/2D150E;7530/2CC849;7087/2CAD81;7579/2C9D40;7136/2CCD4D;7628/7022B2;7185/2C8DF2;7677/2CAD0D;7234/6FF6B7;
7726/70197B;7283/2C91A7;7775/70197C;7332/7089B6;7824/6FF038;7381/7099CC;7873/70217C;7430/6FF2DB;7922/70A093;7479/7085EE;
7971/709A05;7528/7094C4;8020/709A5B;7577/7020DF;8069/7016F3;7626/6FBA10;8118/7022DA;7675/709D5F;8167/6FC333;7724/708F81;
8216/708985;7773/702A9C;8565/7074DB;8122/701DEC;4155/2CCFDC;4347/2CCFF4;4204/2CCFD8;4396/2CAEFE;4253/2CD210;4445/2CD8BA;
4302/2CCF48;4494/2CD693;4351/2CCF47;4543/2CD001;4400/2CD684;4592/2CCFE8;4449/2CD257;4641/2D06F1;4498/2CD896;4690/2CD65F;
4547/2CAD75;4739/2CD397;4596/2CD04E;4788/2D07EB;4645/2D0655;4837/2D0709;4694/2CAF67;4886/2CDA57;4743/2CAD74;4935/2CD249;
4792/2CD38F;4984/2C9172;4841/2CAE60;5033/2D059D;4890/2C9947;5082/2CD202;3771/2CCEBC;5131/2C9DCE;4988/2CD025;5180/2CD682;
5037/E60A2F;5229/646BCD;5086/64F769;5278/646DF5;5135/64EE6A;5327/64C88B;5184/64D606;5376/64416C;5233/64CF3C;5425/63CEC6;
5282/643FD4;5474/63C8C4;5331/63C608;5523/640186;5380/63CE5A;5572/645ED0;5429/64B9DD;5621/6467A3;5478/640D9C;5670/64C964;
5527/64D7AB;5719/64D45F;5576/64415F;5768/64609C;5625/64D75F;5817/6FF78A;5674/640FD1;5866/708E09;5723/63C669;5915/708DA3;
5772/64F0F2;5964/708CAD;5821/64F79F;6013/708B55;5870/E6A849;6062/7018D2;5919/E62ABF;6111/6FD74A;5968/E62EB7;6160/6FF47D;
6017/E674A4;6209/706F98;6066/E5D9EF;6258/6FB2F7;6115/E64856;6307/E5D3F9;6164/E62894;6356/E66FDA;6213/E65484;6405/E62176;
6262/E60950;6454/E60A27;6311/E60959;6503/E67C44;6360/6FFCBD;6552/701B6A;6409/702747;6601/709218;6458/2CD6A9;6650/6FF019;
6507/2C92E6;6699/2CD83F;6556/2CAEC4;6748/2CA546;6605/2C9DA0;6797/2C9AA5;6654/2C9084;6846/2CAEA2;6703/2C997F;6895/2CADFF;
6752/2CD191;6944/2CCCD7;6801/2CBB7B;6993/2C9E0B;6850/709E97;7042/70113D;6899/706E0C;7091/6FF351;6948/709E75;7140/7087F7;
6997/7075C8;7189/6FF5BA;7046/6FF352;7238/70A9A7;7095/701D32;7287/708C3D;7144/7010BA;7336/7019DD;7193/70208F;7385/6FF829;
7242/6FC2DF;7434/706E85;7291/6FD294;7483/6FF310;7340/709C77;7532/709C7F;7689/706DEA;7881/6FC1C2;3771/E6486B;3963/E5F290;
3820/E60BD4;4012/E67C8A;3869/E5EBDD;4061/E5EE4D;3918/E62C70;4110/E627C4;3967/E64828;4159/E65084;4016/E5EEB7;4208/E67D4B;
4065/E657F6;4257/E5D981;4114/E5E751;4306/E67ABD;4163/E5D234;4355/E62714;4212/E60AAE;4404/E680E9;4261/E60389;4453/E652EC;
4310/E67DEF;4502/E64B0F;4359/E67FB7;4551/E5F8E1;4408/E64776;4600/E67AE3;4457/E62921;4649/E68355;4506/E67CDA;4698/E61E8A;
4555/E6531A;4747/E60D8E;4604/E648F3;4796/E64C72;4653/E6536F;4845/E64DDC;4702/E67A9A;4894/E6703D;4751/E6090F;4943/E629F3;
4800/E678EA;4992/E689C6;4849/E68DCE;5041/E5D735;4898/E6A064;5090/E600E4;4947/E69953;5139/E68493;4996/2D3EBA;5188/E62C63;
5045/2CEB1E;5237/E67A68;5094/2C8F04;5286/E60A9B;5143/2CCBC1;5335/E60A75;5192/2C8EC5;5384/E67C55;5241/64428B;5433/64BEAE;
5290/64E0F9;5482/642B47;5339/64D069;5531/640DA4;5388/646DF4;5580/63C1A5;5437/6401CE;5629/E67D30;5486/64E19D;5678/E62991;
5535/E67C4D;5727/E648DE;5584/E62723;5776/E69DA4;5633/E64BF6;5825/E688DC;5682/E673A0;5874/E60EC0;5731/E66EEB;5923/E6253E;
5780/E5E776;5972/E674CA;5829/E6A3EB;6021/E5FFD1;5878/E6781C;6070/E5F45D;5927/701A20;6119/702986;5976/706DD2;6168/708FF8;
6025/708DC5;6217/2C9CC4;6074/700053;6266/2CCD67;6123/703C06;6315/2CD054;6172/6FF4D8;6364/2C9A2B;6221/2CD6F3;6413/2CD6B7;
6270/2C9A63;6462/2C95F9;6319/2C90BB;6511/2CD13C;6368/2CCC91;6560/2C9F4D;6417/707523;6609/6FC362;6466/701337;6658/7095AA;
6515/709AB3;6707/706DCB;6564/2C9AC2;6756/6FBF93;6613/2CAE7A;6805/701390;6662/2C999B;6854/6FF27D;6711/2C9A17;6903/707413;
6760/2CD1EF;6952/70191B;6809/2CCBD0;7001/6FF7EC;6858/2CD7CD;7050/6FF05A;6907/2CAF8C;7099/6FD74C;6956/2CD0F3;7448/706FBC;
7305/2CD1BD;3387/982AB3;3579/E62547;3436/979705;3628/E64770;3485/986B25;3677/E62C20;3534/981CBE;3726/E5EA36;3583/97D7F9;
3775/E5E950;3632/97AD8A;3824/E5EAB2;3681/981F37;3873/E6592E;3730/E629D6;3922/E6579A;3779/E670D7;3971/E65381;3828/E627AF;
4020/E62945;3877/E5D08A;4069/E65515;3926/E65740;4118/E65377;3975/E64DAD;4167/E62E4F;4024/E6AB49;4216/E681D8;4073/E62C14;
4265/E67DBC;4122/E64946;4314/E682BF;4171/E5ECD5;4363/E62A44;4220/E62995;4412/E655F7;4269/2CAF08;4461/2D3EEB;4318/2D3224;
4510/2D166F;4367/2C931C;4559/2C8E2E;4416/2C92A4;4608/2C92F8;4465/2CCBDD;4657/2D06AB;4514/2D07BE;4706/2D0613;4563/2C9587;
4755/2C932F;4612/2C9600;4804/2CD0AD;4661/2C95C2;4853/2D1379;4710/2C9616;4902/2C960E;4759/2CEBD1;4951/2C988E;4808/64F1F5;
5000/64BA0C;4857/63CBC3;5049/64E303;4906/64DB37;5098/64C90D;4955/643B1D;5147/6464A6;5004/641C74;5196/640E29;5053/64D8C4;
5245/64DD88;5102/E5D135;5294/E674ED;5151/E5E60F;5343/E64990;5200/E648A8;5392/E627BC;5249/E68A94;5441/E5F83E;5298/E653FD;
5490/E6280F;5347/E67DB4;5539/E5EA9A;5396/E64C9F;5588/E6A477;5445/E67971;5637/E656DE;5494/702CE5;5686/706EE4;5543/7019B8;
5735/6FF43D;5592/701C1F;5784/709190;5641/7098FF;5833/701028;5690/7092A0;5882/7075CF;5739/701F8F;5931/701D8B;5788/70719B;
5980/708CE7;5837/6FFDD3;6029/702679;5886/2CAF58;6078/2C9B36;5935/2C9D7D;6127/2C9ED4;5984/701A05;6176/70990B;6033/701C51;
6225/7070C6;6082/6FEFA4;6274/6FF679;6131/6FF88C;6323/70A343;6180/6FC2D0;6372/707162;6229/707431;6421/2C9E47;6278/2CAE95;
6470/2CD5F4;6327/2D0684;6519/2C99F8;6376/2C996D;6568/2CD2B2;6425/2C9AFC;6617/2C9EB3;6474/2CAE20;6666/2C99D2;6523/2CD303;
6715/2CA4FB;6872/2C9AB6;7064/2CD7CC;3195/9824A9;3234/986494;3263/97DF69;3342/980058;3391/983F17;3440/98579C;3489/E648E2;
3538/E65457;3587/E644A0;3636/E626F3;3685/E64E4A;3734/E62D58;3783/E6A7DE;3832/E64C38;3881/E673FA;3930/E609A0;3979/E6519A;
4028/2D0849;4077/2C8F19;4126/2D0833;4175/2C8E4B;4273/2CAED6;4322/2C8E93;3471/2CE668;4420/2D08A1;4469/2D1431;4518/2D14D0;
4567/64D8CB;4616/641A8B;4665/64DEBB;4714/64C8C9;4763/64F4A5;4812/643F39;4861/E62D60;4910/E64A9B;4959/E6A775;5008/E68A5F;
5057/E61BA4;5106/E68BD0;5155/E62769;5204/E67D71;5253/6FF7D4;5302/7095FE;5351/6FF2A2;5400/701C78;5449/7095BB;5498/7015CE;
5547/706D92;5596/6FEFB2;5645/2C9927;5694/2CC8A6;5743/6FBD58;5841/70A07C;5890/6FF11C;5939/7017DD;5988/70A2B0;6037/2CAFA4;
6086/2CC438;6135/2D06E8;6184/2C9162;6233/2C9D4C;6282/2CD1DC;6631/2C9E0D;
-
BLAST SUMMARY
2 PU, 01199 DETS
DELAYS MIN/MAX IN MS : 03192 / 08660
GAP MIN/MAX IN MS : 00000 / 00254
-
10:19:35:LINE TEST
-
CALIBRATION
-
EXTRA DETS :None
INTERMITTENT CONNECTION DETS :None
-
TEST DETS
MISSING DETS :None
OUT OF ORDER DETS :None
INCOHERENT DETS :None
DELAY ERRORS DETS :None
-
10:27:56:TEST END
-
10:38:31:CHARGE
-
CHECK ENERGIE
ADDITIONAL MISSING DETS :None
LOW ENERGY DETS :None
ADDITIONAL INCOHERENT DETS :None
-
10:39:10:FIRE
In all the information above the most important information for me in bold for the format is:
1. Date 1: 17/04/20-17:27:30 Date 2: 17/04/22-13:05:14 and Date 3: 17/04/28-10:18:41 - Should be displayed one by one as it is in a Combobox
2. Dets 1: 2 PU, 00567 DETS, Dets 2: 1 PU, 00234 DETS and Dets 3: 2 PU, 01199 DETS
- When the user selects Date 1 in Combobox 1, Combobox 2 should populate with Dets 1
- When the user selects Date 2 in Combobox 1, Combobox 2 should populate with Dets 2
- When the user selects Date 3 in Combobox 1, Combobox 2 should populate with Dets 3
3. Det Info 1:
1347/E61584;1839/E5E447;1396/E64089;1888/E60359;1445/E63E4C;1937/E60A88;1494/E64125;1986/E5E8BF;1543/E680AB;2035/E670B1;
1592/E62A71;2084/E68338;1641/E683E6;2133/E67776;1690/E629CA;2182/E67A3A;1739/E68061;2231/E67DAF;1788/E67421;2280/E67094;
1837/E67E9E;2329/E5F800;1886/E64C74;2378/E6ABA0;1935/E6744D;2427/E67A0D;1984/E67884;2476/E65819;2033/E62965;2525/E67C83;
2082/E5D1C5;2574/E6AD6C;963/E5F987;1155/E5C9AC;1012/E64F8F;1204/E5DF63;1061/E5FDF0;1253/E63CEC;1110/E5C9B0;1302/E63C09;
1159/E5D4B6;1351/E5F7A2;1208/E6A8E0;1400/E680B1;1257/E60D81;1449/E621BC;1306/E6A71C;1498/E69F70;1355/E62E8D;1547/E60CF0;
1404/E64CAE;1596/E5FD4D;1453/E5EDF1;1645/E6A5B9;1502/E62850;1694/E67F0B;1551/E6A961;1743/E608AF;1600/E62617;1792/E671E3;
1649/E6AC1B;1841/E68B7C;1698/E67C36;1890/E68A27;579/E5F14A;771/E64170;628/E63D5B;820/E5D2B0;677/E5ECC3;869/E5C1D7;
726/E642A8;918/E5C7A2;775/E67C62;967/E627EA;824/E6273D;1016/E6A77B;873/E656A1;1065/E61E81;922/E6A3DD;1114/E67F89;
971/E699CC;1163/E65558;1020/E69B82;1212/E5F9EE;1069/E67970;1261/E64CD1;1118/E64D72;1310/E65181;1167/E64C6D;1359/E62D70;
1216/E62E09;1408/E6840B;1265/E6847C;1457/E6257B;1314/E654CE;1506/E689B4;387/E628A5;436/E5E0EF;485/E6037E;534/E62CEB;
583/E67B6A;632/E688B6;681/E6A8D3;730/E67C6D;779/E68C73;828/E6A7C6;877/E66F70;926/E649AC;975/E686EB;1024/E65373;
1073/E670B5;385/E5F56B;577/E5BE9F;434/E61D55;626/E5DBD3;483/E60183;675/E61998;532/E5D730;724/E5FDEE;581/E6189D;
773/E5F8D7;630/E5BF30;822/9DB373;679/9D90E6;871/9DCB63;728/9D9317;920/9E4E52;777/9E0732;969/9D8444;826/9D7DAB;
1018/9E5B83;875/9D72DD;875/9D87DE;1067/9D8627;924/9D82E3;1116/9E18B4;973/9DAA01;1165/9E2371;1022/9E18D7;1071/9DCB5A;
1120/9E3187;1169/9E3499;389/E5DBBC;246/9DFD0D;438/9D8ED6;295/9DB2C8;487/9DFA71;344/9E13F3;393/9E028F;442/9E14F2;
491/9DD1C7;769/E63A9D;961/E620D7;818/E5DF2D;1010/E5DF50;867/E62069;1059/E5C71E;916/E603FE;1108/E643A5;965/E5C115;
1157/E5D34D;1014/E618A7;1206/9D71E9;1063/9D6FB9;1255/9E0A62;1112/9D6DA4;1304/9E586C;1161/9E5828;1353/9E48F4;1210/9D745E;
1402/9E0384;1259/9E08B7;1451/9DFECA;1308/9E24D3;1500/9DEE3B;1357/9D6315;1549/9E02D0;1406/9DB179;1598/9E169B;1455/9E3C40;
1647/9D71D1;1504/9D6FD2;1696/9D856D;1504/9E333B;1153/E5E034;1345/E5CA45;1202/E61D63;1394/E60B0F;1251/E6416E;1443/E63B3D;
1300/E6059C;1492/E61FE8;1349/E600B8;1541/E5DBE0;1398/E63B3E;1590/E63B6E;1447/9DE584;1639/E63BDC;1496/9E187D;1688/E65708;
1545/E62442;1737/E60491;1594/9D6771;1786/E5DF58;1643/9E2D9B;1835/E5C154;1692/9D8006;1884/9DDFE4;1741/9DB2B0;1933/9E3C91;
1790/9D8B65;1982/9D832E;1839/9D8BD3;2031/9DF899;1888/9E4C9F;1888/9D6D7B;2080/9D69E3;1837/E641F2;1886/E5C6E8;1935/E620F9;
1984/E623E3;2033/E6049B;2082/E61038;2131/E5C6F3;2180/E5EEA0;2229/E61581;2278/E60167;2327/9E2C02;2376/9D8378;2425/9E30A8;
2474/9E3F83;2523/9D8667;2572/9D6560;2621/9D64A9;
When the user then selects Date 1 from Combobox 1 and Dets 1 from Combobox 2 the below information must be shown in a datagridview (Only using the first line as an example).
The Datagridview will have 2 columns:
Column 1: Sequence - All data in the rows are autogenerated starting from 1 to x depending on how much data goes into Column 2
Column 2: Timing - All Data is extracted in sequence only inserting the below bold numbers in each row:
11347/E61584;1839/E5E447;1396/E64089;1888/E60359;1445/E63E4C;1937/E60A88;1494/E64125;1986/E5E8BF;1543/E680AB;2035/E670B1
I hope this clarified it.
|
|
|
|
|
Of course ... 
If I see it right then one data-block goes from a line which contents "BLAST DRIVER ON" and ends with the line before the next "BLAST DRIVER ON" or EndOfFile - Am I right ?
The PU-Information is allways inside the line after the line with the content "BLAST SUMMARY"
The Det-Info is allways inside the line after the line with the content "BLASTING PLAN". If you have more than one Det the next Det-DataBlock comes after a line beginning with "PU"
So ... in fact this is the Programm you have to build :
- read the whole text-File into a List(of String) - as I allready wrote before
- scan the text-Lines for the required text-parts
- build Variables (Array's) to which the required Information could be assigned - better build a Class-Object with the required parts in it (but this could also be done later)
your Variables could be : TimeStamp (as string), Dets(as Array of string) and Blast_Data (as string or perhaps something Special)
Do you think that you could create the required code ?
|
|
|
|
|
Let me start by saying thank you for being patient with me.
I was very proud I got as far as I have and being a complete numbskull newbie, I have to say no, I have no idea what code to write for what you are saying. 
|
|
|
|
|
OK ... how should we come together ?
You have a method-part posted which imports the Textfile into a List(of string).
Now - instead of transfering this List into a Listbox try to search one of the Keywords in the List and try to work with it like I described.
Don't see the complete exercise - see it part by part - programming works like this.
And ... don't work with RegEx - who told you to do it like this ?
As I wrote before : I don't write the code for you ... but I would guide you to the solution (if you want) ...
|
|
|
|
|
HI,
Your guidance would be appreciated.
I will work on what you have given me and then repost what I have done for you to assist, if you do not mind.
I do not want anyone to write the code for me, I just want a starting place.
I googled a lot for some answers and regex was one of them that came up.
Am I correct in Saying, I should start bye searching for Keyword:
BLAST DRIVER ON
Thanks again
|
|
|
|
|
Thank you for your help thusfar.
I managed to search for the lines as you suggested:
public void Extract()
{
String Fname = openFileDialog2.FileName;
int counter = 0;
string line;
var BDate = ("BLAST DRIVER ON");
var Dets = ("BLAST SUMMARY");
var BPlan = ("BLASTING PLAN");
System.IO.StreamReader file = new System.IO.StreamReader(Fname);
while ((line = file.ReadLine()) != null)
{
if (line.EndsWith(BDate) | line.Contains(Dets) | line.Contains(BPlan))
{
listBox1.Items.Add(line);
}
counter++;
}
}
The only reason I use the listbox is to see what it returns.
Now for my next questions:
1. How do I return the line after ("BLAST SUMMARY")
2. How do I Extract and only work on the information between the date selected and the next date?
Once I know this I should be getting closer.
|
|
|
|
|
The approach with the 3 String-Parts is very good.
But now you do it different :
- add the line(s) into a List(of String)
- after that iterate with a loop through this List (List gives you with Count the number of entries in it)
- if you now find at index-Position a string which contains the Dets you take the index+1 into your ?ListBox?
- if you want to seperate a Block you could do it in the same way :
- iterate throught the List and find the first BDate - here starts your Block (memorize the index1)
- continue iterating and find the next BDate (or End of the List) - here Ends your Block (memorize the index2)
- your data-block information now is between index1 and index2
Will you try to realize that ?
|
|
|
|
|
Hi Ralf,
Thank you for the input. I have worked on it over the weekend and am no further.
Could you please explain the index approach as I am not clear on it.
I can find all the info from the text file, but am really struggling to index the found words as I have no idea how to.
What would you suggest?
1. Find the words and index them as follows:
a. Blast driver on - index 1
b blast driver on - index 2 and so on?
Please guide me in the right direction as I am running in circles now.
Please just give me the code to create the index of each find and i will carry on from there.
Regards
|
|
|
|
|
List<string> lines = new List<string>();
using (var sr = new StreamReader("file.txt"))
{
while (sr.Peek() >= 0)
lines.Add(sr.ReadLine());
}
for (int i = 0; i < lines.Count; i++)
{
if (lines(i).contains(Dets)) {
listbox.Items.Add(lines(i + 1));
}
}
Here is a Little sample (much more you will find with Google).
- at first I read the whole content of the file into lines which is a List<string>
- after that I iterate with a Loop through the List and search for 'Dets' - the line after will be transfered into the Listbox (in the moment)
I think, with this sample you could the next steps (as I described before).
Try it first to find the required entries only in the first datablock of your file. If this works we would go to the next step.
|
|
|
|
|
Thank you for all the help. I have got it working they way I want it to.
|
|
|
|
|
Very good ... 
I am interested how you done it - would you provide the code ?
|
|
|
|
|
Hi, The Types of your Columns tell me that you want to extract typed objects from your text-data. As Ralf suggests, you are going to have to create a parser to convert text to typed objects, and a typed structure to hold the typed objects. That structure could be a Class, a DataTable, or, a Struct.
But first, consider the source of your data: will that source provide the data in some structured format like XML, JSON, or, even CSV. If the data is in any one of those formats, your work is much simpler.
If it is your code generating the data, then you could focus on simply writing a serializer and de-serializer for your objects/classes. Not hard to do these days.
Also, if there are relatively few data in the text file that you need to parse into objects, and display in the DataGridView, perhaps a "scraping" technique would get what you need, possibly by use of a RegEx.
Suggestion: make an outline of the underlying structure your text file embodies; assuming many instances of the structure in one text file (?): define what markers define the beginning and end of each instance. What fields are always present, which are, optionally, omitted.
Sketch: (ref. : [^])
using System;
using System.IO;
using System.Runtime.Serialization;
namespace MasterBlaster
{
[DataContract]
public class Blast
{
[DataMember]
public string BlastId { set; get; }
[DataMember]
public DateTime BlastTime { set; get; }
[DataMember]
public int BlastInitialDets { set; get; }
[DataMember]
public string[] BlastInitialData { set; get; }
public string tempInfo;
public Blast(string id, int idets, params string[] idata)
{
BlastId = id;
BlastInitialDets = idets;
BlastInitialData = idata;
}
public static class BlastsSerializer
{
static DataContractSerializer dcs = new DataContractSerializer(typeof(Blast[]));
public static void Serialize(string filepath, Blast[] blasts)
{
Directory.CreateDirectory(Path.GetDirectoryName(filepath));
using (var writer = new FileStream(filepath, FileMode.Open, FileAccess.Write))
{
dcs.WriteObject(writer, blasts);
}
}
public static Blast[] DeSerialize(string filepath)
{
Blast[] blasts;
using (var reader = new FileStream(filepath, FileMode.Open, FileAccess.Read))
{
blasts = dcs.ReadObject(reader) as Blast[];
}
return blasts;
}
}
}
}cheers, Bill
«Beauty is in the eye of the beholder, and it may be necessary from time to time to give a stupid or misinformed beholder a black eye.» Miss Piggy
modified 6-Jul-17 7:37am.
|
|
|
|
|
My code started out as something fairly easy to follow like this:
void RemoveDuplicatesButton_Click(object sender, RoutedEventArgs e)
{
SortedSet<T> seen = new SortedSet<T>();
StringBuilder stringBuilder = new StringBuilder();
foreach (string line in this.InputTextBox.Text.Split(new char[] { '\r', '\n' }))
{
if (seen.Add(line))
{
stringBuilder.AppendLine(line);
}
}
this.InputTextBox.Text = stringBuilder.ToString();
}
Then I factored out some of the code into extension methods, removed the unnecessary curly braces, and got this:
void RemoveDuplicatesButton_Click(object sender, RoutedEventArgs e)
{
StringBuilder stringBuilder = new StringBuilder();
foreach (string line in this.InputTextBox.Text.SplitLines().Unique<string>())
stringBuilder.AppendLine(line);
this.InputTextBox.Text = stringBuilder.ToString();
}
And then I took it a step further.
void RemoveDuplicatesButton_Click(object sender, RoutedEventArgs e) =>
this.InputTextBox.Text = this.InputTextBox.Text.SplitLines().Unique<string>().Aggregate<string, StringBuilder, string>(
new StringBuilder(),
(StringBuilder stringBuilder, string line) => stringBuilder.AppendLine(line),
(StringBuilder stringBuilder) => stringBuilder.ToString());
And the one-liner:
void RemoveDuplicatesButton_Click(object sender, RoutedEventArgs e) => this.InputTextBox.Text = this.InputTextBox.Text.SplitLines().Unique().Aggregate(new StringBuilder(), (sb, line) => sb.AppendLine(line), sb => sb.ToString());
I get great joy as a programmer by factoring out as much code as possible, but at which point should I have stopped for this example? Should I perhaps switch to another programming language that’s more conducive to this style of writing?
|
|
|
|
|
You shouldn't be doing that directly in the Click event handler. You need to refactor that functionality into a library of such routines. ![Jig | [Dance]](https://codeproject.freetls.fastly.net/script/Forums/Images/jig.gif)
|
|
|
|
|
The first method is a good example of "evil" comments - they just repeat the code in different words.
Fighting Evil in Your Code: Comments on Comments - Simple Talk[^]
I'd be inclined to move the final Aggregate to its own extension method - JoinLines perhaps? You can also simplify it by using String.Join[^]:
public static string JoinLines(this IEnumerable<string> lines) => string.Join(Environment.NewLine, lines);
void RemoveDuplicatesButton_Click(object sender, RoutedEventArgs e) => this.InputTextBox.Text = this.InputTextBox.Text.SplitLines().Unique().JoinLines();
"These people looked deep within my soul and assigned me a number based on the order in which I joined."
- Homer
|
|
|
|
|
Great minds think alike
This space for rent
|
|
|
|
|
Kevin Li (Li, Ken-un) wrote: but at which point should I have stopped for this example?
I think what you've done is fantastic. It's considerably more readable than the first implementation.
Kevin Li (Li, Ken-un) wrote: Should I perhaps switch to another programming language that’s more conducive to this style of writing?
Your only other option to achieve this level of elegance (as far as I know and without dealing with arcane symbols) is F#, IMO.
But I'm with Richard -- I think the Aggregate is unnecessary.
Marc
Latest Article - Create a Dockerized Python Fiddle Web App
Learning to code with python is like learning to swim with those little arm floaties. It gives you undeserved confidence and will eventually drown you. - DangerBunny
Artificial intelligence is the only remedy for natural stupidity. - CDP1802
|
|
|
|
|
In Backus' paper introducing Fortran (1957), the primary focus was on the speed of writing code; a secondary focus was on debugging.
Uncle Bob's most famous book "Clean Code" (2008) focuses on readability.
Why do we see that paradigm shift?
In 1957, most projects were green-field projects: for a problem, new code was written, the problem was solved and the code was no more needed. Old code need not be maintained.
Nowadays, maintenance of code (brown-field projects) dominate the scene. We have to read code for more often than we write code.
And now simply ask yourself: when someone else - or even you after a couple of weeks - reads that code, how long will it take him to understand it?
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
