How to read a txt file containing letters and number

I'm trying to read a txt file for class, but I have no idea how to eliminate the text in the file, so I can reach the data. The file contain a header and some lists with dates and data in sepperate colums.

Answers (1)

Hi!
You can read in with textscan as strings and convert afterwards:
% read file
fid = fopen('plante1_no_head.txt');
FC = textscan(fid, '%s%s%s%s');
fclose(fid);
% first column is date as string
% second column is time as string
% third column as double
A = FC{3};
% replace ',' with '.'
A = regexprep(A, ',', '.');
% convert to numeric
A = str2num(char(A));
% fourth column as double
B = FC{4};
% replace ',' with '.'
B = regexprep(B, ',', '.');
% convert to numeric
B = str2num(char(B));

Categories

Asked:

on 19 Nov 2013

Answered:

on 19 Nov 2013

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!