Merge 864 single column text files and 60,000 rows in single file. How to get a matrix with 60000 rows and 864 column

I have 864 single column text files with 60,000 row in single text file.i would like to get a matrix with 60000 rows and 864 columns. Please help me

[dpb]

Is there a header line or anything, or just a list of numbers?

What's the naming convention and is there to be a specified order?

[shoaib saleem]

Just list of numbers like 4,444467 8,234566

[shoaib saleem]

Naming start C1 C2 C3 upto C864 text file name

Answer 1

[dpb]

It would be simpler if you had named the files so they would sort lexically as C001, C002, ... etc., but it's still not too bad...

N=864;    % the number files -- better/more general would be to use dir() and count number returned
L=60000;  % length of each -- better/more general would be to read first and determine its length
M(L,N)0;  % preallocate the output array to those sizes
for i=1:N
  fname=char("C"+i+.txt);
  M(:,i)=readmatrix(fname);
end

If the filenames were in proper normalized format, I'd be inclined to use the OS to copy and concatenate all into one long file, then read and reshape the resulting long vector instead of the loop...

[shoaib saleem]

File names are ref-cim-sabl-25°C-CPJ35-C1.txt ref-cim-sabl-25°C-CPJ35-C2.txt ref-cim-sabl-25°C-CPJ35-C3.txt . . ref-cim-sabl-25°C-CPJ35-C864.txt

[shoaib saleem]

All files are similar like this

[dpb]

You may have to use

M=readmatrix(fname,'Delimiter',{'\t'},'DecimalSeparator',',');

to force MATLAB to deal with the non-US use of "," as the decimal indicator. In US w/ default system settings, simply changing the 'DecimalSeparator' parameter alone wasn't enough; the default 'Delimiter' also including a comma as typical field delimiter overrode the separator use so had to get it out of the list of delimiters to not interpret the file as containing two variables, not just one.

Fix the string to generate the need filename by matching the constant portion of the file as needed.

[shoaib saleem]

Ok kindly update fname in for loop according to txt file name

[dpb]

You can type as easily as I ... you've got to put at least SOME effort into solving your own problems rather than relying on being spoon-fed.