Skip to main content

Thread: Linux text manipulation: sort columns according to the first row

-

let's have 50,000 rows of data looks following:


b d c z e f ......
3 1 4 1 9 2 3 ......
...... ......
0 1 3 4 2 4 8 ......


, want sort columns of data according first row, such output looks like:

b c d e f ...... z
1 3 1 4 2 3 ...... 9
...... ......
1 0 4 3 4 8 ...... 2



how do that?


tried transpose columns rows using "awk," , use "sort" command, , transpose use "awk."

awk doesn't work if number of columns exceed ~33k, happens when rows first transposed columns, i.e., transposing didn't work me.


idea how this?

in advance.

is pasting openoffice version of spreadsheet , using sort function there, pasting file not option? if have lot of them, can use openoffice spreadsheet thingy automate process.


Forum The Ubuntu Forum Community Ubuntu Official Flavours Support General Help [all variants] Linux text manipulation: sort columns according to the first row


Ubuntu

Comments

Post a Comment

Popular posts from this blog

How to change text Component easybook reloaded *newbee* - Joomla! Forum - community, help and support

-
Image
hi all, i started building websites joomla not long ago, can use help.. for got problem guestbook. i have installed easybook. , running on following website http://odoorn321.nl/ (under gastenboek) i want change text: waardering website (is dutch valuate website) waardering. idea rid of word website, because have valuate vacation home, not website. i have made screenshot of text want change. where , how going find css file change text? your appreciated! thanks no one? Board index Joomla! Older Version Support Joomla! 2.5 General Questions/New to Joomla! 2.5
Read more

PProHeadless.exe has stopped working error when opening projects in Adobe Media Encoder CS6

-
hi, upgraded adobe cloud cs6 , having problems adobe media encoder cs 6 (version 6.0.1.31 64-bit).   when try add adobe premiere projects in ame, gives me following error:   pproheadless.exe has stopped working   i tried rebooting, , still gives me same error.  project load, won't.   the premiere projects contain h.264 .mov file coming canon t2i.  added overlay logo bottom right of video created in adobe after effects, contains text, no effects, no motion, etc.  have .wav file recorded zoom h4n, not always.  edit in adobe audition remove noise feature.   i running on windows 7 ultimate 64-bit.  i'm using i7 16gb ram , ati 6870 video card.   i have lut buddy plugin installed.   it give me error first time try load project, , connection dynamic link server fail.  afterwards, if try load project again, if restart ame, stays stuck in connecting dynamic link server...   any provide appreciated. what happens when drag , a...
Read more

Preconditions Failed. - Joomla! Forum - community, help and support

-
hello! i'm having problem; every time click save&close button, or save button, or close button module; following message appears: "precondition failed the precondition on request url /administrator/index.php evaluated false. additionally, 404 not found error encountered while trying use errordocument handle request." it happens modules. thanks in advance. problem description :: forum post assistant (v1.2.3) : 13th november 2012 wrote: can\'t save changes or close module. log/error message :: forum post assistant (v1.2.3) : 13th november 2012 wrote: precondition failed precondition on request url /administrator/index.php evaluated false. additionally, 404 not found error encountered while trying use errordocument handle request. last php error(s) reported :: forum post assistant (v1.2.3) : 13th november 2012 wrote: [04-mar-2012 01:25:56] php fatal error: call member function get() on non-object in /home/joommmy1/addon/youngstaer/sub/teenace/public_html/templates/...
Read more