I want to read column 19 of the table (surface elevation) into MATLAB but I get a table with characters rather than numbers when I write this:
tidedata1 = readtable('Newhaven_19820101_19871231.csv');
When I check tidetdata1(:,19), it has character showing as '-99.000',
How do you get rid of the 3 commas and convert the column to numbers so that I can use it for calculations? I'd highly appreciate an example using my file (for this column if possible).