Creating new array from individual string outputs
1 view (last 30 days)
Show older comments
I'm trying to write a script that looks through two excel documents and finds strings that are in the first document but aren't in the second. I have been successful in doing this, however I can't figure out how to display the strings in a new array. This is what I have so far:
if true
% code
end
[num1,excel1,raw1] = xlsread('excel1');
[num2,excel2,raw2] = xlsread('excel2');
end
names1 = excel1(:,1);
names2 = excel1(:,1);
for k = 1:length(names);
match = strmatch(names1(k),names2);
if rem(match,1) == 0
else x = names1(k)
end
end
0 Comments
Accepted Answer
Azzi Abdelmalek
on 10 Nov 2014
Edited: Azzi Abdelmalek
on 10 Nov 2014
end
[num1,excel1,raw1] = xlsread('excel1');
[num2,excel2,raw2] = xlsread('excel2');
end
names1 = excel1(:,1);
names2 = excel1(:,1);
x={}
for k = 1:length(names);
match = strmatch(names1(k),names2);
if rem(match,1) == 0
else x(end+1) = names1(k)
end
end
0 Comments
More Answers (1)
Image Analyst
on 10 Nov 2014
What do you mean by "how to display the strings"? Some ways:
- You can use fprintf(),
- Or just put the name of the array on its own line and it will spit it out to the command window.
- Or you can just look in the variable editor (double click on the variable name in the workspace to bring it up) and it will display it for you in a table/grid/spreadsheet style.
- Or you can use the function celldisp().
Would one of those ways work for you? There are other ways if you want to use a GUI, such as
- an edit box,
- a static text label,
- a uitable,
- a listbox, etc.
0 Comments
See Also
Categories
Find more on Line Plots in Help Center and File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!