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

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

Answer 1

[Walter Roberson]

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.

[naadiya khudabux]

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);

[Walter Roberson]

I need a sample of the file.

Why did you change formats from comma separated values to tab separated values?

[naadiya khudabux]

no, i am just practicing for myself.The original file is still same. can u tell me how can I read multiple text file. I want to read 32 text file ,each file is about 100MB I have tried myself.here is my code but taking too much time.

if true
 cur_dir=cd
arcfmt = ['%u64', '%s', repmat('%u64',1,25)]
textFilename = cell(1,32);
      id = cell(1,32);
      for k=1:32;
      textFilename{k} = fullfile('C:\Users\Naadiya Khuda Bux\Documents\mobile data\MME',['disk' num2str(k)     '.txt'])
      id{k} = fopen(textFilename{k},'rt')
      str{k} = textscan(id{k}, arcfmt, 'HeaderLines', 1, 'Delimiter', ','); 
      end
end 

if true
 thank you 
end

[naadiya khudabux]

should i go for filedatstore ?

[Walter Roberson]

For the format you posted most recently, with the four columns and mix of tabs and spaces between the columns:

projectdir = fullfile('C:', 'Users', 'Naadiya Khuda Bux', 'Documents', 'mobile data');

arcfmt = '%s%u64%u64%u64';

numfiles = 32;
textFilename = cell(1, numfiles);
str = cell(1, numfiles);
datacell = 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, 'CollectOutput', 1);
  str{k} = temp{1};
  datacell{k} = temp{2};
  fclose(fid);
end

[naadiya khudabux]

thank you.. and from each text file consist 27 columns. i just want to extract 3 columns from it ie. 6, 8 and 9 . and convert to double array . how to it please. the format is given below

[naadiya khudabux]

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]

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.

[naadiya khudabux]

thank you .but code has error

if true
Cell contents assignment to a non-cell array object. 
end

[Walter Roberson]

arc_MSISDN = cell(1, numfiles);

[naadiya khudabux]

thannkk youuu