Readtable to put text into columns from .CSV file

7 次查看（过去 30 天）
Kacey Lange
Kacey Lange 2022-7-8
评论： Kacey Lange 2022-7-11
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 个评论
显示 1更早的评论
Kacey Lange
Kacey Lange 2022-7-11
The .CSV file is what I am starting with and the .txt file is what I got

请先登录，再进行评论。

请先登录，再回答此问题。

采纳的回答

Debadipto
Debadipto 2022-7-11
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 个评论
显示 5更早的评论
Debadipto
Debadipto 2022-7-11
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.

请先登录，再进行评论。

更多回答（1 个）

dpb
dpb 2022-7-11
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., ...

类别

在 Help Center 和 File Exchange 中查找有关 Text Files 的更多信息

标签

Community Treasure Hunt

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

Start Hunting!

Translated by