Increment number using AWK

Question

I have a file which contains the following:

export TM_FUNCTION=SUM08619 ;export TM_PARAM_SEQNO=2 ;export PSEUDO_USER=HIHI; . /projects/MSS/LEE1MP/shells/sumh8701.sh  001 DATE:W:0:C:D:1:11:1:N:: DATE:W:0:C:D:1:11:N:1:W: IT ++ ++ 000052233714 DATE:W:0:C:D:1:11:N:N:: 100000 N FMPOST A / &

If i run the following value 100000 is returned:

awk -F' ' '{ print $17 }' filename

I would like to increment $17 using a script by 1 each time i run what is the best way?

Wiktor Stribiżew · Accepted Answer · 2020-12-19 23:23:20Z

3

You can use

awk '{$17=$17+1}1' filename > tmp && mv tmp filename

Calling this each time will increment Field 17 by one.

If you have a GNU awk you may use

awk -i inplace '{$17=$17+1}1' filename

answered Dec 19, 2020 at 23:23

Wiktor Stribiżew

631k41 gold badges502 silver badges632 bronze badges

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

1 Comment

Ed Morton Over a year ago

awk supports pre/post increment operators so $17++ instead of $17=$17+1 would work too.

RARE Kpop Manifesto · Accepted Answer · 2023-10-27 03:44:40Z

0

mawk '++$17_'  # either form works
gawk '_$17++'

The extra _ is a somewhat uncommon but still POSIX-compliant way to

force string concat with empty string _

thus guaranteeing print out of all rows even if $17 got incremented from -1 to 0 due to this awk peculiarity :

numeric zero (+0) := false

but

string zero ("0") := TRUE (since it's a non-empty string)

answered Oct 27, 2023 at 3:44

RARE Kpop Manifesto

3,0256 silver badges15 bronze badges

Collectives™ on Stack Overflow

Increment number using AWK

2 Answers 2

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related