Conversion from char data type to double
1 次查看(过去 30 天)
显示 更早的评论
I converted a data [0.104895105] from double to binary[0001]. But this binary data is in char form as in excel it shows like '0001'.
1. Is it possible to convert back to double data type without loosing any thing?
2. is it possible to remove ' ' from the data? Thanks in Advance.
3 个评论
Walter Roberson
2015-10-31
Suppose I have a function that converts the value -2 to the value 4. I do not tell you what the function is. I ask you to convert the value 4 back to -2 without seeing my function. Can you do it?
Answer: No. There are an infinite number (Aleph 1) of functions that happen to map -2 to 4. One of them is f(x) = x^2. But that function also maps +2 to 4, so given only the value 4 there is no way to invert that function to get -2 unambiguously.
回答(1 个)
Walter Roberson
2015-10-29
编辑:Walter Roberson
2015-10-29
Subtract '0' from the array. That is '0' not 0
2 个评论
Walter Roberson
2015-10-29
You want a numeric data type holding 4 distinguishable locations. In MATLAB, all numeric data types are displayed with whitespace between locations by any of the routines that do automatic formatting.
As far as I understand, Excel has no way of holding multiple numeric values in a single cell.
另请参阅
类别
在 Help Center 和 File Exchange 中查找有关 Spreadsheets 的更多信息
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!