How do I copy column datas from multiple .txt file to new file?
3 views (last 30 days)
Show older comments
I have 365 output data (.txt files) for one year. Output has a date in its name and each has a structure as follows:
#comment
#comment
#comment
#comment
#comment
#Time(UTC) nV
20140102T000000 006.36
20140102T000030 006.39
20140102T000100 006.43
20140102T000130 006.46
20140102T000200 006.49
20140102T000230 006.53
20140102T000300 006.56
20140102T000330 006.59
20140102T000400 006.60
20140102T000430 006.63
20140102T000500 006.67
.
.
.
.
I attached an example file. It is a data of 2nd Jan, 2014.
What I want to do is to copy value of nV with the date from all files to new one combined result file.
For one file I tried readtable function to plot for one day. However, I faces problems to plot for one year data.
0 Comments
Accepted Answer
KSSV
on 13 Oct 2021
You can read your text file using the below code snippet.
filename = 'ab20140102.txt' ;
fid = fopen(filename,'r');
data = textscan(fid,'%s%f','HeaderLines',6);
fclose(fid);
c2 = data{2} ; % second column
To read all the text files and save them use:
files = dir('*.txt') ;
N = length(files); % total number of files
data = cell(N,1) ; % store data into cell
% loop for each file
for i = 1:N
thisfile = files(i).name ;
fid = fopen(thisfile,'r');
thisdata = textscan(fid,'%s%f','HeaderLines',6);
fclose(fid);
data{i} = thisdata{2} ; % second column
end
After you can convert them into a matrix if each cell has same data using cell2mat. Read about it.
3 Comments
More Answers (0)
See Also
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!