Shell Programming and Scripting

Hi All,

I have been trying to re-arrange the below data using AWK or Perl.
Can anybody help me ?
Thanks in advance.

Input:

Code:

111 222
333 444
AAA BBB
CCC DDD
555 666
777 888
EEE FFF
GGG HHH

Output:

Code:

111 222  AAA BBB
333 444  CCC DDD
555 666  EEE FFF
777 888  GGG HHH

Try this:

Code:

awk '{a[NR%4]=$0}
NR%4==2 {getline;print a[1],$0;getline;print a[2],$0
}' file

Regards

Hi Franklin52,

Wow, that's really cool.
It works !!
Thanks alot!

But i am a beginner in AWK, can you explain your code so that i can understand better ?

OK, here we go:

Code:

awk '{a[NR%4]=$0}
NR%4==2 {getline;print a[1],$0;getline;print a[2],$0
}' file

We use as subscript of the array a, the remainder of NR/4 (division of NR by 4) with the modulo (%) operator.
The first line has the subscript 1 % 4 = 1
The second line has the subscript 2 % 4 = 2

Line 1:

If the 1st line is read, a[NR%4] = a[1] contains the 1st line ($0).
NR%4 == 1 so the code of the 2nd are skipped.

Line2:

a[NR%4] = a[2] contains the 2nd line.
NR%4 = 2 so the commands of the 2nd line of the code are processed.
The 1st statement is getline to read the next line. We use getline to continue with the next statement after reading the next line.
Now $0 contains the 3th line.
The next command prints a[1] = the first 1 and $0 (the 3th line).
After that, we get the nextline. Now $0 contains the 4th line.
The last the command prints a[2] = the 2nd line and $0 (the 4th line).

The next line is the 5th line, NR%4 = 5%4 = 1 and the we start the sequence again of line 1 and so forth.


Regards

Hi Franklin52,

Thanks for the comprehensive explanation.
What if for now my reference is on the term Device and Chip, how can the code be modified to suit this change ?


Input

Code:

Device 222
Device 444
Chip BBB
Chip DDD
Device 666
Device 888
Chip FFF
Chip HHH
Device 999
Chip GGG
Device 101
Device 102
Chip JJJ
Chip III

Output

Code:

Device 222  Chip BBB
Device 444  Chip DDD
Device 666  Chip FFF
Device 888  Chip HHH
Device 999  Chip GGG
Device 101  Chip JJJ
Device 102  CHip III

Try this :

Code:

grep '^D' file >new1
grep '^C' file >new2
paste new1 new2

If both Device and Chip have the same number of rows this should work:

Code:

awk '/Device/{a[_a++]=$0};/Chip/{b[_b++]=$0}END{for(i in a) print a[i],b[i]}' file