Copying specific lines from multiple cvs file to a single file

1 次查看(过去 30 天)
Hello,
I have this code:
%% Merge multiple cvs files into one file - open current folder, select files to merge
[filenames,folder]=uigetfile('*.csv','select the data file','multiselect','on')
%% creates output file name in the same folder
output= fullfile(folder,'trialcsvmerge.csv');
%%opens output file to write
fidOutput=fopen(output,'wt');
for k=1:3(filenames); %get this filename; enter number of files to merge
thisFileName=fullfile(folder,filenames{k});
fidInput=fopen(thisFileName); %open input files
thisText=fread(fidInput,'*char'); %%read text from file
fwrite(fidOutput, thisText); %copy to output file
fclose(fidInput); %close input file
end
The code works fine in combining multiple files into a single file, however it copies the titles and for whatever reason adds an extra empty line between all lines.. Is there a way to add a line that it just takes let say lines 2-10 from each file and copies just that, e.g. skipping the title?

回答(1 个)

Anmol Dhiman
Anmol Dhiman 2020-3-6
Hi Steliana,
You can use readtable to read data from csv and then use join to merge data from all the csv files.
Thanks

类别

Help CenterFile Exchange 中查找有关 File Operations 的更多信息

标签

产品

Community Treasure Hunt

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

Start Hunting!

Translated by