Read data file with mixed delimited columns

Question

Georgios 2018-1-15

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/377276-read-data-file-with-mixed-delimited-columns

评论： Georgios 2018-1-16

I have a file with data like this:

Freq.                  V(out)
000000000e-003  4.030864362e-004,2.007296583e-002
000693387e-003  4.036453944e-004,2.008687294e-002
001387255e-003  4.042051275e-004,2.010078967e-002

There are thousands of rows

I would like to have two columns, where the first column is the same as above but the second column is a complex number, made up of the two parts of the comma delimited part, like this:

000000000e-003  4.030864362e-004+2.007296583e-002i
000693387e-003  4.036453944e-004+2.008687294e-002i
001387255e-003  4.042051275e-004+2.010078967e-002i

I have been using a text editor to remove the first line header, and the comma, to create what I am looking for.

Below is an example of the code. The data is in a file named RC_HighPassCartesian.txt

load RC_HighPassCartesian.txt   
w=RC_HighPassCartesian(:,1);  % Copy first column into vector w
w=w*2*pi;      % Convert to radians  
h1=RC_HighPassCartesian(:,2);  % Copy second column into vector h1
h2=RC_HighPassCartesian(:,3);  % Copy third  column into vector h2
h2=h2*1i;         % Multiply h2 column by imaginary unit i
h=h1+h2;      % Create h as a complex valued vector