Readtable to put text into columns from .CSV file

조회 수: 13 (최근 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
Kacey Lange
Kacey Lange 2022년 7월 11일
The .CSV file is what I am starting with and the .txt file is what I got
Kacey Lange
Kacey Lange 2022년 7월 11일
This is what I want it to look like

댓글을 달려면 로그인하십시오.

채택된 답변

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
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.
Kacey Lange
Kacey Lange 2022년 7월 11일
Yes this worked! Thank you so much!

댓글을 달려면 로그인하십시오.

추가 답변 (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 CenterFile Exchange에서 Text Files에 대해 자세히 알아보기

Community Treasure Hunt

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

Start Hunting!

Translated by