Reading a CSV file with XLSread, convert raw data to strings
1 view (last 30 days)
Show older comments
How do I convert this cell array to a char array (obtained by reading in from a csv file using xlsread and the "raw" argument
A =
[ 1]
[ 2]
[ 3]
'Y'
[ 5]
[ 6]
[ 7]
'Y'
'X'
[ 9]
[10]
I need to output this to a text file and have used:
for row = 1:numel(A)
fprintf(fileID,'%s\n',A{row});
end
but I get strange characters:
0 Comments
Accepted Answer
Stephen23
on 13 Apr 2015
Edited: Stephen23
on 13 Apr 2015
Given a cell array of mixed numeric and string data:
>> A = {1;2;3;'Y';5;6;7;'Y';'X';9;10};
>> B = cellfun(@num2str,A, 'UniformOutput',false)
B =
'1'
'2'
'3'
'Y'
'5'
'6'
'7'
'Y'
'X'
'9'
'10'
>> char(B)
ans =
1
2
3
Y
5
6
7
Y
X
9
10
3 Comments
Guillaume
on 13 Apr 2015
Edited: Guillaume
on 13 Apr 2015
cellfun calls the function you give it (in this case num2str) passing it in turn each element of the input cell array(s). It collects the output(s) of the function in a cell array the same shape as the input, if you pass it 'UniformOutput', false (or an plain array otherwise).
It is equivalent to writing a for loop over each element of the cell array and calling num2str within the loop, except you don't have to predeclare the output, nor do you have to worry about finding the bounds of the loop.
In this case, the line is equivalent to:
B = cell(size(A));
for idx = 1:numel(A)
B{idx} = num2str(A{idx});
end
More Answers (0)
See Also
Categories
Find more on Characters and Strings 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!