Divide a column of a datafile through a constant value

1 次查看（过去 30 天）
Shivu
Shivu 2022-5-23
评论： Shivu 2022-5-23
I have a large number of datafiles (.txt file) and I need to divide one of the columns to a constant number. What is the short way to do it.
  3 个评论
显示 1更早的评论
Shivu
Shivu 2022-5-23
a = textread('den_T50.txt');
a1 = a(:,1)/0.15;
save ('den_T50.txt','-ascii')
type('Nden_T50.txt')
I have tried this way for a single file. Is there can be any short method for saving a large number of files other than this?
And further, the problem is on saving the new data file (according to above code) it's just appending the modified data column into the previous data. Whereas I want to replace the previous column with the new calculated one.

请先登录，再进行评论。

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

回答（1 个）

KSSV
KSSV 2022-5-23
txtFiles = dir('*.txt') ; % you are in the folder of text files
N = length(txtFiles) ; % total files
% loop for each file
for i = 1:N
txtFile = txtFiles(i).name ;
T = readtable(txtFile) ; % also have a look on load, importdata
T.(1) = T.(1)/100 ; % divide first column by 100
end

类别

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

标签

Community Treasure Hunt

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

Start Hunting!

Translated by