How to add column to table with awk

Question: How to add column to table with awk

22 days ago by

linelr • 10

Norwegian University of Life Sciences

linelr • 10 wrote:

Hi Biostars community

I have a file with positions of methylated cytosines , but I want to add a new column to this file with the position+1 value (as if it was a dinucleotide).

I have used awk to print our the new value, but I need to add this new column to my file.

My file looks like this

NC_001960.1 1067
NC_001960.1 1068
NC_001960.1 1069
NC_001960.1 1133

And I do this with awk: awk -v s=1 '{print $(NF)+s}' test Which gives me this output:

1068

1069

1070

1134

And I´d like to add this as the third column in the above file

NC_001960.1 1067 1068
NC_001960.1 1068 1069
NC_001960.1 1069 1070
NC_001960.1 1133 1134

Is it possible to do this with awk or with some other method?

bash shell unix awk bed-files • 141 views

ADD COMMENT • link •

modified 22 days ago by Shalu Jhanwar • 400 • written 22 days ago by linelr • 10

22 days ago by

rpolicastro • 720

rpolicastro • 720 wrote:

You can just slightly modify your awk command.

awk -v s=1 '{print $0,$(NF)+s}' test

NC_001960.1 1067 1068
NC_001960.1 1068 1069
NC_001960.1 1069 1070
NC_001960.1 1133 1134

ADD COMMENT • link modified 22 days ago • written 22 days ago by rpolicastro • 720

Allright, that was so easy I´m almost embarrassed :) thanks a bunch!

ADD REPLY • link written 22 days ago by linelr • 10

If an answer was helpful, you should upvote it; if the answer resolved your question, you should mark it as accepted. You can accept more than one if they work.
Upvote|Bookmark|Accept

ADD REPLY • link written 22 days ago by genomax ♦ 87k

22 days ago by

Shalu Jhanwar • 400

Switzerland

Shalu Jhanwar • 400 wrote:

Yes, it's possible to append a column in the using the code below:

awk -v s=1 '{print $0,$(NF)+s}' test

Where test file is

NC_001960.1 1067

NC_001960.1 1068

NC_001960.1 1069

NC_001960.1 1133

The output of the code is:

NC_001960.1 1067 1068

NC_001960.1 1068 1069

NC_001960.1 1069 1070

NC_001960.1 1133 1134

ADD COMMENT • link written 22 days ago by Shalu Jhanwar • 400

thank you for taking time answering me!

ADD REPLY • link written 22 days ago by linelr • 10

Please log in to add an answer.

Similar posts • Search »