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.