<html><head></head><body><div style="font-family: Verdana;font-size: 12.0px;"><div>Hi Niels,</div>
<div> </div>
<div>I cannot provice a log file but I want to inform you that there is already such a tool available. It is called "slogan", a python script and was developed by HA5DI. Have a look at it, it's really great! you enter a log file for input and you get all the information reported. Here's an example:</div>
<div> </div>
<div><img height="1036" src="cid:fadc273ac3d390bca60b7e4012d4c7de23d531465f8b4e4673846cc27e95459d" width="723"/></div>
<div>HNY es 73!</div>
<div>Saki, DD5XX</div>
<div> </div>
<div>
<div>
<div name="quote" style="margin:10px 5px 5px 10px; padding: 10px 0 10px 10px; border-left:2px solid #C3D9E5; word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space;">
<div style="margin:0 0 10px 0;"><b>Gesendet:</b> Mittwoch, 30. Dezember 2020 um 19:14 Uhr<br/>
<b>Von:</b> "Niels via Dxspider-support" <dxspider-support@tobit.co.uk><br/>
<b>An:</b> dxspider-support@tobit.co.uk<br/>
<b>Cc:</b> "Niels" <pd9q@packet-radio.net><br/>
<b>Betreff:</b> [Dxspider-support] Kind of log parser</div>
<div name="quoted-content">Hi,<br/>
<br/>
I am writing some kind of log parser in Bash. It generates some info<br/>
about the connected station over the last month, and some returning<br/>
users. Number of connect per users. Now I have two questions. Since I<br/>
am only a very,very,very small node, I am looking for a large log file.<br/>
My log file of a month is about 50Mb. I would like a log file of the Big<br/>
Boys. Is there anyone who would like to make it available for download?<br/>
I would like to use this to tweak and speed up my script. At this point,<br/>
the script reads and processes approximately 865,000 lines in 255ms. I<br/>
also have 1 line perl in the script I would like to change to Bash, but<br/>
I cannot find a good solution for this line.<br/>
<br/>
# Change the epoch time to readable text.<br/>
g=$(echo "$e" | perl -pe 's/(\d+)/localtime($1)/e')<br/>
<br/>
"$e" look like this<br/>
<br/>
1606784607 G7VJA connected from 81.174.245.245<br/>
1606817130 WA1UHA connected from 73.34.224.142<br/>
1606841436 PA1RBZ-2 connected from 84.17.47.9<br/>
1606926662 G0RQL connected from 81.174.171.24<br/>
1606993290 PD9Q connected from 188.207.110.139<br/>
1607248295 IW3HER connected from 185.138.39.139<br/>
1607257552 W4OA connected from 162.223.105.204<br/>
<br/>
With the above perl code it` look like this.<br/>
<br/>
Tue Dec 1 02:03:27 2020 G7VJA connected from 81.174.245.245<br/>
Tue Dec 1 11:05:30 2020 WA1UHA connected from 73.34.224.142<br/>
Tue Dec 1 17:50:36 2020 PA1RBZ-2 connected from 84.17.47.9<br/>
Wed Dec 2 17:31:02 2020 G0RQL connected from 81.174.171.24<br/>
Thu Dec 3 12:01:30 2020 PD9Q connected from 188.207.110.139<br/>
Sun Dec 6 10:51:35 2020 IW3HER connected from 185.138.39.139<br/>
Sun Dec 6 13:25:52 2020 W4OA connected from 162.223.105.204<br/>
<br/>
I am looking for a bash option (awk, sed (dont think sed can do this)).<br/>
<br/>
Thanks for the time.... Hoop that someone can help me with a log file<br/>
of the perl code<br/>
<br/>
The output of the script look like this at the moment.<br/>
<br/>
** Output Generated on 12-30-2020 19:06:50<br/>
** Log file : /spider/local_data/log/2020/12.dat<br/>
** Files size : 49M<br/>
** Lines in the log file : 866023<br/>
** Times of inbound connects : 83<br/>
** Connected Stations over a month<br/>
==============================================================<br/>
Tue Dec 1 02:03:27 2020 G7VJA connected from 81.174.245.245<br/>
Tue Dec 1 11:05:30 2020 WA1UHA connected from 73.34.224.142<br/>
Tue Dec 1 17:50:36 2020 PA1RBZ-2 connected from 84.17.47.9<br/>
Wed Dec 2 17:31:02 2020 G0RQL connected from 81.174.171.24<br/>
Thu Dec 3 12:01:30 2020 PD9Q connected from 188.207.110.139<br/>
Sun Dec 6 10:51:35 2020 IW3HER connected from 185.138.39.139<br/>
Sun Dec 6 13:25:52 2020 W4OA connected from 162.223.105.204<br/>
Sun Dec 6 13:44:40 2020 PJ4EL connected from 190.4.70.236<br/>
Tue Dec 8 19:16:32 2020 LA3SHA connected from 84.208.137.133<br/>
Wed Dec 9 19:54:36 2020 EA1GFY connected from 84.76.91.185<br/>
Thu Dec 10 04:02:56 2020 WB4QOJ connected from 108.226.130.238<br/>
Sun Dec 13 04:32:27 2020 YS1RR connected from 190.53.13.104<br/>
Tue Dec 15 20:21:38 2020 ON1GL connected from 91.179.152.167<br/>
Wed Dec 16 19:04:05 2020 GE8DNH connected from 198.46.81.55<br/>
Wed Dec 16 22:33:37 2020 WB8JAY connected from 76.189.232.252<br/>
Sat Dec 19 13:35:05 2020 KD8MJL connected from 172.58.140.178<br/>
Sat Dec 19 14:00:52 2020 KD8MJJ connected from 24.236.102.184<br/>
Wed Dec 23 13:17:40 2020 PE1KDA connected from 213.126.72.11<br/>
Sat Dec 26 09:36:24 2020 S50U connected from 86.61.79.218<br/>
Sat Dec 26 23:51:11 2020 N5XL connected from 64.201.126.41<br/>
Tue Dec 29 19:36:36 2020 PE1OWG connected from 77.175.251.204<br/>
Wed Dec 30 11:57:23 2020 PF7X connected from 212.238.138.128<br/>
==============================================================<br/>
** End Connected Stations<br/>
<br/>
** Last Connected Stations - Return Connects<br/>
==============================================================<br/>
Wed Dec 30 16:29:10 2020 PF7X connected from 212.238.138.128<br/>
Wed Dec 30 13:03:40 2020 WB4QOJ connected from 172.58.6.242<br/>
Wed Dec 30 08:53:48 2020 N5XL connected from 64.201.126.41<br/>
Tue Dec 29 00:42:23 2020 WB8JAY connected from 76.189.232.252<br/>
Sat Dec 26 20:01:44 2020 G7VJA connected from 81.174.245.245<br/>
Sat Dec 26 15:51:02 2020 GE8DNH connected from 198.46.81.55<br/>
Sat Dec 19 14:02:07 2020 KD8MJL connected from 172.58.140.178<br/>
Sat Dec 12 13:19:32 2020 EA1GFY connected from 84.76.91.185<br/>
Thu Dec 10 04:52:43 2020 W4OA connected from 162.223.105.204<br/>
Tue Dec 8 19:24:07 2020 LA3SHA connected from 84.208.137.133<br/>
Mon Dec 7 04:08:16 2020 PJ4EL connected from 190.4.70.236<br/>
==============================================================<br/>
** End last Connected Stations<br/>
<br/>
Number Call Times<br/>
======================================<br/>
1 EA1GFY 2<br/>
2 G0RQL 1<br/>
3 G7VJA 19<br/>
4 GE8DNH 12<br/>
5 IW3HER 1<br/>
6 KD8MJJ 1<br/>
7 KD8MJL 2<br/>
8 LA3SHA 2<br/>
9 N5XL 3<br/>
10 ON1GL 1<br/>
11 PA1RBZ 1<br/>
12 PD9Q 1<br/>
13 PE1KDA 1<br/>
14 PE1OWG 1<br/>
15 PF7X 3<br/>
16 PJ4EL 4<br/>
17 S50U 1<br/>
18 W4OA 20<br/>
19 WA1UHA 1<br/>
20 WB4QOJ 2<br/>
21 WB8JAY 3<br/>
22 YS1RR 1<br/>
<br/>
Script Runtime 251ms<br/>
<br/>
real 0m0.258s<br/>
user 0m0.152s<br/>
sys 0m0.064s<br/>
<br/>
73 Niels PD9Q<br/>
<a href="https://packet-radio.net" target="_blank">https://packet-radio.net</a><br/>
<a href="http://dx.packet-radio.nl" target="_blank">http://dx.packet-radio.nl</a><br/>
telnet://dx.packet-radio.nl 7300<br/>
<br/>
<br/>
_______________________________________________<br/>
Dxspider-support mailing list<br/>
Dxspider-support@tobit.co.uk<br/>
<a href="https://mailman.tobit.co.uk/mailman/listinfo/dxspider-support" target="_blank">https://mailman.tobit.co.uk/mailman/listinfo/dxspider-support</a></div>
</div>
</div>
</div></div></body></html>