Sorting the Data

Shell Programming and Scripting
1

My actual data looks like below

i have given only format. i can't give exact data format of my requirement due to some reasons. I this set of data lines about 5000

I need to come up with information in below

exact format of my data set :
Line<space>Number1<space>"somedata":
LineNumber2:"somedata"
LineNumber3:"somedata"
LineNumber4:"somedata"

------------------------------------

ab cd "somedata1":
efgh:"somedata2"
ijkl:"somedata3"
monp:"somedata4"

ab cd "somedata5":
efgh:"somedata6"
ijkl:"somedata7"
monp:"somedata"
i need to get the ouput as

  abcd   efgh   ijkl   monop

somedata1 somedata2 somedata3 somedata4
somedata5 somedata6 somedata7 somedata8

I would happy if you i get some script which can give this info.

from my file i will need to get the 4000 lines of data.

Thanks in advance.

2

Several people took their time to answer you question in Sort a the file & refine data column & row format.

You don't say "thank you" them nor "sorry I gave you wrong information". You just made the new topic with the corrected question. Maybe you are wrong again? Who knows... Learn perl or awk or hire a programmer.
Though maybe there are more kind people here than I am.

PS Yes, they are. :slight_smile:

1 Like