0 개 추천

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
이전 댓글 2개 표시 이전 댓글 2개 숨기기

Stephen23
Stephen23 2023년 2월 14일
@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 2023년 2월 14일
The original file .22p cannot be uploaded beacuse this format is not supported.
Stephen23
Stephen23 2023년 2월 14일
편집: Stephen23 2023년 2월 14일
"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 2023년 2월 14일
Ok, these are the two .txt files.

댓글을 달려면 로그인하십시오.

이 질문에 답변하려면 로그인하십시오.

 채택된 답변

Stephen23
Stephen23 2023년 2월 14일
편집: Stephen23 2023년 2월 14일
Ran in:

0 개 추천

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

추가 답변 (0개)

카테고리

도움말 센터 및 File Exchange에서 Tables에 대해 자세히 알아보기

태그

질문:

Fr Ma
Fr Ma
2023년 2월 14일

편집:

Stephen23
Stephen23
2023년 2월 14일

Community Treasure Hunt

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

Start Hunting!

Translated by