[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