MATLAB: Eliminate the var of the first line of .txt

.txt var

This is my code,I don't want to have the first line in .txt(var_1….)

%---------------------
z = '//';
a1 = 'SystemMode';
a2 = 'SimulationTime';
A = table({a1,1,z;a2,100,z});
% Write data to text file
writetable(A,'TEST.txt','Delimiter',' ') 
type 'TEST.txt'

How can I do

Best Answer

writetable(A,'TEST.txt','Delimiter',' ','writevariablenames',false)

Related Solutions

MATLAB: How to import data from attatched csv file

You could try using the Format name-value pair. You might need to read about it in textscan for the specifics of how it works. This allows you to specify the format of the delimited values in each row.

Space gets treated as a delimiter here. Since there is a space between the number and GHz, it can be read in independent of the number and actually be ignored. Since we don't have your csv, I can't test it for your data, but try somethign like this.

T=readtable('data.csv','HeaderLines',11,"Format",'%f%*s%f')

From the sample data you shared, this is the result I get.

T = 
    Var1     Var2 
    ____    ______
      1        200
    1.1        200
    1.2        200
    1.3        200
    1.4        200
    1.5        200
    1.6     199.99
    1.7     199.99
    1.8     199.99
    1.9     199.99
      2     199.99

MATLAB: Read table handling column of number values as column of strings

Hi Daniele

I have provided a function for you that seems to do the trick (attached and in code-block below).

Feel free to use it without any limitations - and please alter it as you wish (no rights reserved)

This may not be the most elegant solution but as it is based on textscan it should be fairly robust, customizable and reasonably fast.

Be aware that it is currently hard-coded that the delimiter is ',' as in your example (this can be changed in line 34 and 35 if desired - and maybe turned into an input if it changes often).

Error handling, testing and help is kept at a minimum.

function outputtable = csvfile2table(csvfile)
% CSVFILE2TABLE     Reads a CSV file as text into a MATLAB table using the first line as variable names
%                   Similar to readtable but keeps all data as text rather than converting numerical data
% 


% I/O
%           outputtable = csvfile2table(csvfile);
%       OR
%           outputtable = csvfile2table;
% 
% INPUT
%           csvfile     =   the full filename and path of the file to be read.
%

% OUTPUT
%           outputtable =   a table array containing the data from the CSV file as texts
% 
% 2020-04-16 XJHH@novonordisk.com
%
% see also readtable textscan
if nargin == 0 || isempty(csvfile)
    [filename,filepath] = uigetfile({'*.csv' 'CSV file (*.csv)'},'Select .CSV file to read into table');
    csvfile = fullfile(filepath,filename);
end
fid = fopen(csvfile);
if fid <= 0
    err = MException([mfilename,':MissingFile'],'File %s is not existing or cannot be read',csvfile);
    throw(err);
end
filecontent = textscan(fid,'%s','delimiter','\n');
fclose(fid);
tablecontent = cellfun(@(x)textscan(x,'%s','delimiter',','),filecontent{1}(2:end));
tableheaders = cellfun(@(x)textscan(x,'%s','delimiter',','),filecontent{1}(1));
outputtable = cell2table(strtrim(horzcat(tablecontent{:})'),'VariableNames',tableheaders{1});

Best Answer

Related Solutions

MATLAB: How to import data from attatched csv file

MATLAB: Read table handling column of number values as column of strings

Related Question