0 votos

I use readtable to import .22p file; i want to obtain a cell matrix. I have a lot of .22p file of different days. In some days readtable works really good and in other days it fails. For example for the first file 187 attached it dosen't work, while for the scond file 186 it works. The 2 files are the same and there is only a change in the numbers. For file 187 i optain this error:
Warning: Column headers from the file
were modified to make them valid
MATLAB identifiers before creating
variable names for the table. The
original column headers are saved in
the VariableDescriptions property.
Set 'VariableNamingRule' to
'preserve' to use the original column
headers as table variable names.
And the result cell matrix is this:
While for the day 186 i obtain the right result:

4 comentarios
Mostrar 2 comentarios más antiguos Ocultar 2 comentarios más antiguos

Stephen23
Stephen23 el 14 de Feb. de 2023
@Fr Ma: we cannot test code on screenshots of data files. Please upload sample data file by clicking the paperclip button.
Fr Ma
Fr Ma el 14 de Feb. de 2023
The original file .22p cannot be uploaded beacuse this format is not supported.
Stephen23
Stephen23 el 14 de Feb. de 2023
Editada: Stephen23 el 14 de Feb. de 2023
"The original file .22p cannot be uploaded beacuse this format is not supported."
You can upload anything here, just append ".txt" onto the filename. If it is large, zip it up.
Fr Ma
Fr Ma el 14 de Feb. de 2023
Ok, these are the two .txt files.

Iniciar sesión para comentar.

Iniciar sesión para responder a esta pregunta.

 Respuesta aceptada

Stephen23
Stephen23 el 14 de Feb. de 2023
Editada: Stephen23 el 14 de Feb. de 2023
Ran in:

0 votos

Ran in:
One simple approach is to call DETECTIMPORTOPTIONS() on a known good file**, and use those options for all of the other files. This seems to correctly deal with the final column, which otherwise causes some import-confusion due to the varying length of its content.
** In practice this seems to mean a file which has no trailing whitespace in the final column on the first row.
% code just to copy .TXT to .22P:
f70 = 'brdm1870gal.22p';
f60 = 'brdm1860gal.22p';
copyfile('brdm1870gal.txt',f70)
copyfile('brdm1860gal.txt',f60)
% code to import file data:
o70 = detectImportOptions(f70, 'FileType','fixedWidth', 'VariableNamesLine',1,...
'VariableNamingRule','preserve', 'ExpectedNumVariables',36);
t70 = readtable(f70,o70)
t70 = 4370×36 table
SAT YEAR MO DY HR MN SS BIAS [s] DRIFT [s/s] RATE [s/s^2] IODnav [-] CRS [m] Delta n [rad/s] M0 [rad] CUC [rad] E [-] CUS [rad] A^1/2 [m^1/2] TOE [s] CIC [rad] OMEGA0 [rad] CIS [rad] I0 [rad] CRC [m] omega [rad] OMEGA DOT [rad/s] IDOT [rad/s] Data Sources [-] GAL week [#] - SISA [m] SV Health [-] BGD E5a/E1 [s] BGD E5b/E1 [s] TIME MSG [s] Message Type _______ ____ __ __ __ __ __ ___________ ___________ ____________ __________ _______ _______________ ________ __________ __________ __________ _____________ _________ ___________ ____________ __________ ________ _______ ___________ _________________ ____________ ________________ ____________ _ ________ _____________ ______________ ______________ ____________ _________________________________ {'E01'} 2022 7 6 0 0 0 -0.00050957 -7.3612e-12 0 48 51.281 3.2737e-09 -1.3505 2.4382e-06 0.00015041 5.0683e-06 5440.6 2.592e+05 1.8626e-09 -0.34094 1.1176e-08 0.9733 235.25 -1.4681 -5.7585e-09 -1.05e-10 517 2217 0 3.12 0 9.3132e-10 9.3132e-10 2.5986e+05 {'I/NAV E1-B I/NAV E5b-I merged'} {'E01'} 2022 7 6 0 0 0 -0.00050957 -7.3612e-12 0 48 51.281 3.2737e-09 -1.3505 2.4382e-06 0.00015041 5.0683e-06 5440.6 2.592e+05 1.8626e-09 -0.34094 1.1176e-08 0.9733 235.25 -1.4681 -5.7585e-09 -1.05e-10 258 2217 0 3.12 0 9.3132e-10 0 2.599e+05 {'F/NAV E5a-I' } {'E01'} 2022 7 6 0 10 0 -0.00050958 -7.3612e-12 0 49 51.531 3.2773e-09 -1.276 2.4699e-06 0.00015043 5.0794e-06 5440.6 2.598e+05 1.8626e-09 -0.34094 1.1176e-08 0.9733 235.16 -1.4683 -5.7577e-09 -1.0572e-10 517 2217 0 3.12 0 9.3132e-10 9.3132e-10 2.6046e+05 {'I/NAV E1-B I/NAV E5b-I merged'} {'E01'} 2022 7 6 0 10 0 -0.00050958 -7.347e-12 0 49 51.531 3.2773e-09 -1.276 2.4699e-06 0.00015043 5.0794e-06 5440.6 2.598e+05 1.8626e-09 -0.34094 1.1176e-08 0.9733 235.16 -1.4683 -5.7577e-09 -1.0572e-10 258 2217 0 3.12 0 9.3132e-10 0 2.605e+05 {'F/NAV E5a-I' } {'E01'} 2022 7 6 0 20 0 -0.00050958 -7.3612e-12 0 50 51.688 3.2805e-09 -1.2015 2.4959e-06 0.00015046 5.0943e-06 5440.6 2.604e+05 0 -0.34094 1.3039e-08 0.9733 235.06 -1.4684 -5.757e-09 -1.0643e-10 517 2217 0 3.12 0 9.3132e-10 9.3132e-10 2.6106e+05 {'I/NAV E1-B I/NAV E5b-I merged'} {'E01'} 2022 7 6 0 20 0 -0.00050958 -7.3612e-12 0 50 51.688 3.2805e-09 -1.2015 2.4959e-06 0.00015046 5.0943e-06 5440.6 2.604e+05 0 -0.34094 1.3039e-08 0.9733 235.06 -1.4684 -5.757e-09 -1.0643e-10 258 2217 0 3.12 0 9.3132e-10 0 2.611e+05 {'F/NAV E5a-I' } {'E01'} 2022 7 6 0 30 0 -0.00050959 -7.3612e-12 0 51 51.812 3.2837e-09 -1.127 2.5183e-06 0.00015048 5.1111e-06 5440.6 2.61e+05 -3.7253e-09 -0.34095 1.1176e-08 0.9733 234.97 -1.4684 -5.7563e-09 -1.0786e-10 517 2217 0 3.12 0 9.3132e-10 9.3132e-10 2.6166e+05 {'I/NAV E1-B I/NAV E5b-I merged'} {'E01'} 2022 7 6 0 30 0 -0.00050959 -7.3612e-12 0 51 51.812 3.2837e-09 -1.127 2.5183e-06 0.00015048 5.1111e-06 5440.6 2.61e+05 -3.7253e-09 -0.34095 1.1176e-08 0.9733 234.97 -1.4684 -5.7563e-09 -1.0786e-10 258 2217 0 3.12 0 9.3132e-10 0 2.617e+05 {'F/NAV E5a-I' } {'E01'} 2022 7 6 0 40 0 -0.00050959 -7.3612e-12 0 52 51.844 3.2873e-09 -1.0526 2.5351e-06 0.00015049 5.1279e-06 5440.6 2.616e+05 -5.5879e-09 -0.34095 1.1176e-08 0.9733 234.91 -1.4685 -5.7556e-09 -1.0893e-10 517 2217 0 3.12 0 9.3132e-10 9.3132e-10 2.6226e+05 {'I/NAV E1-B I/NAV E5b-I merged'} {'E01'} 2022 7 6 0 40 0 -0.00050959 -7.347e-12 0 52 51.844 3.2873e-09 -1.0526 2.5351e-06 0.00015049 5.1279e-06 5440.6 2.616e+05 -5.5879e-09 -0.34095 1.1176e-08 0.9733 234.91 -1.4685 -5.7556e-09 -1.0893e-10 258 2217 0 3.12 0 9.3132e-10 0 2.623e+05 {'F/NAV E5a-I' } {'E01'} 2022 7 6 0 50 0 -0.0005096 -7.3612e-12 0 53 51.844 3.2909e-09 -0.97823 2.5444e-06 0.00015049 5.1428e-06 5440.6 2.622e+05 -7.4506e-09 -0.34095 9.3132e-09 0.9733 234.94 -1.4685 -5.7552e-09 -1.1036e-10 517 2217 0 3.12 0 9.3132e-10 9.3132e-10 2.6286e+05 {'I/NAV E1-B I/NAV E5b-I merged'} {'E01'} 2022 7 6 0 50 0 -0.00050959 -7.3612e-12 0 53 51.844 3.2909e-09 -0.97823 2.5444e-06 0.00015049 5.1428e-06 5440.6 2.622e+05 -7.4506e-09 -0.34095 9.3132e-09 0.9733 234.94 -1.4685 -5.7552e-09 -1.1036e-10 258 2217 0 3.12 0 9.3132e-10 0 2.629e+05 {'F/NAV E5a-I' } {'E01'} 2022 7 6 1 0 0 -0.0005096 -7.3612e-12 0 54 51.812 3.2948e-09 -0.90387 2.5518e-06 0.00015048 5.1577e-06 5440.6 2.628e+05 -9.3132e-09 -0.34096 7.4506e-09 0.9733 235 -1.4684 -5.7545e-09 -1.1215e-10 517 2217 0 3.12 0 9.3132e-10 9.3132e-10 2.6346e+05 {'I/NAV E1-B I/NAV E5b-I merged'} {'E01'} 2022 7 6 1 0 0 -0.0005096 -7.347e-12 0 54 51.812 3.2948e-09 -0.90387 2.5518e-06 0.00015048 5.1577e-06 5440.6 2.628e+05 -9.3132e-09 -0.34096 7.4506e-09 0.9733 235 -1.4684 -5.7545e-09 -1.1215e-10 258 2217 0 3.12 0 9.3132e-10 0 2.635e+05 {'F/NAV E5a-I' } {'E01'} 2022 7 6 1 10 0 -0.0005096 -7.3612e-12 0 55 51.75 3.2987e-09 -0.82951 2.5555e-06 0.00015047 5.1688e-06 5440.6 2.634e+05 -9.3132e-09 -0.34096 5.5879e-09 0.9733 235.12 -1.4684 -5.7542e-09 -1.1358e-10 513 2217 0 3.12 0 9.3132e-10 9.3132e-10 2.6406e+05 {'I/NAV E1-B' } {'E01'} 2022 7 6 1 10 0 -0.0005096 -7.347e-12 0 55 51.75 3.2987e-09 -0.82951 2.5555e-06 0.00015047 5.1688e-06 5440.6 2.634e+05 -9.3132e-09 -0.34096 5.5879e-09 0.9733 235.12 -1.4684 -5.7542e-09 -1.1358e-10 258 2217 0 3.12 0 9.3132e-10 0 2.641e+05 {'F/NAV E5a-I' }
t60 = readtable(f60,o70)
t60 = 4347×36 table
SAT YEAR MO DY HR MN SS BIAS [s] DRIFT [s/s] RATE [s/s^2] IODnav [-] CRS [m] Delta n [rad/s] M0 [rad] CUC [rad] E [-] CUS [rad] A^1/2 [m^1/2] TOE [s] CIC [rad] OMEGA0 [rad] CIS [rad] I0 [rad] CRC [m] omega [rad] OMEGA DOT [rad/s] IDOT [rad/s] Data Sources [-] GAL week [#] - SISA [m] SV Health [-] BGD E5a/E1 [s] BGD E5b/E1 [s] TIME MSG [s] Message Type _______ ____ __ __ __ __ __ ___________ ___________ ____________ __________ _______ _______________ ________ __________ __________ __________ _____________ _________ ___________ ____________ ___________ ________ _______ ___________ _________________ ____________ ________________ ____________ _ ________ _____________ ______________ ______________ ____________ _______________ {'E01'} 2022 7 5 0 0 0 -0.00050894 -7.3044e-12 0 32 8.7188 3.2205e-09 0.55316 2.4587e-07 0.00014761 5.7593e-06 5440.6 1.728e+05 2.794e-08 -0.34044 -1.6764e-08 0.97332 225.78 -1.517 -5.6449e-09 -3.9787e-10 513 2217 0 3.12 0 4.6566e-10 2.3283e-10 1.7348e+05 {'I/NAV E1-B' } {'E01'} 2022 7 5 0 0 0 -0.00050894 -7.2902e-12 0 32 8.7188 3.2205e-09 0.55316 2.4587e-07 0.00014761 5.7593e-06 5440.6 1.728e+05 2.794e-08 -0.34044 -1.6764e-08 0.97332 225.78 -1.517 -5.6449e-09 -3.9787e-10 258 2217 0 3.12 0 4.6566e-10 0 1.735e+05 {'F/NAV E5a-I'} {'E01'} 2022 7 5 0 10 0 -0.00050894 -7.2902e-12 0 33 8.3438 3.2291e-09 0.62702 2.0489e-07 0.00014764 5.709e-06 5440.6 1.734e+05 2.4214e-08 -0.34044 -1.1176e-08 0.97332 226.28 -1.5165 -5.6502e-09 -3.9966e-10 513 2217 0 3.12 0 4.6566e-10 2.3283e-10 1.7406e+05 {'I/NAV E1-B' } {'E01'} 2022 7 5 0 10 0 -0.00050894 -7.2902e-12 0 33 8.3438 3.2291e-09 0.62702 2.0489e-07 0.00014764 5.709e-06 5440.6 1.734e+05 2.4214e-08 -0.34044 -1.1176e-08 0.97332 226.28 -1.5165 -5.6502e-09 -3.9966e-10 258 2217 0 3.12 0 4.6566e-10 0 1.741e+05 {'F/NAV E5a-I'} {'E01'} 2022 7 5 1 0 0 -0.00050897 -7.276e-12 0 38 7.6562 3.273e-09 0.99605 1.3411e-07 0.00014771 5.3849e-06 5440.6 1.764e+05 -1.1176e-08 -0.34046 1.8626e-09 0.97331 229.47 -1.5136 -5.6792e-09 -4.0252e-10 513 2217 0 3.12 0 4.6566e-10 2.3283e-10 1.7756e+05 {'I/NAV E1-B' } {'E01'} 2022 7 5 1 0 0 -0.00050897 -7.276e-12 0 38 7.6562 3.273e-09 0.99605 1.3411e-07 0.00014771 5.3849e-06 5440.6 1.764e+05 -1.1176e-08 -0.34046 1.8626e-09 0.97331 229.47 -1.5136 -5.6792e-09 -4.0252e-10 258 2217 0 3.12 0 4.6566e-10 0 1.776e+05 {'F/NAV E5a-I'} {'E01'} 2022 7 5 1 10 0 -0.00050897 -7.276e-12 0 39 7.8125 3.2816e-09 1.0698 1.5087e-07 0.0001477 5.316e-06 5440.6 1.77e+05 -1.6764e-08 -0.34046 0 0.97331 230.16 -1.513 -5.6838e-09 -4.0216e-10 513 2217 0 3.12 0 4.6566e-10 2.3283e-10 1.7766e+05 {'I/NAV E1-B' } {'E01'} 2022 7 5 1 10 0 -0.00050897 -7.2617e-12 0 39 7.8125 3.2816e-09 1.0698 1.5087e-07 0.0001477 5.316e-06 5440.6 1.77e+05 -1.6764e-08 -0.34046 0 0.97331 230.16 -1.513 -5.6838e-09 -4.0216e-10 258 2217 0 3.12 0 4.6566e-10 0 1.777e+05 {'F/NAV E5a-I'} {'E01'} 2022 7 5 1 20 0 -0.00050898 -7.276e-12 0 40 8.0938 3.2894e-09 1.1435 1.7695e-07 0.00014769 5.2489e-06 5440.6 1.776e+05 -2.2352e-08 -0.34047 -3.7253e-09 0.97331 230.84 -1.5123 -5.6881e-09 -4.0109e-10 513 2217 0 3.12 0 4.6566e-10 2.3283e-10 1.7826e+05 {'I/NAV E1-B' } {'E01'} 2022 7 5 1 20 0 -0.00050897 -7.2617e-12 0 40 8.0938 3.2894e-09 1.1435 1.7695e-07 0.00014769 5.2489e-06 5440.6 1.776e+05 -2.2352e-08 -0.34047 -3.7253e-09 0.97331 230.84 -1.5123 -5.6881e-09 -4.0109e-10 258 2217 0 3.12 0 4.6566e-10 0 1.783e+05 {'F/NAV E5a-I'} {'E01'} 2022 7 5 1 30 0 -0.00050898 -7.276e-12 0 41 8.4688 3.2973e-09 1.2173 2.142e-07 0.00014767 5.1856e-06 5440.6 1.782e+05 -2.6077e-08 -0.34047 -7.4506e-09 0.97331 231.47 -1.5117 -5.6924e-09 -4.0037e-10 513 2217 0 3.12 0 4.6566e-10 2.3283e-10 1.7886e+05 {'I/NAV E1-B' } {'E01'} 2022 7 5 1 30 0 -0.00050898 -7.2617e-12 0 41 8.4688 3.2973e-09 1.2173 2.142e-07 0.00014767 5.1856e-06 5440.6 1.782e+05 -2.6077e-08 -0.34047 -7.4506e-09 0.97331 231.47 -1.5117 -5.6924e-09 -4.0037e-10 258 2217 0 3.12 0 4.6566e-10 0 1.789e+05 {'F/NAV E5a-I'} {'E01'} 2022 7 5 1 40 0 -0.00050898 -7.276e-12 0 42 8.9375 3.3051e-09 1.291 2.5891e-07 0.00014764 5.1297e-06 5440.6 1.788e+05 -3.1665e-08 -0.34047 -1.3039e-08 0.97331 232.09 -1.511 -5.6977e-09 -3.9895e-10 513 2217 0 3.12 0 4.6566e-10 2.3283e-10 1.7946e+05 {'I/NAV E1-B' } {'E01'} 2022 7 5 1 40 0 -0.00050898 -7.276e-12 0 42 8.9375 3.3051e-09 1.291 2.5891e-07 0.00014764 5.1297e-06 5440.6 1.788e+05 -3.1665e-08 -0.34047 -1.3039e-08 0.97331 232.09 -1.511 -5.6977e-09 -3.9895e-10 258 2217 0 3.12 0 4.6566e-10 0 1.795e+05 {'F/NAV E5a-I'} {'E01'} 2022 7 5 1 50 0 -0.00050899 -7.276e-12 0 43 9.5312 3.3134e-09 1.3647 3.1292e-07 0.00014761 5.0794e-06 5440.6 1.794e+05 -3.3528e-08 -0.34048 -2.2352e-08 0.97331 232.66 -1.5103 -5.7035e-09 -3.968e-10 513 2217 0 3.12 0 4.6566e-10 2.3283e-10 1.8006e+05 {'I/NAV E1-B' } {'E01'} 2022 7 5 1 50 0 -0.00050899 -7.2617e-12 0 43 9.5312 3.3134e-09 1.3647 3.1292e-07 0.00014761 5.0794e-06 5440.6 1.794e+05 -3.3528e-08 -0.34048 -2.2352e-08 0.97331 232.66 -1.5103 -5.7035e-09 -3.968e-10 258 2217 0 3.12 0 4.6566e-10 0 1.801e+05 {'F/NAV E5a-I'}
t60(25:30,:) % highlighting some rows with varying final column content
ans = 6×36 table
SAT YEAR MO DY HR MN SS BIAS [s] DRIFT [s/s] RATE [s/s^2] IODnav [-] CRS [m] Delta n [rad/s] M0 [rad] CUC [rad] E [-] CUS [rad] A^1/2 [m^1/2] TOE [s] CIC [rad] OMEGA0 [rad] CIS [rad] I0 [rad] CRC [m] omega [rad] OMEGA DOT [rad/s] IDOT [rad/s] Data Sources [-] GAL week [#] - SISA [m] SV Health [-] BGD E5a/E1 [s] BGD E5b/E1 [s] TIME MSG [s] Message Type _______ ____ __ __ __ __ __ ___________ ___________ ____________ __________ _______ _______________ ________ __________ __________ __________ _____________ _________ ___________ ____________ ___________ ________ _______ ___________ _________________ ____________ ________________ ____________ _ ________ _____________ ______________ ______________ ____________ _________________________________ {'E01'} 2022 7 5 2 40 0 -0.00050901 -7.276e-12 0 48 13.469 3.3548e-09 1.7336 6.4075e-07 0.00014731 4.977e-06 5440.6 1.824e+05 -1.1176e-08 -0.3405 -8.1956e-08 0.97331 233.88 -1.5073 -5.7435e-09 -3.7216e-10 517 2217 0 3.12 0 4.6566e-10 2.3283e-10 1.8306e+05 {'I/NAV E1-B I/NAV E5b-I merged'} {'E01'} 2022 7 5 2 40 0 -0.00050901 -7.2617e-12 0 48 13.469 3.3548e-09 1.7336 6.4075e-07 0.00014731 4.977e-06 5440.6 1.824e+05 -1.1176e-08 -0.3405 -8.1956e-08 0.97331 233.88 -1.5073 -5.7435e-09 -3.7216e-10 258 2217 0 3.12 0 4.6566e-10 0 1.831e+05 {'F/NAV E5a-I' } {'E01'} 2022 7 5 2 50 0 -0.00050901 -7.276e-12 0 49 14.25 3.3626e-09 1.8074 7.0222e-07 0.00014724 4.9882e-06 5440.6 1.83e+05 5.5879e-09 -0.3405 -9.3132e-08 0.97331 233.75 -1.5068 -5.752e-09 -3.6394e-10 517 2217 0 3.12 0 4.6566e-10 2.3283e-10 1.8366e+05 {'I/NAV E1-B I/NAV E5b-I merged'} {'E01'} 2022 7 5 2 50 0 -0.00050901 -7.276e-12 0 49 14.25 3.3626e-09 1.8074 7.0222e-07 0.00014724 4.9882e-06 5440.6 1.83e+05 5.5879e-09 -0.3405 -9.3132e-08 0.97331 233.75 -1.5068 -5.752e-09 -3.6394e-10 258 2217 0 3.12 0 4.6566e-10 0 1.837e+05 {'F/NAV E5a-I' } {'E01'} 2022 7 5 3 0 0 -0.00050902 -7.2902e-12 0 50 15 3.3701e-09 1.8814 7.5996e-07 0.00014716 5.0049e-06 5440.6 1.836e+05 2.2352e-08 -0.3405 -9.872e-08 0.97331 233.53 -1.5063 -5.7606e-09 -3.543e-10 517 2217 0 3.12 0 4.6566e-10 2.3283e-10 1.8426e+05 {'I/NAV E1-B I/NAV E5b-I merged'} {'E01'} 2022 7 5 3 0 0 -0.00050902 -7.276e-12 0 50 15 3.3701e-09 1.8814 7.5996e-07 0.00014716 5.0049e-06 5440.6 1.836e+05 2.2352e-08 -0.3405 -9.872e-08 0.97331 233.53 -1.5063 -5.7606e-09 -3.543e-10 258 2217 0 3.12 0 4.6566e-10 0 1.843e+05 {'F/NAV E5a-I' }

Más respuestas (0)

Categorías

Más información sobre Tables en Centro de ayuda y File Exchange.

Etiquetas

Preguntada:

Fr Ma
Fr Ma
el 14 de Feb. de 2023

Editada:

Stephen23
Stephen23
el 14 de Feb. de 2023

Community Treasure Hunt

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

Start Hunting!

Translated by