MATLAB: Read numeric data as string data from csv (table.txt) file

conversioncsvnumericreadtablestringtables

Hi, matlab community.

I have a CSV file like:: 01,adam 02,eve 03,jenson

Now when I try to read this csv file (stored locally as table.txt) using readtable() it reads with imperfections. It stores all data correctly into 2-D array but "01" is stored as "1".

Is there any way to fix it? I want it exactly as it is in the file, i.e, as "01". Or, any way to convert numeric data to string data before it is stored in matlab variable.

Best Answer

You may use the %s specifier to read your data as strings.

 data = readtable('Table.txt','Format','%s%s');

Related Solutions

MATLAB: Import txt file containing some comment character = “#”

Mention:

    ....'CommentStyle','#')
fileID = fopen(filename);   %an example 
C = textscan(fileID,formatspec','Delimiter',',','CommentStyle','#');
fclose(fileID);

MATLAB: Loop to read files

To read all csv files one by one

files = dir('*.csv');
table_data = cell(1, numel(files));
for i=1:numel(files)
    filename = files(i).name;
    table_data{i} = readtable(filename);
end

To only read these specific files

range = 2010:1:2020;
table_data = cell(1, numel(range));
for i = 1:numel(range)
    filename = sprintf('data_%d.csv', range(i));
    table_data{i} = readtable(filename);
end

Best Answer

Related Solutions

MATLAB: Import txt file containing some comment character = “#”

MATLAB: Loop to read files

Related Question