Split array of strings and convert to numbers?
9 次查看(过去 30 天)
显示 更早的评论
Hello all, reading in a 2-columned spreadsheat file using xlsread gives me the following text-string (I couldn't manage this function to read in directly to numbers): '0,000' '1319,779017' '1,000' '1319,776931' '2,000' '1319,780805' '3,000' '1319,783785' ...and so on. Now, I want to convert column 1 into an array of numbers - let's say X, and column 2 into an array of numbers, let's say Y. Which function could I use for this? Many thanks in advance
1 个评论
Jan
2011-9-20
What is column 1 and column 2? Is the comma the separator for the decimals? Does "text-string" mean, that the data are a cell string?
回答(6 个)
Fangjun Jiang
2011-9-26
Use str2double() or str2num() instead. You are doing the opposite.
4 个评论
Fangjun Jiang
2011-9-26
>> format long
>> str2double(A)
ans =
1.0e+009 *
1.319780805000000 1.319768288000000 1.319774249000000
Tigersnooze
2011-9-20
What does your code look like? Normally when I use xlsread with a multi-column spreadsheet I get a multi-column array in return.
Something like:
[num, txt, dummy] = xlsread(filename, sheet)
Will return an m-by-n array in num, depending on the rows and columns in the sheet. I think you may also be running into problems because it looks like you have multiple values in each cell separated by commas, rather than two columns (if I'm reading that correctly--and assuming you're not using European-style numbers).
0 个评论
Jan
2011-9-26
If A is a cell string and the comma is the decimal point:
A = {'1319,780805', '1319,768288', '1319,774249'};
A = strrep(A, ',', '.');
S = sprintf('%s*', A{:});
Num = sscanf(S, '%g*');
This is very fast even for large arrays.
0 个评论
另请参阅
类别
在 Help Center 和 File Exchange 中查找有关 Data Type Conversion 的更多信息
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!