Simple awk script needed

Shell Programming and Scripting
1

but I'm stumped...please help

I have a file like this.......

1000   1    34
1000   10   34
1000   11   35
1000   20   35
1000   21   36
1000   30   36
2000    1    34
2000    10   34

which I would like printed out as 40 lines

1000  1   34
1000  2   34
1000  3   34
1000  4   34
1000  5   34
1000  6   34
1000  7   34
1000  8   34
1000  9   34
1000  10   34
1000  11   35
1000  12   35
1000  13   35
1000  14   35
1000  15   35
1000  16   35
1000  17   35
1000  18   35
1000  19   35
1000  20   35
1000  21   36
1000  22   36
1000  23   36
1000  24   36
1000  25   36
1000  26   36
1000  27   36
1000  28   36
1000  29   36
1000  30   36
2000  1   34
2000  2   34
2000  3   34
2000  4   34
2000  5   34
2000  6   34
2000  7   34
2000  8   34
2000  9   34
2000  10   34

---------- Post updated at 01:22 PM ---------- Previous update was at 01:15 PM ----------

Actually the input file is

1000 1 
1000 10 
1000 11 
1000 20
1000 21
1000 30 
2000 1 
2000 10

I would like to set $3 based on when the range was read, i.e. between $2 on line 1 and $2 on line2, $3 should be 34, between $2 on line 3 and $2 on line 4, $3 should be 35 etc

2

try:

awk '{getline x; $0=$0" "x; if (!a[$1]++) {e=s} else {e++}; for (i=$2; i<=$4; i++) print $1, i, e}' s=34 infile
3

I took your example file:

1000 1 
1000 10 
1000 11 
1000 20
1000 21
1000 30 
2000 1 
2000 10

named it as unsorted.txt and ran the following statement...

sort -k 1 -k 2 -n unsorted.txt | awk ' { print $1 " " $2 " " 34+($2 - ($2 % 10))/10}'

and got this output...

1000 1 34
1000 10 35
1000 11 35
1000 20 36
1000 21 36
1000 30 37
2000 1 34
2000 10 35

I beleive that satisfies your requirement and uses awk?

---------- Post updated at 11:27 AM ---------- Previous update was at 11:13 AM ----------

This prints out 40 lines...which mine response failed to do :(.
I won't pretend I understand what it's doing. However I noted for cases where $2 is a multiple of 10 this produces the incorrect $3.

1000 10 34
1000 30 36

I wonder if you/he could combine the modulus method in my above response with this printing method?