MATLAB: Dealing with weird Data in Cell Array

cell arrayformating

I have the following data that is random throught a cell array. I need to remove the second decimal point on some of the data

LOLS Purge Supply – Standby.

GHe-W Supply – Standby.

0.000320.

42.9333

So in this example I need 0.000320. to be equal 0.000320 so I can later plot this data. How do I remove the second decimal point on the data that has 2 decimal points?

Please any help would be greatly appreciated. -Aaron

Best Answer

C = {'LOLS Purge Supply - Standby.';'GHe-W Supply - Standby.';'0.000320.';'42.9333';'42.9333'}
D = regexprep(C,'\d\.$','')

EDIT Thanks to Walter for catching my error.

That last line should be:

D = regexprep(C,'(?<=\d)\.$','') % Use look-behind!

Related Solutions

MATLAB: How to convert each row in a cell array to a (1*n ) double matrix

a=cell(1,164);
for j=1:164
a{j}=[Key{j,1:end}]-48;
end

MATLAB: How to remove numbers from a cell array

A trivial implementation using regexprep:

D = regexprep(C,'[\d"]','');

And tested:

>> C = {'["LAN310"]';'["SHA550"]';'["SHA430"]';'["SHB331"]';'["EDU110"]', ... };
>> D = regexprep(C,'[\d"]','');
>> D{:}
ans = [LAN]
ans = [SHA]
ans = [SHA]
ans = [SHB]
ans = [EDU]
... etc

Best Answer

Related Solutions

MATLAB: How to convert each row in a cell array to a (1*n ) double matrix

MATLAB: How to remove numbers from a cell array

Related Question