如何实现文本内容替换

netocool

1. [erpts_pd1]
   
2. database = pd1
   
3. host = 10.24.5.3
   
4. isolation_level = DATABASE_SETTING
   
5. password = enc:+dAaASt9cdtpVDw==
   
6. port = 1601
   
7. readonly = 1
   
8. type = oracle
   
9. username = system
   
10. disabled = 0
    
11. 
    
12. [tiyandian-ksxt_inventory]
    
13. database = inventory
    
14. host = 10.2.1.65
    
15. isolation_level = DATABASE_SETTING
    
16. password = enc:ajp7z9mPc/macdQ==
    
17. port = 3306
    
18. readonly = 1
    
19. type = mysql
    
20. username = inventory
    
21. disabled = 0
    
22. 
    
23. [server1_a_mes]
    
24. database = a_mes
    
25. host = 10.2.1.2
    
26. isolation_level = DATABASE_SETTING
    
27. password = enc:7qavvVE2bZxMfy02JQ==
    
28. port = 1433
    
29. readonly = 1
    
30. type = mssql
    
31. username = sa

复制代码

如上的文本内容，如何实现把"[xxx]"的内容改为：
10.2.1.2_mssql_a_mes


就是把每一区域内的内容的host,type和database字段找出来，然后组成[]内的内容。


谢谢。

WilliBhamlll

1. awk -F'[= ]+' 'NR==FNR{if(/^\[/){s=$0;next}{if(/^host|^type/){a[s]=a[s]?a[s]"_"$2:$2}}next}a[$0]{sub(/[^_]+_/,"["a[$0]"_")}1' file file

复制代码

rik782

sed -i 's/^\[.*\]$/\[10.2.1.2_mssql_a_mes\]/g' file

cd_chair

1. awk 'BEGIN{RS=ORS="\n\n";FS=OFS="\n"}{split($2,a," = ");split($3,b," = ");split($8,c," = ");gsub(/\[(.*)\]/,"["b[2]"_"c[2]"_"a[2]"]",$1);print $0}'

复制代码

csccyab

$ awk 'database && host && type { print host"_"type"_"database; database=""; host=""; type="" } { if ($0 ~ /database/) database=$3; if ($0 ~ /host/) host=$3; if ($0 ~ /type/) type=$3}' 1

10.24.5.3_oracle_pd1
10.2.1.65_mysql_inventory
10.2.1.2_mssql_a_mes