Reseting row count every given number of rows

I have a file with 48 rows. I am counting 6 rows and adding 6 to that number and repeating the operation, and then output the value in column 1. For the second column, I would like to get sort of a binary output (1s and 2s) every 3rd row. This is what I have:

 awk '{print ++src + (int((++count-1)/6)*6), (int(CNT++/3)+1)%2+1}' test.txt

And I am getting this:

1 2
 2 2
 3 2
 4 1
 5 1
 6 1
 13 2
 14 2
 15 2
 16 1
 17 1
 18 1
 25 2
 26 2
 27 2
 28 1
 29 1
 30 1
 37 2
 38 2
 39 2
 40 1
 41 1
 42 1
 49 2
 50 2
 51 2
 52 1
 53 1
 54 1
 61 2
 62 2
 63 2
 64 1
 65 1
 66 1
 73 2
 74 2
 75 2
 76 1
 77 1
 78 1
 85 2
 86 2
 87 2
 88 1
 89 1
 90 1

But the desired output is this:

1 1
 2 1
 3 1
 4 2
 5 2
 6 2
 13 1
 14 1
 15 1
 16 2
 17 2
 18 2
 25 1
 26 1
 27 1
 28 2
 29 2
 30 2
 37 1
 38 1
 39 1
 40 2
 41 2
 42 2
 49 1
 50 1
 51 1
 52 2
 53 2
 54 2
 61 1
 62 1
 63 1
 64 2
 65 2
 66 2
 73 1
 74 1
 75 1
 76 2
 77 2
 78 2
 85 1
 86 1
 87 1
 88 2
 89 2
 90 2

I am sort of getting the desired output but I can only thing there are better ways to accomplish this task.
Any help will be appreciated.

Try this instead:

awk '{print NR + 6 * int((NR - 1) / 6), int(((NR - 1) % 6) / 3) + 1}' test.txt

If you're running this on a Solaris/SunOS system, change awk to /usr/xpg4/bin/awk or nawk . (Please get into the habit of telling us what operating system and shell you're using every time you start a new thread!)

The above code does not put the leading <space> on the last 47 rows of your output, but it otherwise matches the output you said you want. If you really want the leading <space> in the output, except on the first output line, I will leave adding that <space> to the output as an exercise for the reader.

1 Like