AWK/SED 删除包含括号的列

Question

我想知道是否可以删除数据文件中包含可以包含在任何列中的任何括号的列。例如

...
John Doe (Tech Department) 09/12/2009 555-555-5555
Jane Smith 09/12/2009 555-555-5555 (Suspended)
Alfred doe 555-555-5555 (Vacation) 09/09/2011
...

，那么我希望输出看起来像

...
John Do 09/12/2009 555-555-5555
Jane Smith 09/12/2009 555-555-5555
Alfred doe 555-555-5555 09/09/2011
...

我正在考虑对括号之间的文本使用通配符？像/(*)/之类的东西？

感谢您的帮助，

托梅克

Answer 1

$ cat file
John Doe (Tech Department) 09/12/2009 (somethign else) 555-555-5555
Jane Smith 09/12/2009 555-555-5555 (Suspended)
Alfred doe 555-555-5555 (Vacation) 09/09/2011

$ awk -vRS=")" -F"(" '{ for(i=1;i<=NF;i+=2) {print $i}}' ORS="" file
John Doe  09/12/2009  555-555-5555
Jane Smith 09/12/2009 555-555-5555
Alfred doe 555-555-5555  09/09/2011

$ sed -r 's/\(.[^)]*\)//g' file
John Doe  09/12/2009  555-555-5555
Jane Smith 09/12/2009 555-555-5555
Alfred doe 555-555-5555  09/09/2011

$ awk '{gsub(/\(.[^)]*\)/,"") }1' file
John Doe  09/12/2009  555-555-5555
Jane Smith 09/12/2009 555-555-5555
Alfred doe 555-555-5555  09/09/2011

Answer 2

如果 Perl 没问题，你可以这样做：

$ cat file
John Doe (Tech Department) 09/12/2009 555-555-5555
Jane Smith 09/12/2009 555-555-5555 (Suspended)
Alfred doe 555-555-5555 (Vacation) 09/09/2011

$ perl -pe 's/\(.*?\)//g' file    
John Doe  09/12/2009 555-555-5555
Jane Smith 09/12/2009 555-555-5555 
Alfred doe 555-555-5555  09/09/2011

Answer 3

最简单的是一行 sed 命令：

$ sed -e '/[()]/d' file    
John Doe  09/12/2009  555-555-5555
Jane Smith 09/12/2009 555-555-5555
Alfred doe 555-555-5555  09/09/2011