|
Need to extract egyedi mintát a naplófájl
Naplófájl:
Próbál kapcsolatot (DESCRIPTION \u003d (SOURCE_ROUTE \u003d OFF) (ADDRESS_LIST \u003d (ADDRESS \u003d (PROTOCOL \u003d TCP) (HOST \u003d hostname1.com) (PORT \u003d 1521))) (CONNECT_DATA \u003d (SID \u003d database1) (\u003d SRVR dedikált)) )
Próbál kapcsolatot (DESCRIPTION \u003d (SOURCE_ROUTE \u003d OFF) (ADDRESS_LIST \u003d (ADDRESS \u003d (PROTOCOL \u003d TCP) (HOST \u003d hostname2.com) (PORT \u003d 1521))) (CONNECT_DATA \u003d (SID \u003d database2) (\u003d SRVR dedikált)) )
Próbál kapcsolatot (DESCRIPTION_LIST \u003d (DESCRIPTION \u003d (SOURCE_ROUTE \u003d OFF) (ADDRESS_LIST \u003d (ADDRESS \u003d (PROTOCOL \u003d TCP) (HOST \u003d hostname 3.com) (PORT \u003d 1521))) (CONNECT_DATA \u003d (SID \u003d database3) (SRVR Célzott \u003d))) (DESCRIPTION \u003d (SOURCE_ROUTE \u003d OFF) (AD DRESS_LIST \u003d (ADDRESS \u003d (PROTOCOL \u003d TCP) (HOST \u003d hostname3.com) (PORT \u003d 1522))) (CONNECT_DATA \u003d (SID \u003d database3) (SRV R Célzott \u003d))))
Próbál kapcsolatot (DESCRIPTION_LIST \u003d (DESCRIPTION \u003d (SOURCE_ROUTE \u003d OFF) (ADDRESS_LIST \u003d (ADDRESS \u003d (PROTOCOL \u003d TCP) (HOST \u003d hostname 4.com) (PORT \u003d 1521))) (CONNECT_DATA \u003d (SID \u003d database4) (SRVR Célzott \u003d))) (DESCRIPTION \u003d (SOURCE_ROUTE \u003d OFF) (AD DRESS_LIST \u003d (ADDRESS \u003d (PROTOCOL \u003d TCP) (HOST \u003d hostname4.com) (PORT \u003d 1522))) (CONNECT_DATA \u003d (SID \u003d database4) (SRV R Célzott \u003d))))
Szükségem van, mint a kimenő alábbiakban megpróbáltam regular expression / awk - nem tudott a várható kibocsátás (alább egy)
HOST PORT SID
hostname1.com 1521 database1
hostname2.com 1521 database2
hostname3.com 1522 database3
hostname4.com 1522 database4
Tud valaki kérem, segítsen nekem ezzel?
|