MATLAB: How to extract data from an text file

exceltext file

I have two files, one in excel and one in a text file, how would i obtain column data from the text file even though i did it from an excel file.

code is:

filename = 'mct.xlsx'
data = xlsread(filename, 'mct', 'A:D');
Phase1 = data(data(:4)==1,:);

how would i be able to extract this from a text file?

Best Answer

Hello, there are a number of ways to go about this. Please refer to the following links:

https://mathworks.com/help/matlab/ref/fscanf.html

https://mathworks.com/help/matlab/ref/importdata.html

Related Solutions

MATLAB: Issue with data format when using textscan()

The format should be all lower case for duration.

%{hh:mm:ss}T

However, the data appears to be delimited as semicolon. You'd have more luck with readtable:

opts = detectImportOptions('D:\SI010118.txt')
opts = setvartype(opts,1,'datetime')
opts = setvaropts(opts,1,'InputFormat','dd.MM.uuuu HH:mm:ss')
readtable('D:\SI010118.txt',opts)

MATLAB: Text file has headers that are 2X4 and are repeated randomly within the data.

str = fileread('MCT_Data.txt');
nums = cellfun(@str2double, regexp(str, '([\d.,]+)', 'match'));
x = reshape(nums, 4, [])'

x =
      689427           0           0           0
      689527           0           0           0
      689627           0           0           0
      689727           0           0           0
      689827           0           0           0
      689927           0           0           0
      690027           0           0           0
      690127           0           0           0
      690227           0           0           0

Best Answer

Related Solutions

MATLAB: Issue with data format when using textscan()

MATLAB: Text file has headers that are 2X4 and are repeated randomly within the data.

Related Question