non-rectangular text file upload

leo
2012 1 25
2 个回答
回答已采纳
4 次查看（30 天）

1 个投票

Hi,
I have a text file in the following form:
var1, val
var2, val
var3, val, val, val
var4, val, val
var6, val
so each line represent a variable that can be either a float or a vector of float. I would like to import this data in matlab where I would have a variable named var1 that would contain the values given in the text file, and so forth.
I have looked at various documentations but i cannot find something that work for my case: there should be a same number of column and I cannot figure out how to have that variable name in my matlab code.
Thanks for your help/suggestions! Leo

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

 采纳的回答

Andrew Newell
Andrew Newell 2012-1-25

1 个投票

This will do it:
fid = fopen('data.csv');
tline = fgetl(fid);
while ischar(tline)
ind = find(tline==',',1,'first');
eval([tline(1:ind-1) '= [' tline(ind+1:end),']']);
tline = fgetl(fid);
end
fclose(fid)
If you don't want to see the output, you can replace the eval line by
S = evalc([tline(1:ind-1) '= [' tline(ind+1:end),']']);
EDIT: If you wish to follow Walter's advice and put all your variables in a structure, you could do the following:
fid = fopen('data.csv');
S = struct;
tline = fgetl(fid);
while ischar(tline)
ind = find(tline==',',1,'first');
S.(tline(1:ind-1)) = str2num(tline(ind+1:end));
tline = fgetl(fid);
end
fclose(fid);

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

Walter Roberson
Walter Roberson 2012-1-25
No eval! No eval! Use dynamic structure fields!
http://matlab.wikia.com/wiki/FAQ#How_can_I_create_variables_A1.2C_A2.2C....2CA10_in_a_loop.3F

请先登录，再进行评论。

更多回答（1 个）

leo
leo 2012-1-26

1 个投票

Thanks for your help!
I changed it a bit as my file is slightly different, e.g.:
var1 3.2 3.3
var2 string1 string2
var3 124
so here is what i wrote:
fid = fopen('test.txt');
s = struct;
tline = fgetl(fid);
while ischar(tline)
arr = regexp(tline,'\t+','split'); % split line with delimiter tab and consecutive as one
ind = length(char(arr(1)));
if ind > 0 % check for empty lines
var_name = tline(1:ind);
val = arr(2:end);
if not (isempty(str2num(val{1}))) % check if data is numeric
val = cellfun(@str2num, val); % if numeric convert to double
s.(var_name) = val;
else
s.(var_name) = val; % for string variables keep cell array
end
end
tline = fgetl(fid);
end
fclose(fid);
what do you think? clean?

类别

在 帮助中心 和 File Exchange 中查找有关 Variables 的更多信息

标签

Community Treasure Hunt

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

Start Hunting!

Translated by