Data reading into MATLAB

Job ID: 34976918

Budget: $250 – $750 AUD

Have files containing considerable ancillary information, then a matrix with mixed character.text and numerical columns

Need to find and extract key numerical values into a structure.

After my code replaces these numerical values, write out a file with replaced numerical data

In attached example. do not need Lines 1 to 4 (except to write out a copy after data replaced
Line 5 is headings (not aligned with data alas)
If numerical (e.g. STN) want TEMDATA(k).STN = values, k being row number in the matrix with 1 the first data row (row 6 in the TEM file)
If text, want TEMDATA(k).COMP to be text, i.e. "X", "Y", or "Z";
If mixed (e,g, NORTH) want TEMDATA(k),NORTH = the text
Want CH1 to CH34 to be a matrix TEMD(nrowsofdata, 34) in dimension
last column MISC can be saved in TEMDATA(k).MISC for writing out. However, need to check that all entries the same and flag if any are different,

Files to process will be a lot bigger.
Output file to be named Example.TIP
Related categories: Data Entry Excel Matlab and Mathematica Algorithm