在两个不同的新行字符串之间提取代码

debugcn 发表于 Dev

萨斯勒

因此，我已经为此苦苦挣扎了几天，尝试使用解决方案grep，sed并且awk所有解决方案都在一定程度上有效，但并不能满足我的确切要求。以下是我正在使用的数据。我需要提取每个新行--------字符串之间的数据二等奖，或列表中每个域之间的一等奖。

我需要为每个域提取特定的数据库详细信息。

somedomain.co.za

\---------------------------

Database name   somedb_db1

Full    somepassword

Login   somelogin_1

Read only       somepassword

Read/Write      somepassword

Server name     some.host.net

somedomain.org.za

\---------------------------

Database name   somedb_db1

Full    somepassword

Login   somelogin

Read only       somepassword

Read/Write      somepassword

Server name     some.host.net

somedomain.co.za

\---------------------------

Database name   somedb_db1

Full    somepassword

Login   somelogin_1

Read only       somepassword

Read/Write      somepassword

Server name     some.host.net

somedomain.co.za

\---------------------------

Server name     some.host.net

Database name   somedb_wp

Full    somepassword

Login   somelogin_4

Read/Write      somepassword

Read only       somepassword

Server name     some.host.net

Read/Write      somepassword

Read only       somepassword

Login   somelogin_3

Full    somepassword

Database name   somedb_db3

somedomain.co.za

\---------------------------

jijinp

您可以使用awk来执行此操作，以获取具有域信息的每个数据库属性的条目。这是要求吗？

awk 'NR==nr{
    next
}
NF==1{
    nr=NR+1;
    dmn=$1;
    i=1;
    next
}
dmn"@"$1"@"i in a{
    i++
}
{
    a[dmn"@"$1"@"i];
    b[dmn","i]=b[dmn","i]","$0
}
END {
    for ( i in b) print i""b[i]
}' file

假设中没有空行File。

输入/输出：

v.co.za
\---------------------------
Database name   somedb_db1
Full    somepassword
Login   somelogin_1
Read only       somepassword
Read/Write      somepassword
Server name     some.host.net
w.org.za
\---------------------------
Database name   somedb_db1
Full    somepassword
Login   somelogin
Read only       somepassword
Read/Write      somepassword
Server name     some.host.net
z.co.za
\---------------------------
Database name   somedb_db1
Full    somepassword
Login   somelogin_1
Read only       somepassword
Read/Write      somepassword
Server name     some.host.net
y.co.za
\---------------------------
Server name     some.host.net
Database name   somedb_wp
Full    somepassword
Login   somelogin_4
Read/Write      somepassword
Read only       somepassword
Server name     some.host.net
Read/Write      somepassword
Read only       somepassword
Login   somelogin_3
Full    somepassword
Database name   somedb_db3
x.co.za
\---------------------------

O / P：

v.co.za,1,Database name   somedb_db1,Full    somepassword,Login   somelogin_1,Read only       somepassword,Read/Write      somepassword,Server name     some.host.net
w.org.za,1,Database name   somedb_db1,Full    somepassword,Login   somelogin,Read only       somepassword,Read/Write      somepassword,Server name     some.host.net
y.co.za,1,Server name     some.host.net,Database name   somedb_wp,Full    somepassword,Login   somelogin_4,Read/Write      somepassword,Read only       somepassword
y.co.za,2,Server name     some.host.net,Read/Write      somepassword,Read only       somepassword,Login   somelogin_3,Full    somepassword,Database name   somedb_db3
z.co.za,1,Database name   somedb_db1,Full    somepassword,Login   somelogin_1,Read only       somepassword,Read/Write      somepassword,Server name     some.host.net

本文收集自互联网，转载请注明来源。

如有侵权，请联系[email protected] 删除。