textscan fopen

Question

Tiina 2012-1-4

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/25290-textscan-fopen

在 MATLAB Online 中打开

I have a file to open which looks as follows

row1: '#CIR,Date[L],Time[L],Type,Clr Dir.'

then a list of

rows 'AXY.P,20050101,09:35:01.202,quant,^'

I used fid=fopen('location of the file …) textscan(fid, ' …%s %f combinations …. yet couldn;t get out what I wanted in an output

I wish to have 5 columns as shown by the delimiter ',' and convert the last column sign^ to a number say 1. Ultimately it would look like

AXY.P 20050101 09:35:01.202, quant, 1

Any help is appreciated.

0 个评论
显示 -2更早的评论隐藏 -2更早的评论

请先登录，再进行评论。

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

Answer 1

Friedrich 2012-1-4

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/25290-textscan-fopen#answer_33189

在 MATLAB Online 中打开

Hi,

I created a file (data.txt) which contains the following lines

AXY.P,20050101,09:35:01.202,quant,^
AXY.P,20050101,09:35:01.202,quant,^
AXY.P,20050101,09:35:01.202,quant,^

You can get this data into MATLAB like this:

fid = fopen('data.txt','r');
data = textscan(fid,'%s%s%s%s%s','delimiter',',');
fclose(fid);
celldisp(data)

So convert the ^ to the number 4:

data{5} = num2cell(4*ones(size(data{5})));
celldisp(data)

2 个评论
显示无隐藏无

Tiina 2012-1-5

Hi,

with respect to the column containing character ^ (and some letters) num2cell may impose a value rather than convert or assign a number for characters and/or letters. if I use data.txt as created in the answer and I make an adjustment it may clarify the question more

AXY.P,20050101,09:35:01.202,quant,^

AXY.P,20050101,09:35:01.202,quant,w

AXY.P,20050101,09:35:01.202,quant,q

AXY.P,20050101,09:35:01.202,quant,^

then the char in the end would be in a col like

1

2

3

1

Tiina

Walter Roberson 2012-1-5

Use the three-output form of unique() and use the third output as the column value.

请先登录，再进行评论。

Answer 2

TAB 2012-1-5

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/25290-textscan-fopen#answer_33249

在 MATLAB Online 中打开

Considering the content of file are as

AXY.P,20050101,09:35:01.202,quant,^ 
AXY.P,20050101,09:35:01.202,quant,w 
AXY.P,20050101,09:35:01.202,quant,q 
AXY.P,20050101,09:35:01.202,quant,^

-------------------------------------------------------

SymbolTable={'^','w','q'};
NumTable   =[1  ,2  ,3];
fid = fopen('data.txt');
data = textscan(fid,'%s%s%s%s%s','delimiter',',');
for k=1:length(data{5})
    data{5}(k)=num2cell(NumTable(strcmp(SymbolTable,data{5}(k))==1));
end
fclose(fid);