我有一個停機/停機時間串列，需要計算每天的總停機時間
這是原始資料集的片段：
Jan 1 00:09:56 changed state to down
Jan 1 00:10:02 changed state to up
Jan 1 00:10:45 changed state to down
Jan 1 00:10:52 changed state to up
Jan 1 00:11:45 changed state to down
Jan 1 00:11:52 changed state to up
Jan 2 00:14:55 changed state to down
Jan 2 00:15:05 changed state to up
Jan 2 00:15:35 changed state to down
Jan 2 00:16:41 changed state to up
Jan 3 00:05:22 changed state to down
Jan 3 00:05:28 changed state to up
Jan 3 23:59:58 changed state to down
Jan 4 00:00:19 changed state to up
Jan 4 00:49:28 changed state to down
Jan 4 00:49:34 changed state to up
我要的是這樣的輸出：
Jan 1: 20 seconds
Jan 2: 76 seconds
Jan 3: 27 seconds
Jan 4: 6 seconds
我撰寫了這個腳本來獲取時間戳到紀元時間：
while read i; do
datetime=$(echo $i | awk '{print $1" "$2" "$3}')
epochtime=$(date -d "$datetime" \%s)
echo $epochtime
done < ./file
這會給我這樣的資料：
1640995796
1640995802
1640995845
1640995852
...
我似乎找不到將它們組合成一行的方法，因此我可以使用此代碼（或類似代碼）：
for i in $epochtime; do
starttime=$(awk '{print $2}')
endtime=$(awk '{print $1}')
delta=$(( endtime - starttime ))
echo $delta
done
提前致謝！
uj5u.com熱心網友回復：
$ cat tst.awk
{
prevSecs = currSecs
prevDate = currDate
currDate = $1 " " $2
$1 = (index("JanFebMarAprMayJunJulAugSepOctNovDec",$1) 2) / 3
currSecs = mktime("2022 " gensub(/:/," ","g"), 1)
}
NR%2 == 0 {
dayDeltaSecs = (currSecs - prevSecs)
}
(NR > 1) && (currDate != prevDate) {
printf "%s: %d seconds\n", prevDate, dayDeltaSecs
dayDeltaSecs = 0
}
END {
printf "%s: %d seconds\n", prevDate, dayDeltaSecs
}
$ awk -f tst.awk file
Jan 1: 20 seconds
Jan 2: 76 seconds
Jan 3: 27 seconds
Jan 4: 6 seconds
原答案：
這可能是你想要做的，使用 GNU awk 作為時間函式：
$ cat tst.awk
{
prevEt = epochtime
$1 = (index("JanFebMarAprMayJunJulAugSepOctNovDec",$1) 2) / 3
epochtime = mktime("2022 " gensub(/:/," ","g"), 1)
}
NR%2 == 0 {
print prevEt, epochtime, epochtime - prevEt
}
$ awk -f tst.awk file
1640995796 1640995802 6
1640995845 1640995852 7
轉載請註明出處，本文鏈接：https://www.uj5u.com/gongcheng/412851.html
標籤：