can someone tell me how can i read this text file?

Question

naadiya khudabux 2016-10-18

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/307783-can-someone-tell-me-how-can-i-read-this-text-file

评论： naadiya khudabux 2016-10-19

hello i have text file . i am trying to read it read it but not getting the results.

endarcfmt = ['%s', repmat('%f64',1,4)]
fid = fopen('half.txt','r');
dc = textscan(fid, arcfmt, 'HeaderLines', 1, 'Delimiter', '\t', 'EmptyValue', uint8(0), 'CollectOutput', 1)
fclose(fid);
                                              
160a01184201c500    3.63392E+18  6.04919E+18  7.30445E+18                                                            
160a011842034200    3.63392E+18  6.04919E+18  7.30445E+18                                                            
160a01184204f700    3.63392E+18  6.04919E+18  7.30445E+18                                                            
160a01184209c800    7.17463E+18  7.63062E+16  4.97705E+18                                                            
160a0118421bcb00    3.63392E+18  6.04919E+18  7.30445E+18                                                            
160a0118421bcc00    3.63392E+18  6.04919E+18  7.30445E+18                                                            
160a011842376000    1.59888E+18  4.90256E+18  8.61872E+18                                                            
160a0118423b6400    8.67273E+18  6.735E+18  3.26382E+18                                                            
160a0118424ecd00    8.67273E+18  6.735E+18  3.26382E+18                                                            
160a0118424ece00    8.67273E+18  6.735E+18  3.26382E+18                                                            
160a0118424f3200    8.67273E+18  6.735E+18  3.26382E+18                                                            
160a0118424f4e00    8.67273E+18  6.735E+18  3.26382E+18                                                            
160a0118424f6a00    8.67273E+18  6.735E+18  3.26382E+18                                                            
160a0118424f7000    8.67273E+18  6.735E+18  3.26382E+18                                                            
160a0118424f7300    2.06908E+18  8.49562E+17  8.23739E+18                                                            
160a0118424f8d00    8.67273E+18  6.735E+18  3.26382E+18                                                            
160a0118424fb700    2.06908E+18  8.49562E+17  8.23739E+18                                                            
160a0118424fb800    2.06908E+18  8.49562E+17  8.23739E+18

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

请先登录，再进行评论。

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

Answer 1

Walter Roberson 2016-10-18

1
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/307783-can-someone-tell-me-how-can-i-read-this-text-file#answer_239478

在 MATLAB Online 中打开

It appears to be

dc = textscan(fid, arcfmt, 'HeaderLines', 1, 'Delimiter', '\t', 'MultipleDelimsAsOne', true, 'CollectOutput', 1);

This will only work if there are no missing column entries. If there are missing column entries then it gets complicated to try to figure out when the multiple tabs are there to make things pretty, and when there are there to indicate that the value is not present.

11 个评论
显示 9更早的评论隐藏 9更早的评论

naadiya khudabux 2016-10-18

编辑：Walter Roberson 2016-10-18

在 MATLAB Online 中打开

XDRID  IMSI  IMEI  MSISDN                                                            
160a01184201c500  3.63E+18  6.05E+18  7.30E+18                                                            
160a011842034200  3.63E+18  6.05E+18  7.30E+18                                                            
160a01184204f700  3.63E+18  6.05E+18  7.30E+18                                                            
160a01184209c800  7.17E+18  7.63E+16  4.98E+18                                                            
160a0118421bcb00  3.63E+18  6.05E+18  7.30E+18                                                            
160a0118421bcc00  3.63E+18  6.05E+18  7.30E+18                                                            
160a011842376000  1.60E+18  4.90E+18  8.62E+18

am not getting the result when am modifying this code can you guide me where i am wrong.

clc
clear all
fid = fopen('hhh.txt','r');
dc = textscan(fid, '%s %f %f %f', 'HeaderLines', 1, 'Delimiter', '\t', 'MultipleDelimsAsOne', true, 'CollectOutput', 1);
fclose(fid);
celldisp(dc)
arc_rows = dc{2}
arc_xdrid = dc{1};
acctfmt = repmat('%u64', 1, 3);
fid = fopen('gaoxiaotest2.txt', 'rt')
for part = 1 : 9
  %we read multiple times to account for bugs in the file
ac{part} = textscan(fid, acctfmt, 'HeaderLines', 1, 'Delimiter', ',', 'EmptyValue', uint8(0), 'CollectOutput', 1);
end
fclose(fid);

naadiya khudabux 2016-10-19

编辑：Walter Roberson 2016-10-19

在 MATLAB Online 中打开

Interface,XDRID,RAT,IMSI,IMEI,MSISDN,ProcedureType,RequestTime,EndTime,Status,RequestCause,FailureCause,MMEUES1APID,OldMMEGroupID,OldMMECode,OldMTMSI,MMEGroupID,MMECode,MTMSI,TMSI,UserIPv4,MMEIP,TAC,ECI,OtherTAC,OtherECI,APN
5,164c82d268df6200,,1235129569733226393,3896604662432012625,1981332919220742968,3,1467313482103,1467313482138,0,,,33737677,,,0,835,196,0,,,,29633,118292737,,0,
5,164c82d2718abd00,,5782856116930821375,4020071039092138401,1718905558225599176,3,1467314368582,1467314368637,0,,,402671866,,,0,835,202,0,,,,29521,121577474,,0,
5,164c82d294e6f300,,7710197837266186186,5622106978823734452,4073353040224116802,3,1467318087880,1467318087919,0,,,335603597,,,0,835,202,0,,,,29633,121476887,,0,
5,164c82d29ca4c700,,1235129569733226393,3896604662432012625,1981332919220742968,3,1467318914396,1467318914426,0,,,33624456,,,0,835,196,0,,,,29633,118292737,,0,
5,164c82d2e39e2e00,,6866223622199072456,188112898441665396,3810045977208527163,3,1467325660105,1467325660135,0,,,352365181,,,0,835,202,0,,,,29633,118293507,,0,
5,164c82d2f290be00,,1037474348875555907,2178760593874958916,8775034087274148370,3,1467326724595,1467326724644,0,,,285236774,,,0,835,194,0,,,,29633,118355203,,0,
5,164c82d2f57c6300,,135325435076694125,4418622755012114533,5317606389808640048,3,1467326922239,1467326922245,0,,,285226758,,,0,832,218,0,,,,58271,117608449,,0,

Walter Roberson 2016-10-19

在 MATLAB Online 中打开

arcfmt = [repmat('%*s', 1, 5), '%u64%*s%f%f', repmat('%s',1,27-9)];
projectdir = fullfile('C:', 'Users', 'Naadiya Khuda Bux', 'Documents', 'mobile data');
numfiles = 32;
textFilename = cell(1, numfiles);
arc_MSISDN = zeros(1, numfiles, 'uint64');
arc_RequestTime = cell(1, numfiles);
arc_EndTime = cell(1, numfiles);
arc_RequestTime_datenum = cell(1, numfiles);
arc_EndTime_datenum = cell(1, numfiles);
arc_RequestTime_datetime = cell(1, numfiles);
arc_EndTime_datetime = cell(1, numfiles);
for k = 1 : numfiles
  textFilename{k} = fullfile( projectdir, sprintf('MMEdisk%d.txt', k) );
  fid = fopen(textFilename{k}, 'rt');
  temp = textscan(fid, arcfmt, 'HeaderLines', 1, 'Delimiter', ',', 'EmptyValue', 0, 'CollectOutput', 0, );
  arc_MSISDN{k} = temp{1};    %does not make sense as a double!
  rt = temp{2};
  et = temp{3};
  arc_RequestTime{k} = rt;
  arc_RequestTime_datenum = rt / 1000 / 86400 + datenum('01-Jan-1970');
  arc_RequestTime_datetime = datetime(rt/1000, 'ConvertFrom', 'posixtime');
  arc_EndTime{k} = et;
  arc_EndTime_datenum{k} = et / 1000 / 86400 + datenum('01-Jan-1970');
  arc_EndTime_datetime{k} = datetime(et/1000, 'ConvertFrom', 'posixtime');
  fclose(fid);
end

you probably do not need all three forms of the times that I create here. arc_RequestTime and arc_EndTime are the values exactly as read in. arc_RequestTime_datenum and arc_EndTime_datenum are the values read in and converted to serial date numbers, which are the older method of representing time in MATLAB (and sometimes still more convenient.) arc_RequestTime_datetime and arc_EndTime_time are in the newer datetime time representation format. Note: the datetime forms probably take into account leap seconds and timezones relative to you, where the datenum do not.