Transposing a huge space delimited file | Unix Linux Forums | UNIX for Dummies Questions & Answers

  Go Back    


UNIX for Dummies Questions & Answers If you're not sure where to post a UNIX or Linux question, post it here. All UNIX and Linux newbies welcome !!

Transposing a huge space delimited file

UNIX for Dummies Questions & Answers


Closed Thread    
 
Thread Tools Search this Thread Display Modes
    #1  
Old 01-31-2013
evelibertine evelibertine is offline
Registered User
 
Join Date: May 2011
Last Activity: 22 August 2014, 5:12 AM EDT
Posts: 193
Thanks: 94
Thanked 0 Times in 0 Posts
Transposing a huge space delimited file

Hi,

How do I transpose a huge space delimited file with more than 2 million columns and about 100 rows? Thanks!
Sponsored Links
    #2  
Old 01-31-2013
Corona688 Corona688 is offline Forum Staff  
Mead Rotor
 
Join Date: Aug 2005
Last Activity: 2 September 2014, 11:15 AM EDT
Location: Saskatchewan
Posts: 19,273
Thanks: 774
Thanked 3,237 Times in 3,035 Posts
Transpose into what? Vice versa?
The Following User Says Thank You to Corona688 For This Useful Post:
evelibertine (02-08-2013)
Sponsored Links
    #3  
Old 01-31-2013
bakunin bakunin is offline Forum Staff  
Bughunter Extraordinaire
 
Join Date: May 2005
Last Activity: 2 September 2014, 8:39 AM EDT
Location: In the leftmost byte of /dev/kmem
Posts: 4,210
Thanks: 44
Thanked 801 Times in 632 Posts
Quote:
Originally Posted by evelibertine View Post
How do I transpose a huge space delimited file with more than 2 million columns and about 100 rows?
The correct procedure involves candles, the sacrifice of rum, tobacco and a living chicken, then invoking the following ritual chant ....

Seriously: if we are supposed to help you with a problem you have to explain first which problem you have: what have you tried and in which way did it fail? Or are you just lonely and seeking conversation?

bakunin
The Following User Says Thank You to bakunin For This Useful Post:
evelibertine (02-08-2013)
    #4  
Old 01-31-2013
Corona688 Corona688 is offline Forum Staff  
Mead Rotor
 
Join Date: Aug 2005
Last Activity: 2 September 2014, 11:15 AM EDT
Location: Saskatchewan
Posts: 19,273
Thanks: 774
Thanked 3,237 Times in 3,035 Posts
Some more information on the file would be nice, too. Do the columns have a maximum width? Or better yet, a fixed width?
The Following User Says Thank You to Corona688 For This Useful Post:
evelibertine (02-08-2013)
Sponsored Links
    #5  
Old 02-01-2013
evelibertine evelibertine is offline
Registered User
 
Join Date: May 2011
Last Activity: 22 August 2014, 5:12 AM EDT
Posts: 193
Thanks: 94
Thanked 0 Times in 0 Posts
I'm sorry the question was vague. By transpose I mean flipping the rows into columns and the columns into rows. The file basically has 2,000,000 columns and 100 rows that all have digits ranging from 0 to 9, except the first row which has strings corresponding to column names. I hope this makes sense. Thanks a lot!

---------- Post updated at 01:58 PM ---------- Previous update was at 01:57 PM ----------

Quote:
Originally Posted by bakunin View Post
The correct procedure involves candles, the sacrifice of rum, tobacco and a living chicken, then invoking the following ritual chant ....

Seriously: if we are supposed to help you with a problem you have to explain first which problem you have: what have you tried and in which way did it fail? Or are you just lonely and seeking conversation?

bakunin
hahahaha . I have tried tranposing in RGui but it seemed to take forever!
Sponsored Links
    #6  
Old 02-01-2013
Corona688 Corona688 is offline Forum Staff  
Mead Rotor
 
Join Date: Aug 2005
Last Activity: 2 September 2014, 11:15 AM EDT
Location: Saskatchewan
Posts: 19,273
Thanks: 774
Thanked 3,237 Times in 3,035 Posts
Does the first column have a fixed width?
The Following User Says Thank You to Corona688 For This Useful Post:
evelibertine (02-08-2013)
Sponsored Links
    #7  
Old 02-02-2013
RudiC RudiC is offline Forum Advisor  
Registered User
 
Join Date: Jul 2012
Last Activity: 1 September 2014, 3:01 PM EDT
Location: Aachen, Germany
Posts: 4,159
Thanks: 69
Thanked 995 Times in 943 Posts
I'm not sure any tool will handle lines at least 4 million chars long (one char cols assumed). Where do these loooong lines come from? A database? Can't they be created in a different way from the start?
The Following User Says Thank You to RudiC For This Useful Post:
evelibertine (02-08-2013)
Sponsored Links
Closed Thread

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

More UNIX and Linux Forum Topics You Might Find Helpful
Thread Thread Starter Forum Replies Last Post
Changing only the first space to a tab in a space delimited text file evelibertine UNIX for Dummies Questions & Answers 3 01-24-2013 12:18 AM
Swap two rows in a space delimited text file? evelibertine UNIX for Dummies Questions & Answers 4 11-05-2012 06:09 AM
How to convert a space delimited file into a pipe delimited file using shellscript? nithins007 Shell Programming and Scripting 7 09-25-2011 05:33 AM
Converting Space delimited file to Tab delimited file jeevs81 UNIX for Dummies Questions & Answers 16 02-26-2009 01:49 AM
Searching for text in a Space delimited File andyblaylock UNIX for Dummies Questions & Answers 6 11-27-2007 06:33 PM



All times are GMT -4. The time now is 12:41 PM.