I am trying to convert my data set into a chart.

I have my data and the script I plan to run it through but I need to translate the data from a TXT file to a spreadsheet in MATLAB. I can't figure out how.

Answer 1

[Star Strider]

I am not clear on the reason for turning a text file into a spreadsheet, however readtable and writetable would be the funcitons I would use to first read it and then to write it as a spreadsheet file. Those will be certain to retain any column header information that might be in the text file. If there is no column header information, the readmatrix and writematrix functions would also work.

[Marshall Harkrider]

So here is my script and I am essentially trying to transfer a txt file to be able to go into this script and replace the Data1 which is filler data for my txt file.

clear; close all; clc

%% Script: Data
Data1 = linspace(0,10,500);
red_line = sin(2*pi*Data1)*1.5;
a = 1; % initialize counter
for i = 1:length(Data1)
    if red_line(i) >= 0.95 && red_line(i-1) <=0.95
        holdval(i) = 1;
        holdThing(a) = i;
        a = a + 1;
    else         
        holdval(i) = 0;
   
    end
end
 a = 1;
for i = 1:length(Data1)
    if red_line(i) >= 0.95 && red_line(i+1) <=0.95
          downindex(i) = 1;
          holdThing2(a) = i;
        a = a + 1;
    else    
        downindex(i) = 0;
    end
end
tt = linspace(0,10,500);
onePoints = find(downindex==1);



   

[Walter Roberson]

okay but what is the format of the txt file?

[Marshall Harkrider]

Its basically a spreadsheet of numbers from excel that has 58 columns and 8000 rows.

[Star Strider]

I do not see how the data are created and saved to a matrix or printed to an intermediate text file from the posted code.

[Image Analyst]

@Marshall Harkrider, attach the text file, but only after you read this link:

TUTORIAL: How to ask a question (on Answers) and get a fast answer