Effacer les filtres
Effacer les filtres

Readtable to put text into columns from .CSV file

11 vues (au cours des 30 derniers jours)
Kacey Lange
Kacey Lange le 8 Juil 2022
Commenté : Kacey Lange le 11 Juil 2022
I have 180 .CSV files that I am wanting to export into .txt files. all my data is in one column, seperated by a comma and I want to put them in three different columsn in the text file. With the code below, I am able to make a text file, but each line is seperated by a ' " ', which is messing up loading the text file. How do I edit the readtable for it to read the table correctly in the text file?
To make the files .txt files I used:
%% CDOM
clear all
s = dir('*.CSV');
names = {s.name};
for n = 1:numel(names)
Data = readtable(names{n},'Delimiter', ',','Format', '%s%s%s');
[fullpath,filename,ext]=fileparts(names{n});
filename=strrep(filename,'-','.');
k=strfind(filename,'-');
if ~isempty(k)
filename = extractBefore(filename,'-');
end
writetable(Data,[filename '.txt']);
end
% [file,path] = uigetfile('DOM*.xlsx','Select File to Plot','MultiSelect','on');
% fbfile = fullfile(path,file);
  3 commentaires
Kacey Lange
Kacey Lange le 11 Juil 2022
The .CSV file is what I am starting with and the .txt file is what I got
Kacey Lange
Kacey Lange le 11 Juil 2022
This is what I want it to look like

Connectez-vous pour commenter.

Réponse acceptée

Debadipto
Debadipto le 11 Juil 2022
As per my understanding, you have a code snippet that converts contents in a .csv file into a .txt file. Since the .csv files have both ',' and '"' as two conflicting delimiters, you're not able to produce the desired output. To get the desired .txt output, just remove the optional arguments from the readtable method.
Data = readtable(names{n});
Hope this helps.
  7 commentaires
Debadipto
Debadipto le 11 Juil 2022
The .csv file is present in UTF-16LE format, which is not supported by MATLAB 2019a apparently. So you'll have to type cast the data to UTF-8.
clear all
s = dir('DOM01-1.CSV');
names = {s.name};
for n = 1:numel(names)
fid = fopen(names{n}, 'rt', 'n', 'UTF16LE');
fread(fid, 2, '*uint8');
inputdata= fread(fid, [1 inf], '*char');
[fullpath,filename,ext]=fileparts(names{n});
filename=strrep(filename,'-','.');
k=strfind(filename,'-');
if ~isempty(k)
filename = extractBefore(filename,'-');
end
outputfile = fopen([filename '.txt'],'w');
fprintf(outputfile, inputdata);
fclose(outputfile);
end
Refer to this answer to know more.
Kacey Lange
Kacey Lange le 11 Juil 2022
Yes this worked! Thank you so much!

Connectez-vous pour commenter.

Plus de réponses (1)

dpb
dpb le 11 Juil 2022
Not at all clear why you would want a quoted string where the quotes are over the whole line instead of fields, but that's a fairly simple exercise -- although would be trivial if you were with R2020b which introduced readlines -- with R2019a, you've got just a little more work --
data=fileread('DOM01-1.CSV');
data=strrep(data,char([13 10]),';');
data=split(string(data),';');
writematrix(data,'test.txt','filetype','text','QuoteStrings',1)
You've got to strip the newline character pair to avoid putting them explicitly in the data instead of being part of the file structure using fileread -- it returns the entire content of the file.
Later, the readlines function returns a string array directly; you could also read the file and echo records with fgetl, but that's also a little more coding effort to open/close the file handles, write the explicit loop, etc., ...

Community Treasure Hunt

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

Start Hunting!

Translated by