Login or Register to Ask a Question and Join Our Community


Shell Programming and Scripting

Increment Gawk

Login or Register to Reply

 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting Increment Gawk
# 1  
Old 07-12-2012
Increment Gawk
Hi,
I have a small query with gawk which i'm unsure how to solve. My csv input data is as follows:

1 58352.9 34549 -469.323 LINE_149
2 58352.9 34499 -469.323 LINE_149
3 58352.9 34549 -469.323 LINE_151
4 58352.9 34503.4 -489.841 LINE_151
5 58352.9 34549 -469.323 LINE_152
6 58352.9 34503.4 -448.804 LINE_152
My output csv data should look like the following:

1 58352.9 34549 -469.323 LINE_149 OR109_0001
2 58352.9 34499 -469.323 LINE_149 OR109_0001
3 58352.9 34549 -469.323 LINE_151 OR109_0002
4 58352.9 34503.4 -489.841 LINE_151 OR109_0002
5 58352.9 34549 -469.323 LINE_152 OR109_0003
6 58352.9 34503.4 -448.804 LINE_152 OR109_0003
I figured it's a job for gawk. What I want to do is print $0 and add another alphanumeric field (OR109_0001 etc) that increments by 0001 every second row. However, i'm unsure how to get the increment to work Smilie.

Regards theflamingmoe.
# 2  
Old 07-12-2012
Code:
awk '{printf("%s OR109_%04d\n",$0,NR%2?++i:i)}' inputfile

This User Gave Thanks to elixir_sinari For This Post:
theflamingmoe
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Increment the password value

I want a script which increments the count when the script runs. Basically I want to send an password reset email notification for an application, the password value should be keep on changing whenever the script is executed for example, first time i execute it should be password1, second time... (2 Replies)
Discussion started by: JAGADESH GN
2 Replies

2. Shell Programming and Scripting

Increment time

I have to increment time ... by sec but i am getting the output like this. for m in {2..3} > do > for (( i = 1; i <= 13; i++ )) > do > echo "$m:$i" > done > done 2:1 2:2 2:3 2:4 2:5 2:6 2:7 2:8 (2 Replies)
Discussion started by: kalyankalyan
2 Replies

3. Shell Programming and Scripting

Date increment

hi Friends, Today_Dt=`date "+%Y-%m-%d"` So the Today date is 2010-05-03 I have a file which has date values as below 2010-04-27 2010-04-02 2010-04-18 2010-04-28 2010-04-29 .. (1 Reply)
Discussion started by: Gopal_Engg
1 Replies

4. Shell Programming and Scripting

Increment in date

Hi, I have a variable lets say DATA_DATE. I have to pass some value to this variable in YYYYMMDD format. lets say today I have passed this variable as : DATA_DATE=20100107 Then pls help me how to calculate another variable DATA_DATE1 (which is DATA_DATE+1). The code should work... (3 Replies)
Discussion started by: 46019
3 Replies

5. Shell Programming and Scripting

Increment of a variable

Hi All, I have a variable n that stores a number. Eg. echo $n comes out to be 120. I need to print 121 using echo command on n. Please advice. Thanks in advance !! (4 Replies)
Discussion started by: learning_skills
4 Replies

6. Shell Programming and Scripting

auto increment

Hello Does anyone know how to auto-increment the value of a variable, preferably using awk or sed? I need to read values from a file and auto-increment those values to use them as line numbers I'd be doing: while read line do # auto-increment sed -n${line}p file> file1 done... (6 Replies)
Discussion started by: loperam
6 Replies

7. Shell Programming and Scripting

Increment value (starttime)

Hi All, I have created a script... #!/bin/sh datafile=ABC2008101601.OUT indfile=ABCIND20081016.1.OUT waittime=600 starttime=0 while do if then echo "Indicator file has arrived." break else sleep 10; ((starttime=$starttime+10)) echo $starttime (2 Replies)
Discussion started by: Amit.Sagpariya
2 Replies

8. Shell Programming and Scripting

increment an integer

hi I want to echo the variable $i while it auto-increments till 21 I set initially i to 1 any idea how to do that? thank you (4 Replies)
Discussion started by: melanie_pfefer
4 Replies

9. Shell Programming and Scripting

gawk HELP

I have to compare records in two files. It can be done using gawk/awk but i am unable to do it. Please help me File1 ABAAAAAB BC asa sa ABAAABAA BC bsa sm ABBBBAAA BC bxz sa ABAAABAB BC csa sa ABAAAAAA BC dsa sm ABBBBAAB BC dxz sa File 2 ABAAAAAB BC aas ba ABAAAAAB BC asa sa... (6 Replies)
Discussion started by: sandeep_hi
6 Replies

10. Shell Programming and Scripting

increment a Variable

hi, i want to increment a Variable but it doesnt work. here my codé COUNT=1 COUNT= 'expr $COUNT + 1' i've tried it in the prompt but it print me: expr: syntaxerror What does I make wrong? (4 Replies)
Discussion started by: cengiz
4 Replies
Login or Register to Ask a Question