如何使用 nawk/awk 根据文件中某一列中的值将记录重定向到不同的输出文件？

发布于 2024-12-05 02:16:28 字数 260 浏览 1 评论 0原文

如何使用 nawk/awk 根据文件中某一列中的值将记录重定向到不同的输出文件？..

chethan RA
Ramesh  RA
Sachin  RA
Gundaa  DI
dravid  DI
Suresh  SE

所以我想将 RA 记录重定向到一个文件，将 DI 记录重定向到另一个文件，将 SE 记录重定向到另一个文件。第二列中的值可以是任何值，不必是 RA、DI 或 SE。因此，根据第二列中的不同值，记录需要重定向到不同的文件。

原文

How to redirect records to different output files based on a value in one of the columns in a file using nawk/awk?..

chethan RA
Ramesh  RA
Sachin  RA
Gundaa  DI
dravid  DI
Suresh  SE

So I want to redirect RA records to one file, DI records to another file and SE records to another file. Value in Second column can be anything need not be RA, DI or SE. So based on different values in second column, records need to be redirected to different files..

分享到QQ

分享到微博

如果你对这篇内容有疑问，欢迎到本站社区发帖提问参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。

发布评论

需要登录才能够评论，你可以免费注册一个本站的账号。

没企图 2024-12-12 02:16:28

您可以尝试这样的操作：

4.1.10(4)-release$ cat infile 
chethan RA 
Ramesh RA 
Sachin RA 
Gundaa DI 
dravid DI 
Suresh SE
4.1.10(4)-release$ awk '{
>   f = $2 ".txt"
>   print > f
>   }' infile
4.1.10(4)-release$ head *txt
==> DI.txt <==
Gundaa DI 
dravid DI 

==> RA.txt <==
chethan RA 
Ramesh RA 
Sachin RA 

==> SE.txt <==
Suresh SE

考虑一些 awk 实现一次可以打开有限数量的文件。
如果是这种情况，您将需要更多代码，如下所示：

[已更正，请参阅下面的评论]

awk '{
  if (f) close(f)
  f = $2 ".txt"
  print >> f
  }' infile

后者的效率会低得多。

You could try something like this:

4.1.10(4)-release$ cat infile 
chethan RA 
Ramesh RA 
Sachin RA 
Gundaa DI 
dravid DI 
Suresh SE
4.1.10(4)-release$ awk '{
>   f = $2 ".txt"
>   print > f
>   }' infile
4.1.10(4)-release$ head *txt
==> DI.txt <==
Gundaa DI 
dravid DI 

==> RA.txt <==
chethan RA 
Ramesh RA 
Sachin RA 

==> SE.txt <==
Suresh SE

Consider that some awk implementations can open a limited number of files at a time.
If that's the case you'll need more code, something like this:

[corrected, see comments below]

awk '{
  if (f) close(f)
  f = $2 ".txt"
  print >> f
  }' infile

The latter will be far less efficient.

回复收藏 0 原文

内心激荡 2024-12-12 02:16:28

1、使用代码标签使代码易于阅读。

kent$  cat a
chethan RA 
Ramesh RA 
Sachin RA 
Gundaa DI 
dravid DI 
Suresh SE


kent$  awk '{print >> $2".txt"}' a


kent$  l
total 16K
-rw-r--r-- 1 kent kent 66 2011-09-16 11:39 a
-rw-r--r-- 1 kent kent 22 2011-09-16 11:42 DI.txt
-rw-r--r-- 1 kent kent 34 2011-09-16 11:42 RA.txt
-rw-r--r-- 1 kent kent 10 2011-09-16 11:42 SE.txt

kent$  head *.txt
==> DI.txt <==
Gundaa DI 
dravid DI 

==> RA.txt <==
chethan RA 
Ramesh RA 
Sachin RA 

==> SE.txt <==
Suresh SE

1, using the code tag to make codes easy to read.

kent$  cat a
chethan RA 
Ramesh RA 
Sachin RA 
Gundaa DI 
dravid DI 
Suresh SE


kent$  awk '{print >> $2".txt"}' a


kent$  l
total 16K
-rw-r--r-- 1 kent kent 66 2011-09-16 11:39 a
-rw-r--r-- 1 kent kent 22 2011-09-16 11:42 DI.txt
-rw-r--r-- 1 kent kent 34 2011-09-16 11:42 RA.txt
-rw-r--r-- 1 kent kent 10 2011-09-16 11:42 SE.txt

kent$  head *.txt
==> DI.txt <==
Gundaa DI 
dravid DI 

==> RA.txt <==
chethan RA 
Ramesh RA 
Sachin RA 

==> SE.txt <==
Suresh SE

回复收藏 0 原文

~没有更多了~