How to convert cell aray which contains numeric to double

hi guys, can u help me how to convert cell to double but with in cell have comma as decimal separator ?
for example when i convert {'0,037796'}, it will be 37796. Thankyou

 Accepted Answer

Hi Arif
I understand that you would like to convert cell aray which contains numeric to double. You can consider following the below steps:
  1. Extract the string from the cell.
  2. Replace the comma with a period.
  3. Convert the string to a double.
Here's an example code:
% Cell array with a string containing a comma as decimal separator
cellArray = {'0,037796'}
cellArray = 1×1 cell array
{'0,037796'}
% Extract the string from the cell
stringValue = cellArray{1};
% Replace the comma with a period
stringValue = strrep(stringValue, ',', '.');
% Convert the string to a double
doubleValue = str2double(stringValue)
doubleValue = 0.0378
% If you want to convert to a number without decimals (as your example suggests)
% you would remove the decimal point before converting
stringValueNoDecimal = strrep(stringValue, '.', '')
stringValueNoDecimal = '0037796'
% Now convert the modified string to a double
doubleValueNoDecimal = str2double(stringValueNoDecimal)
doubleValueNoDecimal = 37796
% Display the result
disp(doubleValue);
0.0378
Hope this helps!

More Answers (0)

Categories

Products

Release

R2023b

Asked:

on 9 Feb 2024

Commented:

on 9 Feb 2024

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!