Add number of line with awk

Question

i would to know how can i edit my csv file to add first column with name 'linenumber' and iterate through each line and insert the number of the line in this column ?

Something like that

TEST TEST2 TEST3 valu value value

To that

linenumber TEST TEST2 TEST3 1 valu value value

Thanks in advance

Stoufiler

RavinderSingh13 · Accepted Answer · 2017-10-23 13:52:46Z

1

Following awk should help you on same.

awk 'FNR==1{print "linenumber",$0;next} {print FNR-1,$0}' Input_file

In case you need to edit the Input_file itself then following may help you.

awk 'FNR==1{print "linenumber",$0;next} {print FNR-1,$0}' OFS="," Input_file > temp_file && mv temp_file Input_file

edited Oct 23, 2017 at 13:52

answered Oct 23, 2017 at 12:30

RavinderSingh13

135k14 gold badges61 silver badges100 bronze badges

Sign up to request clarification or add additional context in comments.

9 Comments

Stoufiler Over a year ago

it's work well but it's not a new column in fact they add the number and the valu :/

RavinderSingh13 Over a year ago

@Stoufiler, could you please explain your statement above, sorry didn't get it.

Stoufiler Over a year ago

sorry i'm not english :) the problem is now the file contain the same number of column but the first one is concatenate so the title of the first column is linenumber TEST and no linenumber | TEST

Stoufiler Over a year ago

@RavinderSingth13 Thanks, I'm going to try to explain myself correctly, Actually when I use the command you passed me the file is well modified but the linenumer column is not added, it is added to the first one so that the first one column equals linenumber + titleofthenextcolumn

Stoufiler Over a year ago

@RavinderSingth13 It doesn't it make the same thing, i publish a codeshare for showing you y problem [link]codeshare.io/Gbw3xV

|

RavinderSingh13 · Accepted Answer · 2017-10-23 13:54:57Z

1

i found the answer, it's that

awk 'FNR==1{print "linenumber,"$0;next} {print FNR-1,$0}' OFS="," input.csv > output.csv

thanks for all

edited Oct 23, 2017 at 13:54

RavinderSingh13

135k14 gold badges61 silver badges100 bronze badges

answered Oct 23, 2017 at 13:06

Stoufiler

1951 gold badge2 silver badges16 bronze badges

3 Comments

Stoufiler Over a year ago

@RavinderSingh13 i'm sorry to come back a new time but i would like to know how i can inverse the process so remove the first column ? :)

RavinderSingh13 Over a year ago

Sure, please edit your post or open a thread and let me know then on same,

Stoufiler Over a year ago

@RavinderSingh13 it's ok this is the new post stackoverflow.com/questions/46904805/…

Collectives™ on Stack Overflow

Add number of line with awk

2 Answers 2

9 Comments

3 Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

9 Comments

3 Comments

Linked

Related