MATLAB: CSV read

csv

Hi,

I've tried to use the import data function for reading numeric data and text from the same CSV file. Each line of the header (first 10 lines) starts with a semicolon. The numeric data starts in row 11. That is represented in 4 columns. Sometimes there is an error message between the data rows starting with a semicolon. When I use the importdata function the data reading stops at the first error message line, though it is followed by useful data. Can anyone suggest me a way for reading in the whole file and accepting lines starting with semicolons?

THanks!

Best Answer

textscan() with Headerlines set to 10, and with CommentStyle set to ';'

Related Solutions

MATLAB: Create a function to extract data several csv files

Thank you so much for your answers!

I will upload a file so you can see.

What I need is to take the data from different columns and rows to work with them after. Example. Take C21:J532, C556:H1067, C1089:H1600

After I will need to work on that matrix.

MATLAB: How to add blank spaces in a text file

inFID  = fopen(inFileName, 'r');
outFID = fopen(outFileName, 'w');
if inFID == -1 || outFID == -1
  error('Failed at opening the files.');
end
key = '***invalid***';
b   = blanks(10);
while ~feof(inFID)
  s = fgets(inFID);
  if strncmp(s, key, 10)
    fwrite(outFID, [b, s(11:end)], 'char');
  else
    fwrite(outFID, s, 'char');
    if length(s) >= 10  % If there are really blank lines in the file
      key = s(1:10);
    end
  end
end

Best Answer

Related Solutions

MATLAB: Create a function to extract data several csv files

MATLAB: How to add blank spaces in a text file

Related Question