textscan syntax help converting file

Question

tybo1mos 2023-12-7

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/2057694-textscan-syntax-help-converting-file

评论： Star Strider 2023-12-12

I'm trying to read in a .txt file and convert the contents to an array. The text file is always formatted as follows (with additional items always on new lines):

Array = {

'Item1', 2526976, 8, 14, 11, [224,224,137,80];

'Item2', 2526976, 8, 18, 15, [224,224,137,80];

};

What is the sytax I use to use with textscan so that it loads into the workspace as follows:

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

Steven Lord 2023-12-7

If the file is formatted using MATLAB syntax, rather than trying to read it as data I'd consider renaming it to have the extension .m instead of the extension .txt. If you do that you could run it as a MATLAB script file.

请先登录，再进行评论。

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

Answer 1

Star Strider 2023-12-7

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/2057694-textscan-syntax-help-converting-file#answer_1367554

在 MATLAB Online 中打开

Try something like this —

Array = {'Item1', 2526976, 8, 14, 11, [224,224,137,80]
         'Item2', 2526976, 8, 18, 15, [224,224,137,80]};
fido = fopen('Test.txt','wt')
fido = 3
for k = 1:size(Array,1)
    fprintf(fido, '%s, %d, %d, %d, %d, [%d,%d,%d,%d]\n',Array{k,:});
end
fclose(fido);
type('Test.txt')
Item1, 2526976, 8, 14, 11, [224,224,137,80]
Item2, 2526976, 8, 18, 15, [224,224,137,80]
fidi = fopen('Test.txt','rt');
    C = textscan(fidi, '%s %d %d %d %d [%d %d %d %d]', 'Delimiter',{','}, 'CollectOutput',1)
C = 1×2 cell array
    {2×1 cell}    {2×8 int32}
fclose(fidi);
C
C = 1×2 cell array
    {2×1 cell}    {2×8 int32}
C{1}
ans = 2×1 cell array
    {'Item1'}
    {'Item2'}
C{2}
ans = 2×8
   2526976         8        14        11       224       224       137        80
   2526976         8        18        15       224       224       137        80

.

2 个评论
显示无隐藏无

tybo1mos 2023-12-11

That got me close to what I was looking for, but not quite in the format I need yet. I managed to get the file read into a cell array wtih all string values as follows:

I'm trying to convert this 3x9 array into a 3x6 array, such that:

1st column is still a string value.
Columns 2-5 are converted numbers
Columns 6-9 are combined as sub arrays in now column 6 as follows:

Star Strider 2023-12-12

在 MATLAB Online 中打开

This is as close as I can get to that —

Array = {'Item1', 2526976, 8, 14, 11, [224,224,137,80]
         'Item2', 2526976, 8, 18, 15, [224,224,137,80]};
fido = fopen('Test.txt','wt');
fido = 3
for k = 1:size(Array,1)
    fprintf(fido, '%s, %d, %d, %d, %d, [%d,%d,%d,%d]\n',Array{k,:});
end
fclose(fido);
type('Test.txt')
Item1, 2526976, 8, 14, 11, [224,224,137,80]
Item2, 2526976, 8, 18, 15, [224,224,137,80]
fidi = fopen('Test.txt','rt');
    C = textscan(fidi, '%s %d %d %d %d [%d %d %d %d]', 'Delimiter',{','}, 'CollectOutput',1)
C = 1×2 cell array
    {2×1 cell}    {2×8 int32}
fclose(fidi);
C
C = 1×2 cell array
    {2×1 cell}    {2×8 int32}
C{1}
ans = 2×1 cell array
    {'Item1'}
    {'Item2'}
C{2}
ans = 2×8
   2526976         8        14        11       224       224       137        80
   2526976         8        18        15       224       224       137        80
T1 = array2table(cell2mat({C{2}(:,1:4)}));
T1 = [addvars(T1,C{1}, 'Before',1) table(cell2mat({C{2}(:,5:8)}),'VariableNames',{'Var5'})]
T1 = 2×6 table
     Var1_1       Var1      Var2    Var3    Var4              Var5          
    _________    _______    ____    ____    ____    ________________________

    {'Item1'}    2526976     8       14      11     224    224    137     80
    {'Item2'}    2526976     8       18      15     224    224    137     80