readtable fail to import .22p file

14 Feb 2023
1 Answer
Answer Accepted
Updated 14 Feb 2023
2 Views (30 days)

0 votes

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 Comments
Show 2 older comments Hide 2 older comments

Stephen23
Stephen23 on 14 Feb 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 on 14 Feb 2023
The original file .22p cannot be uploaded beacuse this format is not supported.
Stephen23
Stephen23 on 14 Feb 2023
Edited: Stephen23 on 14 Feb 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 on 14 Feb 2023
Ok, these are the two .txt files.

Sign in to comment.

Sign in to answer this question.

 Accepted Answer

Stephen23
Stephen23 on 14 Feb 2023
Edited: Stephen23 on 14 Feb 2023
Ran in:

0 votes

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' }

More Answers (0)

Categories

Find more on Standard File Formats in Help Center and File Exchange

Tags

Asked:

Fr Ma
Fr Ma
on 14 Feb 2023

Edited:

Stephen23
Stephen23
on 14 Feb 2023

Community Treasure Hunt

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

Start Hunting!