Transpose short columns to row and rearrange the positions using awk/sed -


I have the current dataset as given below:

  11 48 5300 8000 1 0 ht2 Ht2 11 49 5300 8000 1 0 HT 2 HT 2 11 50 5300 8000 2 HT 2 HT 2 11 51 5300 8000 2 HT 2 HT 3 11 52 5300 8000 2 0 HT 2 HT 3   

Re: I want to organize I like the following data:

  11 48 5300 8000 1 0 ht2 HT 2 11 49 5300 8000 1 0 HT 2 HT 2 11 50 5300 8000 2 0 HT 2 HT 2 11 51 5300 8000 2 HT 2 HT 3 11 52 5300 8000 2 HT2 HT 3 I appreciate the depth of any of your help / suggestions I thank you in advance   

You want to read three input lines and write them as a line. Awk has a function, getline , making it easy:

  $ awk '{a = $ 0; get line; B = $ 0; get line; Print A, B, $ 0} 'datasets 11 48 5300 8000 1 0 HT 2 HT 2 11 49 5300 8000 1 HT 2 HT 2 11 50 5300 8000 2 HT 2 HT 2 11 51 5300 8000 2 HT 2 HT 3 11 52 5300 8000 2 HT 2 HT 3   

to each awk command instead:

  • a = $ 0; Save the value of the first line in

    variable one .

  • meet;

    Read in the second row.

  • b = $ 0;

    variable b .

  • Meet;

    Read in the third line.

  • Print a, b, $ 0

    Print all three rows.

Comments

Popular posts from this blog

ios - Adding an SKSpriteNode to SKScene from a child SKSpriteNode -

Matlab transpose a table vector -

c# - Textbox not clickable but editable -