请问如何从两个文本文件中取得信息并按格式输出？

bikkuri

大家好！
我有一个问题想向大家请教。
有这样两个数据文件的样本，我希望从中获取对应的信息并按一定格式输出。

文件1：
<a href3D"https://takumi.maruyama.com/5003h0000021b89AAA/view" style3D"color:rgb(0,112,210); word-break:break-all">00232281</a>
<a href3D"https://takumi.maruyama.com/5003h0000021b89AAA/view" style3D"color:rgb(0,112,210); word-break:break-all">Why there is PmFileNotificationMissing alarm on NSP? How to clean it permanently</a>
Myanmar
<a href3D"https://takumi.maruyama.com/0014100000LUlPtAAL/view" style3D"color:rgb(0,112,210); word-break:break-all">OOREDOO MYANMAR LIMITED</a>
<a href3D"https://takumi.maruyama.com/0033h000003NQAJAA4/view" style3D"color:rgb(0,112,210); word-break:break-all">Sareth Mak</a>
2/7/2020 11:36 AM
2/7/2020 11:50 AM
689
<a href3D"https://takumi.maruyama.com/0052M000009BySQQA0/view" style3D"color:rgb(0,112,210); word-break:break-all">Satomi Ishihara</a>
Responded in Progress
-
Medium
Major
NSP (Network Services Platform)
NFM-P (Network Functions Manager - Packet)
NSPD-251444
<a href3D"https://takumi.maruyama.com/5003h0000022JtCAAU/view" style3D"color:rgb(0,112,210); word-break:break-all">00237425</a>
<a href3D"https://takumi.maruyama.com/5003h0000022JtCAAU/view" style3D"color:rgb(0,112,210); word-break:break-all">We have an issue February 11, 2020 measurement missing at G2102 & G 2103 (CMG file) around 00 - 01 AM, we try to backup manually data file to NSP but cannot generate and result blank (as attached). Is it any other work around to recovery this issue?</a>
Indonesia
<a href3D"https://takumi.maruyama.com/0014100000LUkfCAAT/view" style3D"color:rgb(0,112,210); word-break:break-all">PT HUTCHISON 3 INDONESIA</a>
<a href3D"https://takumi.maruyama.com/0033h000003NOvpAAG/view" style3D"color:rgb(0,112,210); word-break:break-all">Amin Susmanto</a>
2/12/2020 10:20 AM
2/12/2020 11:01 AM
571
<a href3D"https://takumi.maruyama.com/0052M000009BySQQA0/view" style3D"color:rgb(0,112,210); word-break:break-all">Satomi Ishihara</a>
Responded in Progress
Open Violation
Low
Major
NSP (Network Services Platform)
NFM-P (Network Functions Manager - Packet)
na
<a href3D"https://takumi.maruyama.com/5003h0000023dWAAAY/view" style3D"color:rgb(0,112,210); word-break:break-all">00239567</a>
<a href3D"https://takumi.maruyama.com/5003h0000023dWAAAY/view" style3D"color:rgb(0,112,210); word-break:break-all">Create an alarm in NFM-P when the KPI 93VS.rateLimitMaxTps94 is reaching 1500 (our current max limit is 2000) </a>
Myanmar
<a href3D"https://takumi.maruyama.com/0014100000LUlPtAAL/view" style3D"color:rgb(0,112,210); word-break:break-all">OOREDOO MYANMAR LIMITED</a>
<a href3D"https://takumi.maruyama.com/0033h000003NQAJAA4/view" style3D"color:rgb(0,112,210); word-break:break-all">Sareth Mak</a>
2/19/2020 5:22 PM
2/19/2020 5:25 PM
396
<a href3D"https://takumi.maruyama.com/0052M000009BySQQA0/view" style3D"color:rgb(0,112,210); word-break:break-all">Satomi Ishihara</a>
Responded in Progress
Compliant
Medium
Minor
NSP (Network Services Platform)
NFM-P (Network Functions Manager - Packet)
NSPD-263724



文件2：
NSPD-251444|Not-Escalated|Unresolved|Conar Mcgill|Satomi Ishihara


输出格式为：

1. |No|SF------|PTS--------[S]|Severity|Priority|Description------------------------------------------------------|CUSTOMER---------|State----------------|ReportedOn[Day]|
   
2. | 1|00232281|NSPD-246384[U]|Major   |Medium  |Why there is PmFileNotificationMissing alarm on NSP? How to cle..|OOREDOO MYANMAR..|Responded in Progress|2020-02-07[ 30]|
   
3. | 2|00237425|na            |Major   |Low     |We have an issue February 11, 2020 measurement missing at G2102..|PT HUTCHISON 3 ..|Responded in Progress|2020-02-12[ 25]|
   
4. | 3|00239567|NSPD-263724[*]|Minor   |Medium  |Create an alarm in NFM-P when the KPI 93VS.rateLimitMaxTps94 is..|OOREDOO MYANMAR..|Responded in Progress|2020-02-19[ 18]|
   
5. +--+--------+--------------+--------+--------+-----------------------------------------------------------------+-----------------+---------------------+---------------+

复制代码

其中：
1）PTS--------[S]是指当PTS对应的取值不是na的时候，就到文件2中去找到对应行的第三个字段的首字母，如果找不到则显示*；
例如，NSPD-251444对应行的第三个字段Unresolved的首字母为U，则显示为[U]
NSPD-263724对应行找不到，则显示为*

2）Description的长度超过66，CUSTOMER的长度超过18，则自动截短长度为64或16，并在后面加上两个点..；

3）ReportedOn[Day]中的Day是要根据报告日日期计算出距离今天的天数；
例如：2020-02-07[ 30]中的30是用今天2020-03-8减去2020-02-07得到的天数。

谢谢大家的帮助！

Looiml

cat a.txt
<a href3D"https://takumi.maruyama.com/5003h0000021b89AAA/view" style3D"color:rgb(0,112,210); word-break:break-all">00232281</a>
<a href3D"https://takumi.maruyama.com/5003h0000021b89AAA/view" style3D"color:rgb(0,112,210); word-break:break-all">Why there is PmFileNotificationMissing alarm on NSP? How to clean it permanently</a>
Myanmar
...

cat b.txt
NSPD-251444|Not-Escalated|Unresolved|Conar Mcgill|Satomi Ishihara


cat test.awk

1. BEGIN {
   
2.         OFS="|"
   
3.         print "|No|SF------|PTS--------[S]|Severity|Priority|Description-------------------------------------------------------|CUSTOMER----------|State----------------|ReportedOn[Day]|"
   
4. }
   
5. 
   
6. NR==FNR {
   
7.         FS="|";$0=$0
   
8.         a[$1]=substr($3,1,1)
   
9. }
   
10. 
    
11. NR>FNR && FNR%16==1{
    
12.         no+=1
    
13.         FS="<[^<>]+>";$0=$0
    
14.         delete f
    
15.         f[1]=$2
    
16.         for(i=2;i<=16;i++) {
    
17.                 getline
    
18.                 f[i]=$2?$2:$1
    
19.         }
    
20.         $1=sprintf("%2d",no)
    
21.         $2=f[1]
    
22.         $3=f[16]
    
23.         if($3!="na") $3=$3"["(a[f[16]]?a[f[16]]:"*")"]"
    
24.         $3=sprintf("%-14s",$3)
    
25.         $4=sprintf("%-8s",f[13])
    
26.         $5=sprintf("%-8s",f[12])
    
27.         $6=sprintf("%-66s",length(f[2])>66?(substr(f[2],1,64)".."):f[2])
    
28.         $7=sprintf("%-18s",length(f[4])>18?(substr(f[4],1,16)".."):f[4])
    
29.         $8=sprintf("%-21s",f[10])
    
30.         split(f[6],time,"[ /]")
    
31.         t=mktime(sprintf("%d %d %d 0 0 0",time[3],time[1],time[2]))
    
32.         $9=strftime("%F",t)"["sprintf("%3d",int((systime()-t)/(60*60*24)))"]"
    
33.         print "|"$0"|"
    
34. }

复制代码

awk -f test.awk b.txt a.txt

1. |No|SF------|PTS--------[S]|Severity|Priority|Description-------------------------------------------------------|CUSTOMER----------|State----------------|ReportedOn[Day]|
   
2. | 1|00232281|NSPD-251444[U]|Major   |Medium  |Why there is PmFileNotificationMissing alarm on NSP? How to clea..|OOREDOO MYANMAR ..|Responded in Progress|2020-02-07[ 30]|
   
3. | 2|00237425|na            |Major   |Low     |We have an issue February 11, 2020 measurement missing at G2102 ..|PT HUTCHISON 3 I..|Responded in Progress|2020-02-12[ 25]|
   
4. | 3|00239567|NSPD-263724[*]|Minor   |Medium  |Create an alarm in NFM-P when the KPI 93VS.rateLimitMaxTps94 is ..|OOREDOO MYANMAR ..|Responded in Progress|2020-02-19[ 18]|

复制代码

Looiml

效果如图。

bikkuri

非常感谢！