how to add new column in existing text file?
8 visualizzazioni (ultimi 30 giorni)
Mostra commenti meno recenti
I want to add new column in text files as their file names. I have 12000 files and i want to update them with their numbers. kindly help me to write a code for them. The desired text files should be as shown
![ss.jpg](https://www.mathworks.com/matlabcentral/answers/uploaded_files/262595/ss.jpeg)
2 Commenti
Rik
il 20 Gen 2020
Ah, so you did post it as a separate question. Same question here: what have you tried so far? Try splitting a problem into solvable parts.
Risposta accettata
Bhaskar R
il 20 Gen 2020
Modificato: Bhaskar R
il 20 Gen 2020
for ii = 1:12000
filename = [num2str(ii), '.txt']; % your file names as 1, 2.. .txt
mat = readmatrix(filename); % get file data
mat = [repmat(ii, size(mat, 1), 1), mat]; % append filename value to data
writematrix(mat, filename, 'Delimiter',' '); % write file with name
end
Hope this works for you !!
7 Commenti
Walter Roberson
il 9 Nov 2023
filename = 'temp_summary.05.08_2011.txt';
%more general form
[~, basename] = fileparts(filename);
nameparts = regexp(basename, '\.', 'split');
dateparts = regexp(nameparts{end}, '_', 'split');
year_str = dateparts{end}
%special case where the year is the last thing after _
[~, basename] = fileparts(filename);
dateparts = regexp(basename, '_', 'split');
year_str = dateparts{end}
Più risposte (0)
Vedere anche
Categorie
Scopri di più su Text Files in Help Center e File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!