I have files in a directory, the directory location is saved to a variable called hardCodeFilePath
Within the directory hardCodeFilePath, there are five CSV files.
Each CSV is a single column of numerials WITH A STRING HEADER, which drives me mad as it creates a mixed data type.
Due to this mixed data type I can't just save them to numerical arrays and fiddle with them that way. (Blast!)
I saw a neat solution for joining multiple columns frOm mixed data type CSV files into a single mega-column but I am too much an idiot to make this join them horizontally in five columns instead of one vertical mega-column.
Here is that solution:
function ccsm()
sad = dir( 'x*.csv' );
fid_out = fopen( 'concatenated_files.csv', 'w' );
for jj = 1 : length( sad )
fid_in = fopen( sad(jj).name, 'r' );
str = transpose( fread( fid_in, '*char' ) );
fclose( fid_in );
if not( jj == 1 )
ix1 = regexp( str, '[\r\n]++', 'once' );
str = str(ix1:end);
end
ix2 = regexp( str, '[\r\n]++$', 'once' );
if not( isempty( ix2 ) )
str(ix2:end) = [];
end
fwrite( fid_out, str, '*char' );
end
fclose('all');
end
