MATLAB Answers

Sorting cell array by date

128 views (last 30 days)
HaDu
HaDu on 29 Jul 2017
Edited: Jan on 9 Aug 2017
Hi everybody,
i have cell array, which includes a specific column with dates (dd.mm.yyyy_HH:mm:ss). I want to sort the whole array by this dates. Can anybody help me out?
Matlab R2016a
  2 Comments
HaDu
HaDu on 29 Jul 2017
I hope that helps. I want the 2nd column of the cell array named GivenData sorted by dates
edit: the whole array should be sorted by the dates in the 2nd column

Sign in to comment.

Accepted Answer

Star Strider
Star Strider on 29 Jul 2017
Edited: Jan on 9 Aug 2017
Your data are already sorted:
D = load('sort-by-2nd-column.mat');
Data = D.GivenData;
[dn,idx] = sort(datenum(Data(2:end,2), 'dd.mm.yyyy_hh:MM:ss'), 1, 'ascend');
There is nothing to do.
[EDITED, copied from comment]
% First Row Are Column Labels
Data = D.GivenData(2:end,:);
% First Output Of ‘sort’ Not Necessary, So Not Returned
[~,idx] = sort(datenum(Data(:,2), 'dd.mm.yyyy_hh:MM:ss'), 1, 'ascend');
Data_Sorted = Data(idx,:);
  6 Comments
Jan
Jan on 1 Aug 2017
@Peter Perkins: The original question starts with "i have cell array" and the sorting of the cell array as shown by Star Strider is a direct solution.
Working with tables directly by using readtable is a good idea also, when you have a modern Matlab version and rest of the code does not require the data to be a cell.

Sign in to comment.

More Answers (1)

John BG
John BG on 7 Aug 2017
Edited: John BG on 8 Aug 2017
Hi again HaDu
Solved it:
1.
data format conflict: to have sortrows actually ordering dates, the data containing the time data, has to be class datetime. Your cell does not contain time data in such MATLAB class format. Translating:
A = load('sort-by-2nd-column.mat');
B=A.GivenData
L=B([2:end],1)
for k=1:1:length(L)
L{k}(1,[3 6])='-';L{k}(1,11)=' ';
end
B([2:end],1)=L
L=B([2:end],2)
for k=1:1:length(L)
L{k}(1,[3 6])='-';L{k}(1,11)=' ';
end
B([2:end],2)=L
ZeitString1=B([2:end],1)
ZeitString2=B([2:end],2)
t1=datetime(ZeitString1,'InputFormat','dd-MM-yyyy HH:mm:ss')
t2=datetime(ZeitString2,'InputFormat','dd-MM-yyyy HH:mm:ss')
2.
translating to table requires the name of the rows to meet MATLAB variables rules:
varNames2=B(1,:)
varNames2{8}='Teil_Bez'
varNames2{10}='Rezeptur_Bez'
3.
building the table this way
T3=table(t1,t2,B([2:end],3),B([2:end],4),B([2:end],5),B([2:end],6),B([2:end],7),B([2:end],8),B([2:end],9),B([2:end],10),'VariableNames',varNames2)
now it works:
sortrows(T3,'Auftragsbeginn','ascend')
ans =
18×10 table
Auftragsbeginn Auftragsende Auftrag Kavitaet Werkzeug WerkzeugMINUSBez Teil Teil_Bez Rezeptur Rezeptur_Bez
____________________ ____________________ _______ ________ ____________ ___________________________________________________________________________________ ____________ ______________________________________________________ ________ _____________________________________________________________________________________________________________
06-Dec-2016 00:25:56 05-Jan-2017 07:51:53 [65107] [1] [4.0012e+09] 'WkzgMINUSSpulenkoerper_K_250_R_Stamm_Hierfuer_wird_der_Deckel_K_200_R_A_verwendet' [1.0000e+09] 'Spulenkoerper_K_250_R_PA6_anthr.._GV30_MK._PerlonNex' '' 'Rezeptur_1._PA_6_anthrazit_mit_30%_Glasfasern._47.5_%_Industriequalitaet_Weromid._47.5_%_Regranulat_Isonyl.'
05-Jan-2017 07:51:53 18-Jan-2017 07:12:46 [65012] [1] [4.0013e+09] 'WkzgSpulenkoerper_EPA_250_B' [1.0000e+09] 'Spulenkoerper_EPA_250/36_E_PA_6_natur_GV30' '' 'Rezeptur_1._nur_aus_PA_6_natur_mit_30%_Glasfasern'
18-Jan-2017 07:12:46 23-Jan-2017 09:34:20 [65717] [1] [4.0012e+09] 'WkzgMINUSSpulenkoerper_K_250_R_Stamm_Hierfuer_wird_der_Deckel_K_200_R_A_verwendet' [1.0000e+09] 'Spulenkoerper_K_250_R_PA6_anthr.._GV30_MK._PerlonNex' '' 'Rezeptur_1._PA_6_anthrazit_mit_30%_Glasfasern._47.5_%_Industriequalitaet_Weromid._47.5_%_Regranulat_Isonyl.'
23-Jan-2017 09:34:20 20-Feb-2017 08:37:19 [65976] [1] [4.0012e+09] 'WkzgMINUSSpulenkoerper_K_250_R_Stamm_Hierfuer_wird_der_Deckel_K_200_R_A_verwendet' [1.0000e+09] 'Spulenkoerper_K_250_R_PA6_anthr.' '' 'Rezeptur_6._PA_6_anthrazit_mit_30%_Glasfasern._53_%_Industriequalitaet_Weromid._42_%_Regranulat_Isonyl._5_%'
23-Jan-2017 09:34:20 20-Feb-2017 08:37:19 [65976] [1] [4.0012e+09] 'WkzgMINUSSpulenkoerper_K_250_R_Stamm_Hierfuer_wird_der_Deckel_K_200_R_A_verwendet' [1.0000e+09] 'Spulenkoerper_K_250_R_PA6_anthr.._GV30_MK._PerlonNex' '' 'Rezeptur_6._PA_6_anthrazit_mit_30%_Glasfasern._53_%_Industriequalitaet_Weromid._42_%_Regranulat_Isonyl._5_%'
20-Feb-2017 08:37:19 20-Feb-2017 15:29:29 [66216] [1] [4.0013e+09] 'WkzgMINUSSpulenkoerper_MK_200MINUSR' [1.0000e+09] 'Spulenkoerper_MK_200-R_PA_6_GV_anthr.' '' 'Rezeptur_2._PA_6_anthrazit_mit_30%_Glasfasern'
20-Feb-2017 08:37:19 20-Feb-2017 15:29:29 [66216] [1] [4.0012e+09] 'WkzgMINUSSpulenkoerper_MK_200MINUSR' [1.0000e+09] 'Spulenkoerper_MK_200-R_PA_6_GV_anthr.' '' 'Rezeptur_2._PA_6_anthrazit_mit_30%_Glasfasern'
20-Feb-2017 15:29:29 09-Mar-2017 22:50:43 [66337] [1] [4.0012e+09] 'WkzgMINUSSpulenkoerper_MK_200MINUSR' [1.0000e+09] 'Spulenkoerper_MK_200-R_PA_6_GV_anthr.' '' 'Rezeptur_1._PA_6_anthrazit_mit_30%_Glasfasern._Fk._PA-Traeger'
20-Feb-2017 15:29:29 09-Mar-2017 22:50:43 [66337] [1] [4.0012e+09] 'WkzgMINUSSpulenkoerper_MK_200MINUSR' [1.0000e+09] 'Spulenkoerper_MK_200-R_PA_6_GV_anthr.' '' 'Rezeptur_1._PA_6_anthrazit_mit_30%_Glasfasern._Fk._PA-Traeger'
09-Mar-2017 22:50:43 16-Mar-2017 19:04:09 [65900] [1] [4.0013e+09] 'WkzgSpulenkoerper_EPA_250_B' [1.0000e+09] 'Spulenkoerper_EPA_250/22_E_PA_6_natur_GV30' '' 'Rezeptur_1._nur_aus_PA_6_natur_mit_30%_Glasfasern'
09-Mar-2017 22:50:43 17-Mar-2017 00:59:33 [65900] [1] [4.0013e+09] 'WkzgSpulenkoerper_EPA_250_B' [1.0000e+09] 'Spulenkoerper_EPA_250/22_E_PA_6_natur_GV30' '' 'Rezeptur_1._nur_aus_PA_6_natur_mit_30%_Glasfasern'
17-Mar-2017 00:59:33 21-Mar-2017 08:03:13 [66217] [1] [4.0012e+09] 'WkzgMINUSSpulenkoerper_K_250_R_Stamm_Hierfuer_wird_der_Deckel_K_200_R_A_verwendet' [1.0000e+09] 'Spulenkoerper_K_250_R_PA6_anthr.._GV30_MK._PerlonNex' '' 'Rezeptur_6._PA_6_anthrazit_mit_30%_Glasfasern._53_%_Industriequalitaet_Weromid._42_%_Regranulat_Isonyl._5_%'
21-Mar-2017 08:03:13 21-Mar-2017 17:58:55 [66520] [1] [4.0012e+09] 'WkzgMINUSSpulenkoerper_K_250_R_Stamm_Hierfuer_wird_der_Deckel_K_200_R_A_verwendet' [1.0000e+09] 'Spulenkoerper_K_250_R_PA6_anthr.._GV30_MK._PerlonNex' '' 'Rezeptur_1_nur_aus_PP_anthrazit_Compound_mit_30%_Glasfaser'
21-Mar-2017 17:58:55 03-Apr-2017 06:55:23 [66217] [1] [4.0012e+09] 'WkzgMINUSSpulenkoerper_K_250_R_Stamm_Hierfuer_wird_der_Deckel_K_200_R_A_verwendet' [1.0000e+09] 'Spulenkoerper_K_250_R_PA6_anthr.._GV30_MK._PerlonNex' '' 'Rezeptur_6._PA_6_anthrazit_mit_30%_Glasfasern._53_%_Industriequalitaet_Weromid._42_%_Regranulat_Isonyl._5_%'
03-Apr-2017 06:55:23 20-Apr-2017 12:58:12 [65595] [1] [4.0012e+09] 'WkzgMINUSSpulenkoerper_K_250_R_Stamm_Hierfuer_wird_der_Deckel_K_200_R_A_verwendet' [1.0000e+09] 'Spulenkoerper_K_250_R_PA_6_GV_anthr._._Mk._Monosuis' '' 'Rezeptur_1._PA6_GF_30_Akromid_B3'
20-Apr-2017 12:58:12 02-May-2017 11:33:19 [66816] [1] [4.0012e+09] 'WkzgMINUSSpulenkoerper_K_250_R_Stamm_Hierfuer_wird_der_Deckel_K_200_R_A_verwendet' [1.0000e+09] 'Spulenkoerper_K_250_R_PA6_anthr.._GV30_MK._PerlonNex' '' 'Rezeptur_6._PA_6_anthrazit_mit_30%_Glasfasern._53_%_Industriequalitaet_Weromid._42_%_Regranulat_Isonyl._5_%'
02-May-2017 11:33:19 09-May-2017 06:48:54 [66729] [1] [4.0012e+09] 'WkzgMINUSSpulenkoerper_K_250_R_Stamm_Hierfuer_wird_der_Deckel_K_200_R_A_verwendet' [1.0000e+09] 'Spulenkoerper_K_250_R_PA_6_GV_anthr._._Mk._monosuis' '' 'Rezeptur_1._PA_6_anthrazit_mit_30%_Glasfasern._Fk._PA-Traeger'
09-May-2017 06:48:54 22-May-2017 04:28:52 [67090] [1] [4.0012e+09] 'WkzgMINUSSpulenkoerper_K_250_R_Stamm_Hierfuer_wird_der_Deckel_K_200_R_A_verwendet' [1.0000e+09] 'Spulenkoerper_K_250_R_PA6_anthr.._GV30_MK._PerlonNex' '' 'Rezeptur_1._PA_6_anthrazit_mit_30%_Glasfasern._47.5_%_Industriequalitaet_Weromid._47.5_%_Regranulat_Isonyl.'
>> sortrows(T3,'Auftragsbeginn','descend')
ans =
18×10 table
Auftragsbeginn Auftragsende Auftrag Kavitaet Werkzeug WerkzeugMINUSBez Teil Teil_Bez Rezeptur Rezeptur_Bez
____________________ ____________________ _______ ________ ____________ ___________________________________________________________________________________ ____________ ______________________________________________________ ________ _____________________________________________________________________________________________________________
09-May-2017 06:48:54 22-May-2017 04:28:52 [67090] [1] [4.0012e+09] 'WkzgMINUSSpulenkoerper_K_250_R_Stamm_Hierfuer_wird_der_Deckel_K_200_R_A_verwendet' [1.0000e+09] 'Spulenkoerper_K_250_R_PA6_anthr.._GV30_MK._PerlonNex' '' 'Rezeptur_1._PA_6_anthrazit_mit_30%_Glasfasern._47.5_%_Industriequalitaet_Weromid._47.5_%_Regranulat_Isonyl.'
02-May-2017 11:33:19 09-May-2017 06:48:54 [66729] [1] [4.0012e+09] 'WkzgMINUSSpulenkoerper_K_250_R_Stamm_Hierfuer_wird_der_Deckel_K_200_R_A_verwendet' [1.0000e+09] 'Spulenkoerper_K_250_R_PA_6_GV_anthr._._Mk._monosuis' '' 'Rezeptur_1._PA_6_anthrazit_mit_30%_Glasfasern._Fk._PA-Traeger'
20-Apr-2017 12:58:12 02-May-2017 11:33:19 [66816] [1] [4.0012e+09] 'WkzgMINUSSpulenkoerper_K_250_R_Stamm_Hierfuer_wird_der_Deckel_K_200_R_A_verwendet' [1.0000e+09] 'Spulenkoerper_K_250_R_PA6_anthr.._GV30_MK._PerlonNex' '' 'Rezeptur_6._PA_6_anthrazit_mit_30%_Glasfasern._53_%_Industriequalitaet_Weromid._42_%_Regranulat_Isonyl._5_%'
03-Apr-2017 06:55:23 20-Apr-2017 12:58:12 [65595] [1] [4.0012e+09] 'WkzgMINUSSpulenkoerper_K_250_R_Stamm_Hierfuer_wird_der_Deckel_K_200_R_A_verwendet' [1.0000e+09] 'Spulenkoerper_K_250_R_PA_6_GV_anthr._._Mk._Monosuis' '' 'Rezeptur_1._PA6_GF_30_Akromid_B3'
21-Mar-2017 17:58:55 03-Apr-2017 06:55:23 [66217] [1] [4.0012e+09] 'WkzgMINUSSpulenkoerper_K_250_R_Stamm_Hierfuer_wird_der_Deckel_K_200_R_A_verwendet' [1.0000e+09] 'Spulenkoerper_K_250_R_PA6_anthr.._GV30_MK._PerlonNex' '' 'Rezeptur_6._PA_6_anthrazit_mit_30%_Glasfasern._53_%_Industriequalitaet_Weromid._42_%_Regranulat_Isonyl._5_%'
21-Mar-2017 08:03:13 21-Mar-2017 17:58:55 [66520] [1] [4.0012e+09] 'WkzgMINUSSpulenkoerper_K_250_R_Stamm_Hierfuer_wird_der_Deckel_K_200_R_A_verwendet' [1.0000e+09] 'Spulenkoerper_K_250_R_PA6_anthr.._GV30_MK._PerlonNex' '' 'Rezeptur_1_nur_aus_PP_anthrazit_Compound_mit_30%_Glasfaser'
17-Mar-2017 00:59:33 21-Mar-2017 08:03:13 [66217] [1] [4.0012e+09] 'WkzgMINUSSpulenkoerper_K_250_R_Stamm_Hierfuer_wird_der_Deckel_K_200_R_A_verwendet' [1.0000e+09] 'Spulenkoerper_K_250_R_PA6_anthr.._GV30_MK._PerlonNex' '' 'Rezeptur_6._PA_6_anthrazit_mit_30%_Glasfasern._53_%_Industriequalitaet_Weromid._42_%_Regranulat_Isonyl._5_%'
09-Mar-2017 22:50:43 16-Mar-2017 19:04:09 [65900] [1] [4.0013e+09] 'WkzgSpulenkoerper_EPA_250_B' [1.0000e+09] 'Spulenkoerper_EPA_250/22_E_PA_6_natur_GV30' '' 'Rezeptur_1._nur_aus_PA_6_natur_mit_30%_Glasfasern'
09-Mar-2017 22:50:43 17-Mar-2017 00:59:33 [65900] [1] [4.0013e+09] 'WkzgSpulenkoerper_EPA_250_B' [1.0000e+09] 'Spulenkoerper_EPA_250/22_E_PA_6_natur_GV30' '' 'Rezeptur_1._nur_aus_PA_6_natur_mit_30%_Glasfasern'
20-Feb-2017 15:29:29 09-Mar-2017 22:50:43 [66337] [1] [4.0012e+09] 'WkzgMINUSSpulenkoerper_MK_200MINUSR' [1.0000e+09] 'Spulenkoerper_MK_200-R_PA_6_GV_anthr.' '' 'Rezeptur_1._PA_6_anthrazit_mit_30%_Glasfasern._Fk._PA-Traeger'
20-Feb-2017 15:29:29 09-Mar-2017 22:50:43 [66337] [1] [4.0012e+09] 'WkzgMINUSSpulenkoerper_MK_200MINUSR' [1.0000e+09] 'Spulenkoerper_MK_200-R_PA_6_GV_anthr.' '' 'Rezeptur_1._PA_6_anthrazit_mit_30%_Glasfasern._Fk._PA-Traeger'
20-Feb-2017 08:37:19 20-Feb-2017 15:29:29 [66216] [1] [4.0013e+09] 'WkzgMINUSSpulenkoerper_MK_200MINUSR' [1.0000e+09] 'Spulenkoerper_MK_200-R_PA_6_GV_anthr.' '' 'Rezeptur_2._PA_6_anthrazit_mit_30%_Glasfasern'
20-Feb-2017 08:37:19 20-Feb-2017 15:29:29 [66216] [1] [4.0012e+09] 'WkzgMINUSSpulenkoerper_MK_200MINUSR' [1.0000e+09] 'Spulenkoerper_MK_200-R_PA_6_GV_anthr.' '' 'Rezeptur_2._PA_6_anthrazit_mit_30%_Glasfasern'
23-Jan-2017 09:34:20 20-Feb-2017 08:37:19 [65976] [1] [4.0012e+09] 'WkzgMINUSSpulenkoerper_K_250_R_Stamm_Hierfuer_wird_der_Deckel_K_200_R_A_verwendet' [1.0000e+09] 'Spulenkoerper_K_250_R_PA6_anthr.' '' 'Rezeptur_6._PA_6_anthrazit_mit_30%_Glasfasern._53_%_Industriequalitaet_Weromid._42_%_Regranulat_Isonyl._5_%'
23-Jan-2017 09:34:20 20-Feb-2017 08:37:19 [65976] [1] [4.0012e+09] 'WkzgMINUSSpulenkoerper_K_250_R_Stamm_Hierfuer_wird_der_Deckel_K_200_R_A_verwendet' [1.0000e+09] 'Spulenkoerper_K_250_R_PA6_anthr.._GV30_MK._PerlonNex' '' 'Rezeptur_6._PA_6_anthrazit_mit_30%_Glasfasern._53_%_Industriequalitaet_Weromid._42_%_Regranulat_Isonyl._5_%'
18-Jan-2017 07:12:46 23-Jan-2017 09:34:20 [65717] [1] [4.0012e+09] 'WkzgMINUSSpulenkoerper_K_250_R_Stamm_Hierfuer_wird_der_Deckel_K_200_R_A_verwendet' [1.0000e+09] 'Spulenkoerper_K_250_R_PA6_anthr.._GV30_MK._PerlonNex' '' 'Rezeptur_1._PA_6_anthrazit_mit_30%_Glasfasern._47.5_%_Industriequalitaet_Weromid._47.5_%_Regranulat_Isonyl.'
05-Jan-2017 07:51:53 18-Jan-2017 07:12:46 [65012] [1] [4.0013e+09] 'WkzgSpulenkoerper_EPA_250_B' [1.0000e+09] 'Spulenkoerper_EPA_250/36_E_PA_6_natur_GV30' '' 'Rezeptur_1._nur_aus_PA_6_natur_mit_30%_Glasfasern'
06-Dec-2016 00:25:56 05-Jan-2017 07:51:53 [65107] [1] [4.0012e+09] 'WkzgMINUSSpulenkoerper_K_250_R_Stamm_Hierfuer_wird_der_Deckel_K_200_R_A_verwendet' [1.0000e+09] 'Spulenkoerper_K_250_R_PA6_anthr.._GV30_MK._PerlonNex' '' 'Rezeptur_1._PA_6_anthrazit_mit_30%_Glasfasern._47.5_%_Industriequalitaet_Weromid._47.5_%_Regranulat_Isonyl.'
>> sortrows(T3,'Auftragsende','ascend')
ans =
18×10 table
Auftragsbeginn Auftragsende Auftrag Kavitaet Werkzeug WerkzeugMINUSBez Teil Teil_Bez Rezeptur Rezeptur_Bez
____________________ ____________________ _______ ________ ____________ ___________________________________________________________________________________ ____________ ______________________________________________________ ________ _____________________________________________________________________________________________________________
06-Dec-2016 00:25:56 05-Jan-2017 07:51:53 [65107] [1] [4.0012e+09] 'WkzgMINUSSpulenkoerper_K_250_R_Stamm_Hierfuer_wird_der_Deckel_K_200_R_A_verwendet' [1.0000e+09] 'Spulenkoerper_K_250_R_PA6_anthr.._GV30_MK._PerlonNex' '' 'Rezeptur_1._PA_6_anthrazit_mit_30%_Glasfasern._47.5_%_Industriequalitaet_Weromid._47.5_%_Regranulat_Isonyl.'
05-Jan-2017 07:51:53 18-Jan-2017 07:12:46 [65012] [1] [4.0013e+09] 'WkzgSpulenkoerper_EPA_250_B' [1.0000e+09] 'Spulenkoerper_EPA_250/36_E_PA_6_natur_GV30' '' 'Rezeptur_1._nur_aus_PA_6_natur_mit_30%_Glasfasern'
18-Jan-2017 07:12:46 23-Jan-2017 09:34:20 [65717] [1] [4.0012e+09] 'WkzgMINUSSpulenkoerper_K_250_R_Stamm_Hierfuer_wird_der_Deckel_K_200_R_A_verwendet' [1.0000e+09] 'Spulenkoerper_K_250_R_PA6_anthr.._GV30_MK._PerlonNex' '' 'Rezeptur_1._PA_6_anthrazit_mit_30%_Glasfasern._47.5_%_Industriequalitaet_Weromid._47.5_%_Regranulat_Isonyl.'
23-Jan-2017 09:34:20 20-Feb-2017 08:37:19 [65976] [1] [4.0012e+09] 'WkzgMINUSSpulenkoerper_K_250_R_Stamm_Hierfuer_wird_der_Deckel_K_200_R_A_verwendet' [1.0000e+09] 'Spulenkoerper_K_250_R_PA6_anthr.' '' 'Rezeptur_6._PA_6_anthrazit_mit_30%_Glasfasern._53_%_Industriequalitaet_Weromid._42_%_Regranulat_Isonyl._5_%'
23-Jan-2017 09:34:20 20-Feb-2017 08:37:19 [65976] [1] [4.0012e+09] 'WkzgMINUSSpulenkoerper_K_250_R_Stamm_Hierfuer_wird_der_Deckel_K_200_R_A_verwendet' [1.0000e+09] 'Spulenkoerper_K_250_R_PA6_anthr.._GV30_MK._PerlonNex' '' 'Rezeptur_6._PA_6_anthrazit_mit_30%_Glasfasern._53_%_Industriequalitaet_Weromid._42_%_Regranulat_Isonyl._5_%'
20-Feb-2017 08:37:19 20-Feb-2017 15:29:29 [66216] [1] [4.0013e+09] 'WkzgMINUSSpulenkoerper_MK_200MINUSR' [1.0000e+09] 'Spulenkoerper_MK_200-R_PA_6_GV_anthr.' '' 'Rezeptur_2._PA_6_anthrazit_mit_30%_Glasfasern'
20-Feb-2017 08:37:19 20-Feb-2017 15:29:29 [66216] [1] [4.0012e+09] 'WkzgMINUSSpulenkoerper_MK_200MINUSR' [1.0000e+09] 'Spulenkoerper_MK_200-R_PA_6_GV_anthr.' '' 'Rezeptur_2._PA_6_anthrazit_mit_30%_Glasfasern'
20-Feb-2017 15:29:29 09-Mar-2017 22:50:43 [66337] [1] [4.0012e+09] 'WkzgMINUSSpulenkoerper_MK_200MINUSR' [1.0000e+09] 'Spulenkoerper_MK_200-R_PA_6_GV_anthr.' '' 'Rezeptur_1._PA_6_anthrazit_mit_30%_Glasfasern._Fk._PA-Traeger'
20-Feb-2017 15:29:29 09-Mar-2017 22:50:43 [66337] [1] [4.0012e+09] 'WkzgMINUSSpulenkoerper_MK_200MINUSR' [1.0000e+09] 'Spulenkoerper_MK_200-R_PA_6_GV_anthr.' '' 'Rezeptur_1._PA_6_anthrazit_mit_30%_Glasfasern._Fk._PA-Traeger'
09-Mar-2017 22:50:43 16-Mar-2017 19:04:09 [65900] [1] [4.0013e+09] 'WkzgSpulenkoerper_EPA_250_B' [1.0000e+09] 'Spulenkoerper_EPA_250/22_E_PA_6_natur_GV30' '' 'Rezeptur_1._nur_aus_PA_6_natur_mit_30%_Glasfasern'
09-Mar-2017 22:50:43 17-Mar-2017 00:59:33 [65900] [1] [4.0013e+09] 'WkzgSpulenkoerper_EPA_250_B' [1.0000e+09] 'Spulenkoerper_EPA_250/22_E_PA_6_natur_GV30' '' 'Rezeptur_1._nur_aus_PA_6_natur_mit_30%_Glasfasern'
17-Mar-2017 00:59:33 21-Mar-2017 08:03:13 [66217] [1] [4.0012e+09] 'WkzgMINUSSpulenkoerper_K_250_R_Stamm_Hierfuer_wird_der_Deckel_K_200_R_A_verwendet' [1.0000e+09] 'Spulenkoerper_K_250_R_PA6_anthr.._GV30_MK._PerlonNex' '' 'Rezeptur_6._PA_6_anthrazit_mit_30%_Glasfasern._53_%_Industriequalitaet_Weromid._42_%_Regranulat_Isonyl._5_%'
21-Mar-2017 08:03:13 21-Mar-2017 17:58:55 [66520] [1] [4.0012e+09] 'WkzgMINUSSpulenkoerper_K_250_R_Stamm_Hierfuer_wird_der_Deckel_K_200_R_A_verwendet' [1.0000e+09] 'Spulenkoerper_K_250_R_PA6_anthr.._GV30_MK._PerlonNex' '' 'Rezeptur_1_nur_aus_PP_anthrazit_Compound_mit_30%_Glasfaser'
21-Mar-2017 17:58:55 03-Apr-2017 06:55:23 [66217] [1] [4.0012e+09] 'WkzgMINUSSpulenkoerper_K_250_R_Stamm_Hierfuer_wird_der_Deckel_K_200_R_A_verwendet' [1.0000e+09] 'Spulenkoerper_K_250_R_PA6_anthr.._GV30_MK._PerlonNex' '' 'Rezeptur_6._PA_6_anthrazit_mit_30%_Glasfasern._53_%_Industriequalitaet_Weromid._42_%_Regranulat_Isonyl._5_%'
03-Apr-2017 06:55:23 20-Apr-2017 12:58:12 [65595] [1] [4.0012e+09] 'WkzgMINUSSpulenkoerper_K_250_R_Stamm_Hierfuer_wird_der_Deckel_K_200_R_A_verwendet' [1.0000e+09] 'Spulenkoerper_K_250_R_PA_6_GV_anthr._._Mk._Monosuis' '' 'Rezeptur_1._PA6_GF_30_Akromid_B3'
20-Apr-2017 12:58:12 02-May-2017 11:33:19 [66816] [1] [4.0012e+09] 'WkzgMINUSSpulenkoerper_K_250_R_Stamm_Hierfuer_wird_der_Deckel_K_200_R_A_verwendet' [1.0000e+09] 'Spulenkoerper_K_250_R_PA6_anthr.._GV30_MK._PerlonNex' '' 'Rezeptur_6._PA_6_anthrazit_mit_30%_Glasfasern._53_%_Industriequalitaet_Weromid._42_%_Regranulat_Isonyl._5_%'
02-May-2017 11:33:19 09-May-2017 06:48:54 [66729] [1] [4.0012e+09] 'WkzgMINUSSpulenkoerper_K_250_R_Stamm_Hierfuer_wird_der_Deckel_K_200_R_A_verwendet' [1.0000e+09] 'Spulenkoerper_K_250_R_PA_6_GV_anthr._._Mk._monosuis' '' 'Rezeptur_1._PA_6_anthrazit_mit_30%_Glasfasern._Fk._PA-Traeger'
09-May-2017 06:48:54 22-May-2017 04:28:52 [67090] [1] [4.0012e+09] 'WkzgMINUSSpulenkoerper_K_250_R_Stamm_Hierfuer_wird_der_Deckel_K_200_R_A_verwendet' [1.0000e+09] 'Spulenkoerper_K_250_R_PA6_anthr.._GV30_MK._PerlonNex' '' 'Rezeptur_1._PA_6_anthrazit_mit_30%_Glasfasern._47.5_%_Industriequalitaet_Weromid._47.5_%_Regranulat_Isonyl.'
>> sortrows(T3,'Auftragsende','descend')
ans =
18×10 table
Auftragsbeginn Auftragsende Auftrag Kavitaet Werkzeug WerkzeugMINUSBez Teil Teil_Bez Rezeptur Rezeptur_Bez
____________________ ____________________ _______ ________ ____________ ___________________________________________________________________________________ ____________ ______________________________________________________ ________ _____________________________________________________________________________________________________________
09-May-2017 06:48:54 22-May-2017 04:28:52 [67090] [1] [4.0012e+09] 'WkzgMINUSSpulenkoerper_K_250_R_Stamm_Hierfuer_wird_der_Deckel_K_200_R_A_verwendet' [1.0000e+09] 'Spulenkoerper_K_250_R_PA6_anthr.._GV30_MK._PerlonNex' '' 'Rezeptur_1._PA_6_anthrazit_mit_30%_Glasfasern._47.5_%_Industriequalitaet_Weromid._47.5_%_Regranulat_Isonyl.'
02-May-2017 11:33:19 09-May-2017 06:48:54 [66729] [1] [4.0012e+09] 'WkzgMINUSSpulenkoerper_K_250_R_Stamm_Hierfuer_wird_der_Deckel_K_200_R_A_verwendet' [1.0000e+09] 'Spulenkoerper_K_250_R_PA_6_GV_anthr._._Mk._monosuis' '' 'Rezeptur_1._PA_6_anthrazit_mit_30%_Glasfasern._Fk._PA-Traeger'
20-Apr-2017 12:58:12 02-May-2017 11:33:19 [66816] [1] [4.0012e+09] 'WkzgMINUSSpulenkoerper_K_250_R_Stamm_Hierfuer_wird_der_Deckel_K_200_R_A_verwendet' [1.0000e+09] 'Spulenkoerper_K_250_R_PA6_anthr.._GV30_MK._PerlonNex' '' 'Rezeptur_6._PA_6_anthrazit_mit_30%_Glasfasern._53_%_Industriequalitaet_Weromid._42_%_Regranulat_Isonyl._5_%'
03-Apr-2017 06:55:23 20-Apr-2017 12:58:12 [65595] [1] [4.0012e+09] 'WkzgMINUSSpulenkoerper_K_250_R_Stamm_Hierfuer_wird_der_Deckel_K_200_R_A_verwendet' [1.0000e+09] 'Spulenkoerper_K_250_R_PA_6_GV_anthr._._Mk._Monosuis' '' 'Rezeptur_1._PA6_GF_30_Akromid_B3'
21-Mar-2017 17:58:55 03-Apr-2017 06:55:23 [66217] [1] [4.0012e+09] 'WkzgMINUSSpulenkoerper_K_250_R_Stamm_Hierfuer_wird_der_Deckel_K_200_R_A_verwendet' [1.0000e+09] 'Spulenkoerper_K_250_R_PA6_anthr.._GV30_MK._PerlonNex' '' 'Rezeptur_6._PA_6_anthrazit_mit_30%_Glasfasern._53_%_Industriequalitaet_Weromid._42_%_Regranulat_Isonyl._5_%'
21-Mar-2017 08:03:13 21-Mar-2017 17:58:55 [66520] [1] [4.0012e+09] 'WkzgMINUSSpulenkoerper_K_250_R_Stamm_Hierfuer_wird_der_Deckel_K_200_R_A_verwendet' [1.0000e+09] 'Spulenkoerper_K_250_R_PA6_anthr.._GV30_MK._PerlonNex' '' 'Rezeptur_1_nur_aus_PP_anthrazit_Compound_mit_30%_Glasfaser'
17-Mar-2017 00:59:33 21-Mar-2017 08:03:13 [66217] [1] [4.0012e+09] 'WkzgMINUSSpulenkoerper_K_250_R_Stamm_Hierfuer_wird_der_Deckel_K_200_R_A_verwendet' [1.0000e+09] 'Spulenkoerper_K_250_R_PA6_anthr.._GV30_MK._PerlonNex' '' 'Rezeptur_6._PA_6_anthrazit_mit_30%_Glasfasern._53_%_Industriequalitaet_Weromid._42_%_Regranulat_Isonyl._5_%'
09-Mar-2017 22:50:43 17-Mar-2017 00:59:33 [65900] [1] [4.0013e+09] 'WkzgSpulenkoerper_EPA_250_B' [1.0000e+09] 'Spulenkoerper_EPA_250/22_E_PA_6_natur_GV30' '' 'Rezeptur_1._nur_aus_PA_6_natur_mit_30%_Glasfasern'
09-Mar-2017 22:50:43 16-Mar-2017 19:04:09 [65900] [1] [4.0013e+09] 'WkzgSpulenkoerper_EPA_250_B' [1.0000e+09] 'Spulenkoerper_EPA_250/22_E_PA_6_natur_GV30' '' 'Rezeptur_1._nur_aus_PA_6_natur_mit_30%_Glasfasern'
20-Feb-2017 15:29:29 09-Mar-2017 22:50:43 [66337] [1] [4.0012e+09] 'WkzgMINUSSpulenkoerper_MK_200MINUSR' [1.0000e+09] 'Spulenkoerper_MK_200-R_PA_6_GV_anthr.' '' 'Rezeptur_1._PA_6_anthrazit_mit_30%_Glasfasern._Fk._PA-Traeger'
20-Feb-2017 15:29:29 09-Mar-2017 22:50:43 [66337] [1] [4.0012e+09] 'WkzgMINUSSpulenkoerper_MK_200MINUSR' [1.0000e+09] 'Spulenkoerper_MK_200-R_PA_6_GV_anthr.' '' 'Rezeptur_1._PA_6_anthrazit_mit_30%_Glasfasern._Fk._PA-Traeger'
20-Feb-2017 08:37:19 20-Feb-2017 15:29:29 [66216] [1] [4.0013e+09] 'WkzgMINUSSpulenkoerper_MK_200MINUSR' [1.0000e+09] 'Spulenkoerper_MK_200-R_PA_6_GV_anthr.' '' 'Rezeptur_2._PA_6_anthrazit_mit_30%_Glasfasern'
20-Feb-2017 08:37:19 20-Feb-2017 15:29:29 [66216] [1] [4.0012e+09] 'WkzgMINUSSpulenkoerper_MK_200MINUSR' [1.0000e+09] 'Spulenkoerper_MK_200-R_PA_6_GV_anthr.' '' 'Rezeptur_2._PA_6_anthrazit_mit_30%_Glasfasern'
23-Jan-2017 09:34:20 20-Feb-2017 08:37:19 [65976] [1] [4.0012e+09] 'WkzgMINUSSpulenkoerper_K_250_R_Stamm_Hierfuer_wird_der_Deckel_K_200_R_A_verwendet' [1.0000e+09] 'Spulenkoerper_K_250_R_PA6_anthr.' '' 'Rezeptur_6._PA_6_anthrazit_mit_30%_Glasfasern._53_%_Industriequalitaet_Weromid._42_%_Regranulat_Isonyl._5_%'
23-Jan-2017 09:34:20 20-Feb-2017 08:37:19 [65976] [1] [4.0012e+09] 'WkzgMINUSSpulenkoerper_K_250_R_Stamm_Hierfuer_wird_der_Deckel_K_200_R_A_verwendet' [1.0000e+09] 'Spulenkoerper_K_250_R_PA6_anthr.._GV30_MK._PerlonNex' '' 'Rezeptur_6._PA_6_anthrazit_mit_30%_Glasfasern._53_%_Industriequalitaet_Weromid._42_%_Regranulat_Isonyl._5_%'
18-Jan-2017 07:12:46 23-Jan-2017 09:34:20 [65717] [1] [4.0012e+09] 'WkzgMINUSSpulenkoerper_K_250_R_Stamm_Hierfuer_wird_der_Deckel_K_200_R_A_verwendet' [1.0000e+09] 'Spulenkoerper_K_250_R_PA6_anthr.._GV30_MK._PerlonNex' '' 'Rezeptur_1._PA_6_anthrazit_mit_30%_Glasfasern._47.5_%_Industriequalitaet_Weromid._47.5_%_Regranulat_Isonyl.'
05-Jan-2017 07:51:53 18-Jan-2017 07:12:46 [65012] [1] [4.0013e+09] 'WkzgSpulenkoerper_EPA_250_B' [1.0000e+09] 'Spulenkoerper_EPA_250/36_E_PA_6_natur_GV30' '' 'Rezeptur_1._nur_aus_PA_6_natur_mit_30%_Glasfasern'
06-Dec-2016 00:25:56 05-Jan-2017 07:51:53 [65107] [1] [4.0012e+09] 'WkzgMINUSSpulenkoerper_K_250_R_Stamm_Hierfuer_wird_der_Deckel_K_200_R_A_verwendet' [1.0000e+09] 'Spulenkoerper_K_250_R_PA6_anthr.._GV30_MK._PerlonNex' '' 'Rezeptur_1._PA_6_anthrazit_mit_30%_Glasfasern._47.5_%_Industriequalitaet_Weromid._47.5_%_Regranulat_Isonyl.'
.
I have appended this correction to the previous answer.
if you find this answer useful would you please be so kind to consider marking this answer as Accepted Answer?
To any other reader, if you find this answer useful please consider clicking on the thumbs-up vote link
thanks in advance
John BG
.
comment:
there's the command array2timetable, that can also be used, but I only had it building a time table with a single time column
varNames=B(1,[3:end])
varNames{6}='Teil_Bez'
varNames{8}='Rezeptur_Bez'
B3=B([2:end],[3:end])
T2=array2timetable(B3,'RowTimes',t1,'VariableNames',varNames)
.
  1 Comment
Jan
Jan on 8 Aug 2017
datetime can convert the strings directly without the need to manipulate the strings with some loops before:
B = A.GivenData(2:end, :);
t1 = datetime(B(:,2), 'Format', 'dd.MM.yyyy_HH:mm:ss');
If there is a good reason to modify the strings, this is easier and faster:
B = A.GivenData(2:end, 1:2);
L = strrep(strrep(B, '.', '-'), '_', ' ');

Sign in to comment.

Community Treasure Hunt

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

Start Hunting!