Split array of strings and convert to numbers?

2011 9 20
6 个回答
更新时间：2023 7 27
13 次查看（30 天）

0 个投票

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 个评论
显示 -1更早的评论 隐藏 -1更早的评论

Jan
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
Fangjun Jiang 2011-9-26

1 个投票

Use str2double() or str2num() instead. You are doing the opposite.

4 个评论
显示 2更早的评论 隐藏 2更早的评论

schor
schor 2011-9-26
Ah, of course, I was using str2num and str2double. The former doesn't work on arrays at all, the latter truncates the strings. So, do you have any other ideas how this could be done?
Fangjun Jiang
Fangjun Jiang 2011-9-26
What do you mean "doesn't work". What is your matrix A (in what format)?
If A is a cell array of string, see below.
>> A = {'1319,780805', '1319,768288', '1319,774249'};
>> str2double(A)
ans =
1.0e+009 *
1.3198 1.3198 1.3198
Fangjun Jiang
Fangjun Jiang 2011-9-26
>> format long
>> str2double(A)
ans =
1.0e+009 *
1.319780805000000 1.319768288000000 1.319774249000000

请先登录，再进行评论。

Tigersnooze
Tigersnooze 2011-9-20

0 个投票

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).
schor
schor 2011-9-26

0 个投票

Hi, I did exactly that, but it didn't work. Have I stored my data in an xls-format too new for Matlab (2007b)? Please find attached the xls file (which was automatically generated using LabVIEW). I get the following error message (running on Linux)
[num, txt, dummy] = xlsread(filename, sheet)
>> [num, txt, dummy] = xlsread('10mMHis_2mMTartaric_A_10_0.xls', 1)
Warning: XLSREAD has limited import functionality on non-Windows platforms
or in basic mode. Refer to HELP XLSREAD for more information.
> In xlsread at 201
??? Error using ==> biffread at 52
Unable to read XLS file
Ok now I've just realised that I can't attach anything here, maybe you guys could send me your email address? Many thanks!
schor
schor 2011-9-26

0 个投票

After some further examination, my question boils down to the point how an array of strings can be converted into an array of numbers:
A= '1319,780805'
'1319,768288'
'1319,774249'
...and so on, B=num2str(A) doesn't work, B=num2double(A) also doesn't work. Any ideas? Many thanks!

1 个评论
显示 -1更早的评论 隐藏 -1更早的评论

Jan
Jan 2011-9-26
Is this a cell string or CHAR matrix? Is the comma the decimal separator or a kind of column separator?

请先登录，再进行评论。

Jan
Jan 2011-9-26

0 个投票

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.

类别

在 帮助中心 和 File Exchange 中查找有关 Data Type Conversion 的更多信息

标签

提问:

schor
schor
2011-9-20

评论：

Binod krushna
Binod krushna
2023-7-27

Community Treasure Hunt

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

Start Hunting!

Translated by