Hi,

How do I transpose a huge space delimited file with more than 2 million columns and about 100 rows? Thanks!

Transpose into what? Vice versa?

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

Some more information on the file would be nice, too. Do the columns have a maximum width? Or better yet, a fixed width?

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 ----------

hahahaha . I have tried tranposing in RGui but it seemed to take forever!

Does the first column have a fixed width?

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?