清空筛选条件
清空筛选条件

how to add new column in existing text file?

8 次查看（过去 30 天）
MS11
MS11 2020-1-20
编辑： Jonathon Klepatzki 2023-11-9
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
  2 个评论
Rik
Rik 2020-1-20
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.
MS11
MS11 2020-1-20
on the left is my input file and output file shown on the right. I add new column by using Excel but I have more than 12K files and I want to do the same with all of them with Matlab. can you write a code for this problem?

请先登录，再进行评论。

请先登录，再回答此问题。

采纳的回答

Bhaskar R
Bhaskar R 2020-1-20
编辑：Bhaskar R 2020-1-20
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 个评论
显示 5更早的评论
Walter Roberson
Walter Roberson 2023-11-9
Ran in:
@Jonathon Klepatzki
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}
year_str = '2011'
%special case where the year is the last thing after _
[~, basename] = fileparts(filename);
dateparts = regexp(basename, '_', 'split');
year_str = dateparts{end}
year_str = '2011'

请先登录，再进行评论。

更多回答（0 个）

类别

在 Help Center 和 File Exchange 中查找有关 Text Files 的更多信息

标签

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!

Translated by