Wrap cell values in single quote so that regexprep works
1 view (last 30 days)
Show older comments
My data has strings and digits. It looks something like:
C =
{'N',[0],'Y',[75];
'Y', '75', '0','N'}
When I run
C = regexprep(C,'N','99');
I get 'Error using regexprep: All cells must be strings.'
So, I thought I should wrap everything that isn't a string in single quotes.
I tried:
for i = 1:length(C);
if ~isstr(C{i});
C{i}= sprintf('%d', C{[i]});
end
But it doesnt work. When i change {1} to {1,3} everything that wasn't a string in column 3 becomes a string, but this is inefficient because my data has >600 columns.
What can I do?
Thank you so much for your time and help!
0 Comments
Accepted Answer
More Answers (1)
Azzi Abdelmalek
on 16 Oct 2012
Edited: Azzi Abdelmalek
on 16 Oct 2012
B= cellfun(@(x) regexprep(char(x),'N','99'),C,'un',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!