[R] Reading multiple tables from one .txt doc

Mark Fingerle mark.fingerle at brainlab.com
Tue May 3 16:45:29 CEST 2016


Dear all,
I have a .txt file which contains multiple tables and I would like to read these tables separately in order to create graphs for each one.
The tables are separated by a blank line, have a variable number of lines, fixed nr. Of rows, have a header and a comment above the header (#) which contains a specific word that identifies each table. (see example below). It would be possible to change the layout of the .txt data a bit (Add a word, remove comment etc..)
I would be extremely grateful if anyone could help me with this daunting task :-)
Example:
# CoordA
Image    X             Y             Z             MeasuredMove MachineMove
vf_36.png            -114.345475       -89.043448         556.073402         0             0
vf_37.png            -111.118715       -89.978534         606.040764         50.080172           50.000000
vf_38.png            -107.911209       -90.901958         656.025557         50.096111           50.000000
vf_39.png            -104.693931       -91.814392         705.982620         50.068868           50.000000
vf_40.png            -101.459549       -92.730113         755.983835         50.114082           50.000000

# CoordB
Image    X             Y             Z             MeasuredMove MachineMove
vf_36.png            -115.345475       -89.043448         556.073402         0             0
vf_37.png            -115.118715       -89.978534         606.040764         50.080172           50.000000
vf_38.png            -134.911209       -90.901958         656.025557         50.096111           50.000000
vf_39.png            -164.693931       -91.814392         705.982620         50.068868           50.000000
vf_40.png            -134.459549       -92.730113         755.983835         50.114082           50.000000

# CoordC
Image    X             Y             Z             MeasuredMove MachineMove
vf_36.png            -168.345475       -89.043448         556.073402         0             0
vf_37.png            -115.118715       -89.978534         606.040764         50.080172           50.000000
vf_38.png            -146.911209       -90.901958         656.025557         50.096111           50.000000
vf_39.png            -187.693931       -91.814392         705.982620         50.068868           50.000000
vf_40.png            -185.459549       -92.730113         755.983835         50.114082           50.000000

	[[alternative HTML version deleted]]



More information about the R-help mailing list