Copying specific lines from multiple cvs file to a single file

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?

Answer 1

[Anmol Dhiman]

Hi Steliana,

You can use readtable to read data from csv and then use join to merge data from all the csv files.

Thanks