How to get numerical values of a text type cell ?

1 次查看（过去 30 天）
Li Yang
Li Yang 2019-2-27
评论： Li Yang 2019-2-28
Hi,
I am trying to read the contents of a .txt file, which is the frequency response data I got from other simulation software. The following shows the format of the data, which has 'Frequency' and 'Real/Imaginary' part of the frequency response.
Capture.JPG
I tried using 'readtable()' to load the data into MATLAB, which works. However, the loaded data is in 'Cell' format, and I am not able to get the actual value of the data, please see following.
Capture.JPG
My question is (1) how can I get the actual values ? (2) Is there any better way to do the job than 'readtable()' ? Thanks for help!

请先登录，再回答此问题。

采纳的回答

Walter Roberson
Walter Roberson 2019-2-27
T = readtable(FileName, 'Delimiter', ' ,');
  6 个评论
显示 4更早的评论
Walter Roberson
Walter Roberson 2019-2-28
T = readtable(filename, 'Delimiter', '\t,');
You did indeed have a tab.
Li Yang
Li Yang 2019-2-28
Hi Walter,
Thanks for your time and help! It works now.

请先登录，再进行评论。

更多回答（1 个）

Li Yang
Li Yang 2019-2-28
Hi Star, Walter,
Thanks for your help. Using 'Delimiter' still doesn't seem to work, I tried that, and the second column of data combined with the first column data with a new comma in between.
I actually write a short .m file to manually remove the comma and get the data I want. Not very efficient, but not quite harmful for my case.
function [Real,Imag] = Get_R_I(Resp)
len = length(Resp);
Real = zeros(len,1);
Imag = zeros(len,1);
for i = 1: len
comma = find( Resp{i} == ',' );
Real(i) = str2double(Resp{i}(1:comma-1));
Imag(i) = str2double(Resp{i}(comma+1:end));
end
end

类别

在 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!

Translated by