how to load dat file without header?

hi friends
could you please help me upload dat file without header, also I would like to get similar arrangement of data, as you see there is some rows have extra columns
thanks

 Risposta accettata

Since you have not attached any sample file, I am giving you an example with a attached file.
A=importdata('sample.txt');
A.data

7 Commenti

Thanks @ANKUR KUMAR for your reply, but still I am facing the problem cause the headers for 4 columns while data for 6 columns and 8 columns sometimes
ANKUR KUMAR
ANKUR KUMAR il 8 Ott 2018
Modificato: ANKUR KUMAR il 8 Ott 2018
Please attach your .txt file.
here is the file, thanks once again
ANKUR KUMAR
ANKUR KUMAR il 8 Ott 2018
Modificato: ANKUR KUMAR il 8 Ott 2018
Try this one.
clc
clear
for kk=2:7
fid=fopen('df.dat');
C = textscan(fid,'%s',1,'delimiter','\n', 'headerlines',kk-1);
C1{kk-1}=strsplit(char(C{1}),' ')
id(kk-1)=length(C1{kk-1});
end
for i=1:length(C1)
C1{i}(length(C1{i})+1:max(id))={''}; %added +1 after length(C1{i})
end
C2=cat(1,C1{:})
If you wish to store in matrix, then put 0 and then convert to matix
for i=1:length(C1)
C1{i}(length(C1{i})+1:max(id))={'0'}; %added +1 after length(C1{i})
end
C2=str2double(cat(1,C1{:}))
@ANKUR KUMAR wow you are great.. I really appreciate your kind support,, thanks a lot
ANKUR KUMAR
ANKUR KUMAR il 8 Ott 2018
Modificato: ANKUR KUMAR il 8 Ott 2018
Updated the previous answer. Updated commands are:
C1{i}(length(C1{i})+1:max(id))={''};
and
C1{i}(length(C1{i})+1:max(id))={'0'};
I forgot to add 1 after length(C1{i}).
Sorry for the inconvenience.
Oh Thanks once again

Accedi per commentare.

Più risposte (0)

Categorie

Scopri di più su Simulink in Centro assistenza e File Exchange

Tag

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!

Translated by