The UNIX and Linux Forums  

Go Back   The UNIX and Linux Forums > Top Forums > Shell Programming and Scripting
file transposing file transposing
Google UNIX.COM
Forums Portal Register Forum Rules FAQContribute Members List Arcade Search Today's Posts Mark Forums Read


Shell Programming and Scripting Post questions about KSH, CSH, SH, BASH, PERL, PHP, SED, AWK and OTHER shell scripts here.

More UNIX and Linux Forum Topics You Might Find Helpful
Thread Thread Starter Forum Replies Last Post
More than transposing! bulash UNIX Desktop for Dummies Questions & Answers 3 04-11-2008 02:20 PM
Transposing string unibboy Shell Programming and Scripting 3 02-13-2008 03:12 PM
Major Awk problems (Searching, If statements, transposing etc.) Blivo Shell Programming and Scripting 2 09-05-2007 03:41 AM
Another transposing issue stevesmith Shell Programming and Scripting 14 09-16-2006 01:48 AM
transposing letters myscsa2004 Shell Programming and Scripting 4 05-12-2004 07:11 AM

Reply
Page 3 of 4 < 12 3 4 >
 
Submit Tools LinkBack Thread Tools Search this Thread Display Modes
  #15  
Old 08-04-2005
Registered User
  

Join Date: Jul 2005
Posts: 37
Thanks. The problem is somehow just a opposite of the original one. Basically, we need to transpose a row based file to a column based file, please see below. Since the Excel has a limitation of 256 columns, it is almost useless to those who want to transpose a big file.

file format(tab delimited):

chip1 a1 b1 c1 d1 ......
chip2 a2 b2 c2 d2 .............
chip3 a3 b3 c3 d3 .........
....

after transpose(tab delimited),
chip1 chip2 chip3 chip4 ...
a1 b1 c1 d1 ...
a2 b2 c2 d2 ...
a3 b3 c3 d3 ...
....
Reply With Quote
Forum Sponsor
  #16  
Old 08-04-2005
Registered User
  

Join Date: Jul 2005
Posts: 37
sorry, it's wrong.
after transpose,

chip1 chip2 chip3 ...
a1 a2 a3 ...
b1 b2 b3 ...
c1 c2 c3 ...
....
Reply With Quote
  #17  
Old 08-04-2005
vgersh99's Avatar
Moderator
  

Join Date: Feb 2005
Location: Boston, MA
Posts: 3,029
Quote:
Originally Posted by mskcc
sorry, it's wrong.
after transpose,

chip1 chip2 chip3 ...
a1 a2 a3 ...
b1 b2 b3 ...
c1 c2 c3 ...
....
how's that different from the original?
the output I get is:
Code:
chip1   chip2   chip3
a1      a2      a3
b1      b2      b3
c1      c2      c3
d1      d2      d3
Reply With Quote
  #18  
Old 08-04-2005
Registered User
  

Join Date: Jul 2005
Posts: 37
original was column to row, but now is row to column.
Reply With Quote
  #19  
Old 08-04-2005
vgersh99's Avatar
Moderator
  

Join Date: Feb 2005
Location: Boston, MA
Posts: 3,029
Quote:
Originally Posted by mskcc
original was column to row, but now is row to column.
have you tried running the script?
isn't the above output what you wanted?
Reply With Quote
  #20  
Old 08-04-2005
Registered User
  

Join Date: Jul 2005
Posts: 37
yes, original input was,
chip1 chip2 chip3 ...
a1 a2 a3 ...
b1 b2 b3 ...
c1 c2 c3 ...
...

output was,
chip1 a1 b1 c1 ...........
chip2 a2 b2 c2 ......
chip3 a3 b3 c3 ..............
...
Reply With Quote
  #21  
Old 08-04-2005
vgersh99's Avatar
Moderator
  

Join Date: Feb 2005
Location: Boston, MA
Posts: 3,029
ok, if you give it this input - what happens?
Code:
chip1 a1 b1 c1 d1
chip2 a2 b2 c2 d2
chip3 a3 b3 c3 d3
Reply With Quote
Google The UNIX and Linux Forums
Reply
Page 3 of 4 < 12 3 4 >

« Awk with variables | Breaking input with "read" command »
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes
Linear Mode Linear Mode




All times are GMT -7. The time now is 04:46 AM.

The UNIX and Linux Forums RSS Feeds - Contact Us - The UNIX and Linux Forums - Archive - Top

Powered by: vBulletin, Copyright ©2000 - 2006, Jelsoft Enterprises Limited.
The UNIX and Linux Forums Content Copyright ©1993-2008. All Rights Reserved.Ad Management by RedTyger Visit The Complex Event Processing Blog

Content Relevant URLs by vBSEO 3.2.0