awk:添加新列，包括标题 [英] awk: add new column, including header

问题描述

我有一个看起来像这样的文件:

I have a file that looks like this:

name measurement gender duration
a 1 m 55
b 1 f 54
c 2 m 53
... etc

我想使用awk添加一列，除第一行(标题)外，每一行的值都相同.假设我要为每行添加值为99的new_column列，因此输出文件如下所示:

I want to use awk to add a column, which has the same value for every row, except the first (the header). Let's say I want to add the column new_column with the value 99 for every row, so the output file looks like this:

name measurement gender duration new_column
a 1 m 55 99
b 1 f 54 99
c 2 m 53 99
... etc

这听起来像是awk的工作...但是我还无法弄清楚该怎么做.有任何想法吗?非常感谢！

This sounds like a job for awk... but I haven't been able to figure out how. Any ideas? Many thanks!

推荐答案

$ awk '{s=(NR==1)?"new_column":"99";$0=$0 OFS s}1' file
name measurement gender duration new_column
a 1 m 55 99
b 1 f 54 99
c 2 m 53 99

这篇关于awk:添加新列，包括标题的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！