I want to extract the values of csv file. The csv files contains repeated headers. Example:
\nScan Parameters\nScan Type,Standard ScanID,700Stylus,Radius: 12.5 ยตmLength,600.0 umDuration,30 secResolution,0.067 um/sampleForce,1.00 mgMeasurement Range,524 umProfile,Hills\n \nScan Data\nHorizontal Distance,Raw Data,um,A,0.0,0.0,,0.1,15.8,,0.1,15.8,,0.2,6.8,,0.3,0.5,,.......................................599.8,23.9,,599.9,30.4,,599.9,30.2,\nScan Parameters <------- this is the first line of the 2nd set of headerlines
There is a repeated set of headlines in the data file. The first of headlines is 18. Then there is a newline and then follows another set of repeated headlines. I would like to remove all this headers and extract only the values.
For only one set of headerlines I do this and I extract all the values. after the headerlines. I haven't managed to do it with multiple headerlines.
textscan(fid(i), '%f %f','delimiter',',','HeaderLines',18,'MultipleDelimsAsOne',1)
Best Answer