<div dir="ltr">A quick Google search shows most people do it this way:<div>date -d @<your epoch><br></div><div>-David, N9KT</div><div><br></div></div><br><div class="gmail_quote"><div dir="ltr" class="gmail_attr">On Wed, Dec 30, 2020 at 1:14 PM Niels via Dxspider-support <<a href="mailto:dxspider-support@tobit.co.uk">dxspider-support@tobit.co.uk</a>> wrote:<br></div><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex">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" rel="noreferrer" target="_blank">https://packet-radio.net</a><br>
<a href="http://dx.packet-radio.nl" rel="noreferrer" target="_blank">http://dx.packet-radio.nl</a><br>
telnet://<a href="http://dx.packet-radio.nl" rel="noreferrer" target="_blank">dx.packet-radio.nl</a> 7300<br>
<br>
<br>
_______________________________________________<br>
Dxspider-support mailing list<br>
<a href="mailto:Dxspider-support@tobit.co.uk" target="_blank">Dxspider-support@tobit.co.uk</a><br>
<a href="https://mailman.tobit.co.uk/mailman/listinfo/dxspider-support" rel="noreferrer" target="_blank">https://mailman.tobit.co.uk/mailman/listinfo/dxspider-support</a><br>
</blockquote></div>