文本处理-升级时间线

bikkuri

大家好，我有一个问题向大家请教。
有这样一个文本，是数据库的查询结果，每条记录包括UPGRADETIME（升级时间）, DISPLAYEDUPGRADETIME（显示升级时间）, FROMSCHEMAVERSION（起始版本）, TOSCHEMAVERSION（目的版本）四项内容。
以下是一个样本：
[root@cat1:~]# show-upgrade-history

SQL*Plus: Release 19.0.0.0.0 - Production on Thu Jan 13 10:56:23 2022
Version 19.7.0.0.0

Copyright (c) 1982, 2020, Oracle.  All rights reserved.

Last Successful login time: Wed Nov 17 2021 08:10:33 +08:00

Connected to:
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.7.0.0.0

SQL>
UPGRADETIME
--------------------------------------------------------------------------------
DISPLAYEDUPGRADETIME
--------------------------------------------------------------------------------
FROMSCHEMAVERSION
--------------------------------------------------------------------------------
TOSCHEMAVERSION
--------------------------------------------------------------------------------
1618455746876
2021.04.15-11.02.26
NSP Version 19.9 - Built on Fri Sep 20 11:20:05 EDT 2019
NSP Version 20.6 - Built on Sat Jun 20 04:39:25 EDT 2020


UPGRADETIME
--------------------------------------------------------------------------------
DISPLAYEDUPGRADETIME
--------------------------------------------------------------------------------
FROMSCHEMAVERSION
--------------------------------------------------------------------------------
TOSCHEMAVERSION
--------------------------------------------------------------------------------
1567050072715
2019.08.29-11.41.12
NSP Version 18.9 - Built on Mon Sep 24 07:34:03 EDT 2018
NSP Version 19.6 - Built on Mon Jun 24 06:16:02 EDT 2019


UPGRADETIME
--------------------------------------------------------------------------------
DISPLAYEDUPGRADETIME
--------------------------------------------------------------------------------
FROMSCHEMAVERSION
--------------------------------------------------------------------------------
TOSCHEMAVERSION
--------------------------------------------------------------------------------
1571802180647
2019.10.23-11.43.00
NSP Version 19.6 - Built on Mon Jun 24 06:16:02 EDT 2019
NSP Version 19.9 - Built on Fri Sep 20 11:20:05 EDT 2019


SQL> Disconnected from Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.7.0.0.0
[root@cat1:~]#

希望以UPGRADETIME（升级时间）进行排序，然后以如下方式进行输出一行结果：
18.9___2019.08.29-11.41.12___19.6___2019.10.23-11.43.00___19.9___2021.04.15-11.02.26___20.6

谢谢大家！

lvyuancyx

建议结果放到notepad++中，行列就明显了。

bikkuri

[root@apaciprtac:/tmp]# sed ':t;N;s/\n/\t/;b t' info|awk '{for(i=1;i<=NF;i++)if($i=="TOSCHEMAVERSION"){j++;u[j,1]=$(i+2);u[j,2]=$(i+3);u[j,3]=$(i+6);u[j,4]=$(i+18)}}END{for(x=1;x<=j;x++)for(y=1;y<=4;y++)print u[x,y]}'
1618455746876
2021.04.15-11.02.26
19.9
20.6
1567050072715
2019.08.29-11.41.12
18.9
19.6
1571802180647
2019.10.23-11.43.00
19.6
19.9
[root@apaciprtac:/tmp]# sed ':t;N;s/\n/\t/;b t' info|awk '{for(i=1;i<=NF;i++)if($i=="TOSCHEMAVERSION"){j++;u[j,1]=$(i+2);u[j,2]=$(i+3);u[j,3]=$(i+6);u[j,4]=$(i+18)}}END{for(x=1;x<=j;x++)print u[x,1], u[x,3]"__"u[x,2]"__"u[x,4]}'
1618455746876 19.9__2021.04.15-11.02.26__20.6
1567050072715 18.9__2019.08.29-11.41.12__19.6
1571802180647 19.6__2019.10.23-11.43.00__19.9
[root@apaciprtac:/tmp]#

接下来要如何排序输出呢？