Convert row to columns start from nth column

Shell Programming and Scripting
1

Dear All,

We have input like this:

       161                                 57  1378   176  1392   262  1444   441  1548   538  1611   670  1684
       241                                 57  1378   208  1393   269  1447   444  1549   538  1610   677  1700
       321                                 61  1378   197  1391   269  1448     
       401                                 72  1377   194  1389   265  1444     
       481                                 79  1377   197  1390   269  1446     
       561                                 75  1377   186  1390   269  1446

Algoritm: Convert row to columns start from 2nd to end of column

expected result:

       161                                 57   1378   
       161                                 176  1392   
       161                                 262  1444   
       161                                 441  1548   
       161                                 538  1611   
       161                                 670  1684
       241                                 57   1378   
       241                                 208  1393   
       241                                 269  1447   
       241                                 444  1549   
       241                                 538  1610   
       241                                 677  1700
       321                                 61   1378   
       321                                 197  1391   
       321                                 269  1448    
       401                                 72   1377   
       401                                 194  1389   
       401                                 265  1444    
       481                                 79   1377   
       481                                 197  1390   
       481                                 269  1446    
       561                                 75   1377   
       561                                 186  1390   
       561                                 269  1446

Thanks for advance,

Attila

2

Had you searched these forums for your problem, you might have come up with e.g. this.

3

Hi RudiC,
Thanks for suggestion, but we need to print it into 3 columns. Any idea?

---------- Post updated at 02:58 AM ---------- Previous update was at 02:14 AM ----------

Solved:

awk '{ for(a=2; a<=NF; a+=2) print ($1, $a, $(a+1)) }'
4

Attaboy!

5

Hi All, I am new to this forum . I am struggling with one issue

I have record set like (fixed width file)

1HKG  BKK  20140425201
2HKG  BKK  20140425201
3HKG  BKK  20140425201
1SIN  KUL  20140414201
2SIN  KUL  20140414201
3SIN  KUL  20140414201
1HKG  BKK  20140427201
2HKG  BKK  20140427201
3HKG  BKK  20140427201
1HKG  BKK  20140424201
2HKG  BKK  20140424201
3HKG  BKK  20140424201
1CDG  PVG  20140414201
2CDG  PVG  20140414201
3CDG  PEK  20140414201
3PEK  PVG  20140415201
1YYZ  BLR  20140414201
2YYZ  BLR  20140414201
3YYZ  FRA  20140414201
3FRA  BLR  20140415201
1BKK  CDG  20140409201

so there will be only 1,2,3 value in first field i need to assign seq number and output like this

1 1HKG  BKK  20140425201
1 2HKG  BKK  20140425201
1 3HKG  BKK  20140425201
2 1SIN  KUL  20140414201
2 2SIN  KUL  20140414201
2 3SIN  KUL  20140414201
3 1HKG  BKK  20140427201
3 2HKG  BKK  20140427201
3 3HKG  BKK  20140427201
4 1HKG  BKK  20140424201
4 2HKG  BKK  20140424201
4 3HKG  BKK  20140424201
5 1CDG  PVG  20140414201
5 2CDG  PVG  20140414201
5 3CDG  PEK  20140414201
5 3PEK  PVG  20140415201
6 1YYZ  BLR  20140414201
6 2YYZ  BLR  20140414201
6 3YYZ  FRA  20140414201

Please help