Split array of strings and convert to numbers?
10 vues (au cours des 30 derniers jours)
Afficher commentaires plus anciens
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 commentaire
Jan
le 20 Sep 2011
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?
Réponses (6)
Fangjun Jiang
le 26 Sep 2011
Use str2double() or str2num() instead. You are doing the opposite.
4 commentaires
Fangjun Jiang
le 26 Sep 2011
>> format long
>> str2double(A)
ans =
1.0e+009 *
1.319780805000000 1.319768288000000 1.319774249000000
Tigersnooze
le 20 Sep 2011
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 commentaires
Jan
le 26 Sep 2011
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 commentaires
Voir également
Catégories
En savoir plus sur Data Type Conversion dans Help Center et File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!