how to add new column in existing text file?
8 vues (au cours des 30 derniers jours)
Afficher commentaires plus anciens
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
2 commentaires
Rik
le 20 Jan 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.
Réponse acceptée
Bhaskar R
le 20 Jan 2020
Modifié(e) : Bhaskar R
le 20 Jan 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 commentaires
Walter Roberson
le 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}
Plus de réponses (0)
Voir également
Catégories
En savoir plus sur Text Files dans Help Center et File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!