Re^4: Spliting Table

As I understand it the input file has hundred of columns like this (transposed)

Columns               Row 1       Row 2        ... etc for 1000s rows
Index                       1           2
TargetID            g00000029  cg00000108
ProbeID_A            14782418    12709357
ProbeID_B            14782418    12709357
VP1.AVG_Beta        0,7469755   0,9218118
VP1.Intensity            2793        3609
VP1.Avg_NBEADS_A           15          12
VP1.Avg_NBEADS_B           15          12
VP1.BEAD_STDERR_A   3,382,405   4,474,464 
VP1.BEAD_STDERR_B   7,203,749   1,550,186 
VP1.Signal_A              632         190
VP1.Signal_B             2161        3419
VP1.Detection Pval       0,00        0,00
VP2.AVG_Beta        0,6678689   0,9602971
VP2.Intensity            2950        7305  
VP2.Avg_NBEADS_A           18          11
VP2.Avg_NBEADS_B           18          11
VP2.BEAD_STDERR_A   9,640,222   3,527,683 
VP2.BEAD_STDERR_B   1,268,078   1,308,559 
VP2.Signal_A              913         194 
VP2.Signal_B             2037        7111 
VP2.Detection Pval       0,00        0,00  
..
..
repeated for hundreds of VPs
[download]

and the OP wants to create 100's of individual files like this (but transposed)

File VP1.txt
------------
Index                       1           2  ... etc for 1000s rows
TargetID            g00000029  cg00000108
ProbeID_A            14782418    12709357
ProbeID_B            14782418    12709357
VP1.AVG_Beta        0,7469755   0,9218118
VP1.Intensity            2793        3609
VP1.Avg_NBEADS_A           15          12
VP1.Avg_NBEADS_B           15          12
VP1.BEAD_STDERR_A   3,382,405   4,474,464 
VP1.BEAD_STDERR_B   7,203,749   1,550,186 
VP1.Signal_A              632         190
VP1.Signal_B             2161        3419
VP1.Detection Pval       0,00        0,00

File VP2.txt
------------
Index                       1           2  ... etc for 1000s rows
TargetID            g00000029  cg00000108
ProbeID_A            14782418    12709357
ProbeID_B            14782418    12709357
VP2.AVG_Beta        0,6678689   0,9602971
VP2.Intensity            2950        7305  
VP2.Avg_NBEADS_A           18          11
VP2.Avg_NBEADS_B           18          11
VP2.BEAD_STDERR_A   9,640,222   3,527,683 
VP2.BEAD_STDERR_B   1,268,078   1,308,559 
VP2.Signal_A              913         194 
VP2.Signal_B             2037        7111 
VP2.Detection Pval       0,00        0,00
[download]

poj

Comment on Re^4: Spliting Table Select or Download Code

Replies are listed 'Best First'.
Re^5: Spliting Table by Laurent_R (Canon) on Aug 20, 2015 at 15:59 UTC
As I understand it the input file has hundred of columns like this (transposed) Maybe, but that's not what I understood from this post Re^4: Spliting Table's description of the format, which seems to indicate that there are 22 fields for each line. Well, this is fairly unclear to me.	[reply]
Re^6: Spliting Table by poj (Abbot) on Aug 20, 2015 at 16:17 UTC
This node_Re^2: Spliting Table (a solution) describes more than 22 columns.	[reply]
Re^7: Spliting Table by Laurent_R (Canon) on Aug 20, 2015 at 17:17 UTC
Yes, you're probably right, I had missed that post or forgotten about it.	[reply]