如何合并多个文本文件中的列? [英] How to combine column from multiple text files?

问题描述

我想从一堆文本文件中提取并合并某一列，如图所示.

I want to extract and combine a certain column from a bunch of text files into a single file as shown.

File1_example.txt

A   123   1
B   234   2
C   345   3
D   456   4

File2_example.txt

A   123   5
B   234   6
C   345   7
D   456   8

File3_example.txt

A   123   9
B   234   10
C   345   11
D   456   12

...

..

.

File100_example.txt

A   123   55
B   234   66
C   345   77
D   456   88

如何遍历感兴趣的文件并将这些列粘贴在一起，以便最终结果如下所示，而不必键入1000个唯一的文件名?

How can I loop through my files of interest and paste these columns together so that the final result is like below without having to type out 1000 unique file names?

1   5   9   ...  55
2   6   10  ...  66
3   7   11  ...  77
4   8   12  ...  88

推荐答案

尝试一下:

paste File[0-9]*_example.txt | awk '{i=3;while($i){printf("%s ",$i);i+=3}printf("\n")}'

示例:
File1_example.txt:

Example:
File1_example.txt:

A   123   1
B   234   2
C   345   3
D   456   4

File2_example.txt:

File2_example.txt:

A   123   5
B   234   6
C   345   7
D   456   8

运行命令为:

$ paste File[0-9]*_example.txt | awk '{i=3;while($i){printf("%s ",$i);i+=3}printf("\n")}'

输出:

1 5 
2 6 
3 7 
4 8

这篇关于如何合并多个文本文件中的列?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！