File import

2011 7 23
2 个回答
回答已采纳
12 次查看（30 天）

0 个投票

Hallo,
I would like to import in Matlab a set of data, which originally is expressed in 4 columns: ex:
1490 3 2 0.
20094 1 2 0.
66779 4 2 0.
14293 3 2 0.
53990 1 2 0.
61190 4 2 0.
I want it to be imported as one column excluding the 4th columnm, and combining the 3 numbers for each row in one number like this:
1490*3*2
20094*1*2
66779*4*2
14293*3*2
53990*1*2
61190*4*2
How can I use the function textscan to do it? are there other ways to do it?
Thanks.
Sami

1 个评论
显示 -1更早的评论 隐藏 -1更早的评论

Sami
Sami 2011-7-23
the stars are only to recognize the values the actual result i want is :
149032
2009412
6677942
1429332
5399012
6119042

请先登录，再进行评论。

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

 采纳的回答

Fangjun Jiang
Fangjun Jiang 2011-7-23

0 个投票

Save your text in a file called 'test.txt'
a=importdata('test.txt');
a=a(:,1:3);
b=sprintf('%d%d%d\n',a')
c=str2num(b)

2 个评论
显示 无 隐藏 无

Sami
Sami 2011-7-24
but how do I assign the path? usually i do the text import like this ...
path = 'C:\Temp\';
file = 'test.txt';
head_lines = 19;
input_file= [path file_add];
fid = fopen(input_file,'r');
data_add = textscan(fid,'%f%f%f%f','Delimiter','\t','HeaderLines', head_lines);
fclose(fid);
Sami
Sami 2011-7-24
did it, thanks!

请先登录，再进行评论。

更多回答（1 个）

Oleg Komarov
Oleg Komarov 2011-7-23

0 个投票

fid = fopen('yourpath.txt');
out = textscan(fid,'%f%f%f%*f','CollectOutput',1);
out = sum(bsxfun(@times, out{1}, [100 10 1]),2);
fid = fclose(fid);

类别

在 帮助中心 和 File Exchange 中查找有关 Large Files and Big Data 的更多信息

产品

标签

Community Treasure Hunt

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

Start Hunting!

Translated by