PC Hard- und Software
›
Thread
Temperatur an einem Ort um 17:Uhr ein ganzes Jahr
KR
Kalli R.
Gast
06.01.2022 19:18 #6933905
Hallo Excel-Freaks,
da ich Excel überhaupt nicht kann eine Frage in die Runde.
Habe Wetterdaten (Temeperatur) für ein Jahr in Koblenz als Datei
bekommen.
Ich will aber aus dieser Datei nur eine Uhrzeit (17.00 Uhr) pro Tag über
das ganze Jahr haben, also 365 Temeperatur-Werte jeweils immer unm 17:00
Uhr
Kann mir da einer was basteln. Händisch dauert das ewig.
Beispiel:
OBS_DEU_PT1H_T2M,"2656","1982-01-01T17:00:00","8.1","0","7",
Das wäre also am 1.1.82 um 17 Uhr genau 8,1 Grad Celsius
Hol dir vscode, wähle den Text T17:00:00 aus und drück Strg+Shift+L,
Pos1, Shift+Ende, Strg+C und füge den Inhalt irgendwo ein, wie hier:
1 "OBS_DEU_PT1H_T2M","2656","1982-01-01T17:00:00","8.1","0","7",
2 "OBS_DEU_PT1H_T2M","2656","1982-01-02T17:00:00","7.1","0","7",
3 "OBS_DEU_PT1H_T2M","2656","1982-01-03T17:00:00","10.4","0","7",
4 "OBS_DEU_PT1H_T2M","2656","1982-01-04T17:00:00","11.7","0","7",
5 "OBS_DEU_PT1H_T2M","2656","1982-01-05T17:00:00","9.3","0","7",
6 "OBS_DEU_PT1H_T2M","2656","1982-01-06T17:00:00","-2.9","0","7",
7 "OBS_DEU_PT1H_T2M","2656","1982-01-07T17:00:00","-3.6","0","7",
8 "OBS_DEU_PT1H_T2M","2656","1982-01-08T17:00:00","-5.7","0","7",
9 "OBS_DEU_PT1H_T2M","2656","1982-01-09T17:00:00","-5.8","0","7",
10 "OBS_DEU_PT1H_T2M","2656","1982-01-10T17:00:00","-7.3","0","7",
11 "OBS_DEU_PT1H_T2M","2656","1982-01-11T17:00:00","-5","0","7",
12 "OBS_DEU_PT1H_T2M","2656","1982-01-12T17:00:00","-6.4","0","7",
13 "OBS_DEU_PT1H_T2M","2656","1982-01-13T17:00:00","-9.8","0","7",
14 "OBS_DEU_PT1H_T2M","2656","1982-01-14T17:00:00","-9.1","0","7",
15 "OBS_DEU_PT1H_T2M","2656","1982-01-15T17:00:00","-3","0","7",
16 "OBS_DEU_PT1H_T2M","2656","1982-01-16T17:00:00","0.6","0","7",
17 "OBS_DEU_PT1H_T2M","2656","1982-01-17T17:00:00","-0.7","0","7",
18 "OBS_DEU_PT1H_T2M","2656","1982-01-18T17:00:00","-1.2","0","7",
19 "OBS_DEU_PT1H_T2M","2656","1982-01-19T17:00:00","-0.7","0","7",
20 "OBS_DEU_PT1H_T2M","2656","1982-01-20T17:00:00","-0.6","0","7",
21 "OBS_DEU_PT1H_T2M","2656","1982-01-21T17:00:00","0.2","0","7",
22 "OBS_DEU_PT1H_T2M","2656","1982-01-22T17:00:00","3.6","0","7",
23 "OBS_DEU_PT1H_T2M","2656","1982-01-23T17:00:00","2.5","0","7",
24 "OBS_DEU_PT1H_T2M","2656","1982-01-24T17:00:00","2.7","0","7",
25 "OBS_DEU_PT1H_T2M","2656","1982-01-25T17:00:00","3","0","7",
26 "OBS_DEU_PT1H_T2M","2656","1982-01-26T17:00:00","5.2","0","7",
27 "OBS_DEU_PT1H_T2M","2656","1982-01-27T17:00:00","3.7","0","7",
28 "OBS_DEU_PT1H_T2M","2656","1982-01-28T17:00:00","3.3","0","7",
29 "OBS_DEU_PT1H_T2M","2656","1982-01-29T17:00:00","5.2","0","7",
30 "OBS_DEU_PT1H_T2M","2656","1982-01-30T17:00:00","9.1","0","7",
31 "OBS_DEU_PT1H_T2M","2656","1982-01-31T17:00:00","6.5","0","7",
32 "OBS_DEU_PT1H_T2M","2656","1982-02-01T17:00:00","-0.2","0","7",
33 "OBS_DEU_PT1H_T2M","2656","1982-02-02T17:00:00","3.1","0","7",
34 "OBS_DEU_PT1H_T2M","2656","1982-02-03T17:00:00","1.5","0","7",
35 "OBS_DEU_PT1H_T2M","2656","1982-02-04T17:00:00","3.8","0","7",
36 "OBS_DEU_PT1H_T2M","2656","1982-02-05T17:00:00","4.9","0","7",
37 "OBS_DEU_PT1H_T2M","2656","1982-02-06T17:00:00","7","0","7",
38 "OBS_DEU_PT1H_T2M","2656","1982-02-07T17:00:00","8.8","0","7",
39 "OBS_DEU_PT1H_T2M","2656","1982-02-08T17:00:00","6.2","0","7",
40 "OBS_DEU_PT1H_T2M","2656","1982-02-09T17:00:00","8.3","0","7",
41 "OBS_DEU_PT1H_T2M","2656","1982-02-10T17:00:00","8.3","0","7",
42 "OBS_DEU_PT1H_T2M","2656","1982-02-11T17:00:00","11","0","7",
43 "OBS_DEU_PT1H_T2M","2656","1982-02-12T17:00:00","10.8","0","7",
44 "OBS_DEU_PT1H_T2M","2656","1982-02-13T17:00:00","9.7","0","7",
45 "OBS_DEU_PT1H_T2M","2656","1982-02-14T17:00:00","6","0","7",
46 "OBS_DEU_PT1H_T2M","2656","1982-02-15T17:00:00","5.9","0","7",
47 "OBS_DEU_PT1H_T2M","2656","1982-02-16T17:00:00","2.9","0","7",
48 "OBS_DEU_PT1H_T2M","2656","1982-02-17T17:00:00","3.6","0","7",
49 "OBS_DEU_PT1H_T2M","2656","1982-02-18T17:00:00","5","0","7",
50 "OBS_DEU_PT1H_T2M","2656","1982-02-19T17:00:00","-0.3","0","7",
51 "OBS_DEU_PT1H_T2M","2656","1982-02-20T17:00:00","4.9","0","7",
52 "OBS_DEU_PT1H_T2M","2656","1982-02-21T17:00:00","5.3","0","7",
53 "OBS_DEU_PT1H_T2M","2656","1982-02-22T17:00:00","6.7","0","7",
54 "OBS_DEU_PT1H_T2M","2656","1982-02-23T17:00:00","-0.2","0","7",
55 "OBS_DEU_PT1H_T2M","2656","1982-02-24T17:00:00","0.9","0","7",
56 "OBS_DEU_PT1H_T2M","2656","1982-02-25T17:00:00","0.5","0","7",
57 "OBS_DEU_PT1H_T2M","2656","1982-02-26T17:00:00","4","0","7",
58 "OBS_DEU_PT1H_T2M","2656","1982-02-27T17:00:00","6.1","0","7",
59 "OBS_DEU_PT1H_T2M","2656","1982-02-28T17:00:00","7.6","0","7",
60 "OBS_DEU_PT1H_T2M","2656","1982-03-01T17:00:00","13","0","7",
61 "OBS_DEU_PT1H_T2M","2656","1982-03-02T17:00:00","9","0","7",
62 "OBS_DEU_PT1H_T2M","2656","1982-03-03T17:00:00","12.5","0","7",
63 "OBS_DEU_PT1H_T2M","2656","1982-03-04T17:00:00","8.8","0","7",
64 "OBS_DEU_PT1H_T2M","2656","1982-03-05T17:00:00","4.6","0","7",
65 "OBS_DEU_PT1H_T2M","2656","1982-03-06T17:00:00","7.4","0","7",
66 "OBS_DEU_PT1H_T2M","2656","1982-03-07T17:00:00","7.2","0","7",
67 "OBS_DEU_PT1H_T2M","2656","1982-03-08T17:00:00","10","0","7",
68 "OBS_DEU_PT1H_T2M","2656","1982-03-09T17:00:00","8.6","0","7",
69 "OBS_DEU_PT1H_T2M","2656","1982-03-10T17:00:00","7.8","0","7",
70 "OBS_DEU_PT1H_T2M","2656","1982-03-11T17:00:00","5","0","7",
71 "OBS_DEU_PT1H_T2M","2656","1982-03-12T17:00:00","6.7","0","7",
72 "OBS_DEU_PT1H_T2M","2656","1982-03-13T17:00:00","5.4","0","7",
73 "OBS_DEU_PT1H_T2M","2656","1982-03-14T17:00:00","9.1","0","7",
74 "OBS_DEU_PT1H_T2M","2656","1982-03-15T17:00:00","13.5","0","7",
75 "OBS_DEU_PT1H_T2M","2656","1982-03-16T17:00:00","9.5","0","7",
76 "OBS_DEU_PT1H_T2M","2656","1982-03-17T17:00:00","8.5","0","7",
77 "OBS_DEU_PT1H_T2M","2656","1982-03-18T17:00:00","8.7","0","7",
78 "OBS_DEU_PT1H_T2M","2656","1982-03-19T17:00:00","8.2","0","7",
79 "OBS_DEU_PT1H_T2M","2656","1982-03-20T17:00:00","4.8","0","7",
80 "OBS_DEU_PT1H_T2M","2656","1982-03-21T17:00:00","5.2","0","7",
81 "OBS_DEU_PT1H_T2M","2656","1982-03-22T17:00:00","9.4","0","7",
82 "OBS_DEU_PT1H_T2M","2656","1982-03-23T17:00:00","9.5","0","7",
83 "OBS_DEU_PT1H_T2M","2656","1982-03-24T17:00:00","13.9","0","7",
84 "OBS_DEU_PT1H_T2M","2656","1982-03-25T17:00:00","16.4","0","7",
85 "OBS_DEU_PT1H_T2M","2656","1982-03-26T17:00:00","18","0","7",
86 "OBS_DEU_PT1H_T2M","2656","1982-03-27T17:00:00","19.7","0","7",
87 "OBS_DEU_PT1H_T2M","2656","1982-03-28T17:00:00","14.8","0","7",
88 "OBS_DEU_PT1H_T2M","2656","1982-03-29T17:00:00","8.2","0","7",
89 "OBS_DEU_PT1H_T2M","2656","1982-03-30T17:00:00","7.2","0","7",
90 "OBS_DEU_PT1H_T2M","2656","1982-03-31T17:00:00","10.3","0","7",
91 "OBS_DEU_PT1H_T2M","2656","1982-04-01T17:00:00","17.6","0","7",
92 "OBS_DEU_PT1H_T2M","2656","1982-04-02T17:00:00","14.6","0","7",
93 "OBS_DEU_PT1H_T2M","2656","1982-04-03T17:00:00","15.4","0","7",
94 "OBS_DEU_PT1H_T2M","2656","1982-04-04T17:00:00","16.5","0","7",
95 "OBS_DEU_PT1H_T2M","2656","1982-04-05T17:00:00","19.8","0","7",
96 "OBS_DEU_PT1H_T2M","2656","1982-04-06T17:00:00","13.4","0","7",
97 "OBS_DEU_PT1H_T2M","2656","1982-04-07T17:00:00","14.3","0","7",
98 "OBS_DEU_PT1H_T2M","2656","1982-04-08T17:00:00","4.9","0","7",
99 "OBS_DEU_PT1H_T2M","2656","1982-04-09T17:00:00","5.3","0","7",
100 "OBS_DEU_PT1H_T2M","2656","1982-04-10T17:00:00","8","0","7",
101 "OBS_DEU_PT1H_T2M","2656","1982-04-11T17:00:00","7","0","7",
102 "OBS_DEU_PT1H_T2M","2656","1982-04-12T17:00:00","2.5","0","7",
103 "OBS_DEU_PT1H_T2M","2656","1982-04-13T17:00:00","6.9","0","7",
104 "OBS_DEU_PT1H_T2M","2656","1982-04-14T17:00:00","10.9","0","7",
105 "OBS_DEU_PT1H_T2M","2656","1982-04-15T17:00:00","14.7","0","7",
106 "OBS_DEU_PT1H_T2M","2656","1982-04-16T17:00:00","18","0","7",
107 "OBS_DEU_PT1H_T2M","2656","1982-04-17T17:00:00","13.5","0","7",
108 "OBS_DEU_PT1H_T2M","2656","1982-04-18T17:00:00","14.8","0","7",
109 "OBS_DEU_PT1H_T2M","2656","1982-04-19T17:00:00","15.7","0","7",
110 "OBS_DEU_PT1H_T2M","2656","1982-04-20T17:00:00","15.5","0","7",
111 "OBS_DEU_PT1H_T2M","2656","1982-04-21T17:00:00","14.8","0","7",
112 "OBS_DEU_PT1H_T2M","2656","1982-04-22T17:00:00","16.9","0","7",
113 "OBS_DEU_PT1H_T2M","2656","1982-04-23T17:00:00","14.9","0","7",
114 "OBS_DEU_PT1H_T2M","2656","1982-04-24T17:00:00","9.9","0","7",
115 "OBS_DEU_PT1H_T2M","2656","1982-04-25T17:00:00","15.3","0","7",
116 "OBS_DEU_PT1H_T2M","2656","1982-04-26T17:00:00","13.1","0","7",
117 "OBS_DEU_PT1H_T2M","2656","1982-04-27T17:00:00","13.4","0","7",
118 "OBS_DEU_PT1H_T2M","2656","1982-04-28T17:00:00","11.9","0","7",
119 "OBS_DEU_PT1H_T2M","2656","1982-04-29T17:00:00","7","0","7",
120 "OBS_DEU_PT1H_T2M","2656","1982-04-30T17:00:00","10.2","0","7",
121 "OBS_DEU_PT1H_T2M","2656","1982-05-01T17:00:00","12","0","7",
122 "OBS_DEU_PT1H_T2M","2656","1982-05-02T17:00:00","12.6","0","7",
123 "OBS_DEU_PT1H_T2M","2656","1982-05-03T17:00:00","15.8","0","7",
124 "OBS_DEU_PT1H_T2M","2656","1982-05-04T17:00:00","14","0","7",
125 "OBS_DEU_PT1H_T2M","2656","1982-05-05T17:00:00","8.2","0","7",
126 "OBS_DEU_PT1H_T2M","2656","1982-05-06T17:00:00","15.1","0","7",
127 "OBS_DEU_PT1H_T2M","2656","1982-05-07T17:00:00","10.9","0","7",
128 "OBS_DEU_PT1H_T2M","2656","1982-05-08T17:00:00","15.2","0","7",
129 "OBS_DEU_PT1H_T2M","2656","1982-05-09T17:00:00","12.9","0","7",
130 "OBS_DEU_PT1H_T2M","2656","1982-05-10T17:00:00","14","0","7",
131 "OBS_DEU_PT1H_T2M","2656","1982-05-11T17:00:00","18.8","0","7",
132 "OBS_DEU_PT1H_T2M","2656","1982-05-12T17:00:00","20.1","0","7",
133 "OBS_DEU_PT1H_T2M","2656","1982-05-13T17:00:00","23.8","0","7",
134 "OBS_DEU_PT1H_T2M","2656","1982-05-14T17:00:00","25","0","7",
135 "OBS_DEU_PT1H_T2M","2656","1982-05-15T17:00:00","26.5","0","7",
136 "OBS_DEU_PT1H_T2M","2656","1982-05-16T17:00:00","23","0","7",
137 "OBS_DEU_PT1H_T2M","2656","1982-05-17T17:00:00","19.9","0","7",
138 "OBS_DEU_PT1H_T2M","2656","1982-05-18T17:00:00","17.4","0","7",
139 "OBS_DEU_PT1H_T2M","2656","1982-05-19T17:00:00","22","0","7",
140 "OBS_DEU_PT1H_T2M","2656","1982-05-20T17:00:00","16.3","0","7",
141 "OBS_DEU_PT1H_T2M","2656","1982-05-21T17:00:00","21.2","0","7",
142 "OBS_DEU_PT1H_T2M","2656","1982-05-22T17:00:00","17.2","0","7",
143 "OBS_DEU_PT1H_T2M","2656","1982-05-23T17:00:00","15.3","0","7",
144 "OBS_DEU_PT1H_T2M","2656","1982-05-24T17:00:00","17.4","0","7",
145 "OBS_DEU_PT1H_T2M","2656","1982-05-25T17:00:00","21.8","0","7",
146 "OBS_DEU_PT1H_T2M","2656","1982-05-26T17:00:00","26.5","0","7",
147 "OBS_DEU_PT1H_T2M","2656","1982-05-27T17:00:00","27","0","7",
148 "OBS_DEU_PT1H_T2M","2656","1982-05-28T17:00:00","18.7","0","7",
149 "OBS_DEU_PT1H_T2M","2656","1982-05-29T17:00:00","21.5","0","7",
150 "OBS_DEU_PT1H_T2M","2656","1982-05-30T17:00:00","24","0","7",
151 "OBS_DEU_PT1H_T2M","2656","1982-05-31T17:00:00","26.7","0","7",
152 "OBS_DEU_PT1H_T2M","2656","1982-06-01T17:00:00","30","0","7",
153 "OBS_DEU_PT1H_T2M","2656","1982-06-02T17:00:00","31","0","7",
154 "OBS_DEU_PT1H_T2M","2656","1982-06-03T17:00:00","31.7","0","7",
155 "OBS_DEU_PT1H_T2M","2656","1982-06-04T17:00:00","32.5","0","7",
156 "OBS_DEU_PT1H_T2M","2656","1982-06-05T17:00:00","21.3","0","7",
157 "OBS_DEU_PT1H_T2M","2656","1982-06-06T17:00:00","21.8","0","7",
158 "OBS_DEU_PT1H_T2M","2656","1982-06-07T17:00:00","20.7","0","7",
159 "OBS_DEU_PT1H_T2M","2656","1982-06-08T17:00:00","19.6","0","7",
160 "OBS_DEU_PT1H_T2M","2656","1982-06-09T17:00:00","23.8","0","7",
161 "OBS_DEU_PT1H_T2M","2656","1982-06-10T17:00:00","26.2","0","7",
162 "OBS_DEU_PT1H_T2M","2656","1982-06-11T17:00:00","17.3","0","7",
163 "OBS_DEU_PT1H_T2M","2656","1982-06-12T17:00:00","16.1","0","7",
164 "OBS_DEU_PT1H_T2M","2656","1982-06-13T17:00:00","13.8","0","7",
165 "OBS_DEU_PT1H_T2M","2656","1982-06-14T17:00:00","14.8","0","7",
166 "OBS_DEU_PT1H_T2M","2656","1982-06-15T17:00:00","17.3","0","7",
167 "OBS_DEU_PT1H_T2M","2656","1982-06-16T17:00:00","18.5","0","7",
168 "OBS_DEU_PT1H_T2M","2656","1982-06-17T17:00:00","20.8","0","7",
169 "OBS_DEU_PT1H_T2M","2656","1982-06-18T17:00:00","19","0","7",
170 "OBS_DEU_PT1H_T2M","2656","1982-06-19T17:00:00","16","0","7",
171 "OBS_DEU_PT1H_T2M","2656","1982-06-20T17:00:00","21.2","0","7",
172 "OBS_DEU_PT1H_T2M","2656","1982-06-21T17:00:00","22.5","0","7",
173 "OBS_DEU_PT1H_T2M","2656","1982-06-22T17:00:00","20.9","0","7",
174 "OBS_DEU_PT1H_T2M","2656","1982-06-23T17:00:00","18.9","0","7",
175 "OBS_DEU_PT1H_T2M","2656","1982-06-24T17:00:00","19.8","0","7",
176 "OBS_DEU_PT1H_T2M","2656","1982-06-25T17:00:00","23.6","0","7",
177 "OBS_DEU_PT1H_T2M","2656","1982-06-26T17:00:00","23","0","7",
178 "OBS_DEU_PT1H_T2M","2656","1982-06-27T17:00:00","19","0","7",
179 "OBS_DEU_PT1H_T2M","2656","1982-06-28T17:00:00","19.6","0","7",
180 "OBS_DEU_PT1H_T2M","2656","1982-06-29T17:00:00","14.7","0","7",
181 "OBS_DEU_PT1H_T2M","2656","1982-06-30T17:00:00","20.2","0","7",
182 "OBS_DEU_PT1H_T2M","2656","1982-07-01T17:00:00","18.8","0","7",
183 "OBS_DEU_PT1H_T2M","2656","1982-07-02T17:00:00","27.6","0","7",
184 "OBS_DEU_PT1H_T2M","2656","1982-07-03T17:00:00","21.7","0","7",
185 "OBS_DEU_PT1H_T2M","2656","1982-07-04T17:00:00","19.7","0","7",
186 "OBS_DEU_PT1H_T2M","2656","1982-07-05T17:00:00","22.3","0","7",
187 "OBS_DEU_PT1H_T2M","2656","1982-07-06T17:00:00","21.8","0","7",
188 "OBS_DEU_PT1H_T2M","2656","1982-07-07T17:00:00","24.2","0","7",
189 "OBS_DEU_PT1H_T2M","2656","1982-07-08T17:00:00","29.1","0","7",
190 "OBS_DEU_PT1H_T2M","2656","1982-07-09T17:00:00","32.6","0","7",
191 "OBS_DEU_PT1H_T2M","2656","1982-07-10T17:00:00","27.7","0","7",
192 "OBS_DEU_PT1H_T2M","2656","1982-07-11T17:00:00","30.6","0","7",
193 "OBS_DEU_PT1H_T2M","2656","1982-07-12T17:00:00","30.9","0","7",
194 "OBS_DEU_PT1H_T2M","2656","1982-07-13T17:00:00","30.2","0","7",
195 "OBS_DEU_PT1H_T2M","2656","1982-07-14T17:00:00","31.3","0","7",
196 "OBS_DEU_PT1H_T2M","2656","1982-07-15T17:00:00","29.5","0","7",
197 "OBS_DEU_PT1H_T2M","2656","1982-07-16T17:00:00","26.6","0","7",
198 "OBS_DEU_PT1H_T2M","2656","1982-07-17T17:00:00","24.5","0","7",
199 "OBS_DEU_PT1H_T2M","2656","1982-07-18T17:00:00","26.3","0","7",
200 "OBS_DEU_PT1H_T2M","2656","1982-07-19T17:00:00","25.1","0","7",
201 "OBS_DEU_PT1H_T2M","2656","1982-07-20T17:00:00","30.2","0","7",
202 "OBS_DEU_PT1H_T2M","2656","1982-07-21T17:00:00","20","0","7",
203 "OBS_DEU_PT1H_T2M","2656","1982-07-22T17:00:00","19.1","0","7",
204 "OBS_DEU_PT1H_T2M","2656","1982-07-23T17:00:00","21.5","0","7",
205 "OBS_DEU_PT1H_T2M","2656","1982-07-24T17:00:00","20.7","0","7",
206 "OBS_DEU_PT1H_T2M","2656","1982-07-25T17:00:00","18.2","0","7",
207 "OBS_DEU_PT1H_T2M","2656","1982-07-26T17:00:00","18.3","0","7",
208 "OBS_DEU_PT1H_T2M","2656","1982-07-27T17:00:00","18","0","7",
209 "OBS_DEU_PT1H_T2M","2656","1982-07-28T17:00:00","17","0","7",
210 "OBS_DEU_PT1H_T2M","2656","1982-07-29T17:00:00","27.2","0","7",
211 "OBS_DEU_PT1H_T2M","2656","1982-07-30T17:00:00","28.5","0","7",
212 "OBS_DEU_PT1H_T2M","2656","1982-07-31T17:00:00","21.2","0","7",
213 "OBS_DEU_PT1H_T2M","2656","1982-08-01T17:00:00","24.3","0","7",
214 "OBS_DEU_PT1H_T2M","2656","1982-08-02T17:00:00","28.8","0","7",
215 "OBS_DEU_PT1H_T2M","2656","1982-08-03T17:00:00","24.5","0","7",
216 "OBS_DEU_PT1H_T2M","2656","1982-08-04T17:00:00","25","0","7",
217 "OBS_DEU_PT1H_T2M","2656","1982-08-05T17:00:00","22","0","7",
218 "OBS_DEU_PT1H_T2M","2656","1982-08-06T17:00:00","26.4","0","7",
219 "OBS_DEU_PT1H_T2M","2656","1982-08-07T17:00:00","20.7","0","7",
220 "OBS_DEU_PT1H_T2M","2656","1982-08-08T17:00:00","20.3","0","7",
221 "OBS_DEU_PT1H_T2M","2656","1982-08-09T17:00:00","21.8","0","7",
222 "OBS_DEU_PT1H_T2M","2656","1982-08-10T17:00:00","20.7","0","7",
223 "OBS_DEU_PT1H_T2M","2656","1982-08-11T17:00:00","26.7","0","7",
224 "OBS_DEU_PT1H_T2M","2656","1982-08-12T17:00:00","31","0","7",
225 "OBS_DEU_PT1H_T2M","2656","1982-08-13T17:00:00","23.2","0","7",
226 "OBS_DEU_PT1H_T2M","2656","1982-08-14T17:00:00","23.8","0","7",
227 "OBS_DEU_PT1H_T2M","2656","1982-08-15T17:00:00","24.9","0","7",
228 "OBS_DEU_PT1H_T2M","2656","1982-08-16T17:00:00","26.2","0","7",
229 "OBS_DEU_PT1H_T2M","2656","1982-08-17T17:00:00","22.4","0","7",
230 "OBS_DEU_PT1H_T2M","2656","1982-08-18T17:00:00","25.9","0","7",
231 "OBS_DEU_PT1H_T2M","2656","1982-08-19T17:00:00","21.3","0","7",
232 "OBS_DEU_PT1H_T2M","2656","1982-08-20T17:00:00","16","0","7",
233 "OBS_DEU_PT1H_T2M","2656","1982-08-21T17:00:00","18","0","7",
234 "OBS_DEU_PT1H_T2M","2656","1982-08-22T17:00:00","20.1","0","7",
235 "OBS_DEU_PT1H_T2M","2656","1982-08-23T17:00:00","21.8","0","7",
236 "OBS_DEU_PT1H_T2M","2656","1982-08-24T17:00:00","19.8","0","7",
237 "OBS_DEU_PT1H_T2M","2656","1982-08-25T17:00:00","22.1","0","7",
238 "OBS_DEU_PT1H_T2M","2656","1982-08-26T17:00:00","24","0","7",
239 "OBS_DEU_PT1H_T2M","2656","1982-08-27T17:00:00","21.9","0","7",
240 "OBS_DEU_PT1H_T2M","2656","1982-08-28T17:00:00","21.2","0","7",
241 "OBS_DEU_PT1H_T2M","2656","1982-08-29T17:00:00","23.9","0","7",
242 "OBS_DEU_PT1H_T2M","2656","1982-08-30T17:00:00","24.6","0","7",
243 "OBS_DEU_PT1H_T2M","2656","1982-08-31T17:00:00","19.4","0","7",
244 "OBS_DEU_PT1H_T2M","2656","1982-09-01T17:00:00","19.7","0","7",
245 "OBS_DEU_PT1H_T2M","2656","1982-09-02T17:00:00","20.2","0","7",
246 "OBS_DEU_PT1H_T2M","2656","1982-09-03T17:00:00","23.3","0","7",
247 "OBS_DEU_PT1H_T2M","2656","1982-09-04T17:00:00","27","0","7",
248 "OBS_DEU_PT1H_T2M","2656","1982-09-05T17:00:00","28.8","0","7",
249 "OBS_DEU_PT1H_T2M","2656","1982-09-06T17:00:00","20.1","0","7",
250 "OBS_DEU_PT1H_T2M","2656","1982-09-07T17:00:00","20.5","0","7",
251 "OBS_DEU_PT1H_T2M","2656","1982-09-08T17:00:00","22.2","0","7",
252 "OBS_DEU_PT1H_T2M","2656","1982-09-09T17:00:00","24.2","0","7",
253 "OBS_DEU_PT1H_T2M","2656","1982-09-10T17:00:00","26.7","0","7",
254 "OBS_DEU_PT1H_T2M","2656","1982-09-11T17:00:00","25","0","7",
255 "OBS_DEU_PT1H_T2M","2656","1982-09-12T17:00:00","25.9","0","7",
256 "OBS_DEU_PT1H_T2M","2656","1982-09-13T17:00:00","20.5","0","7",
257 "OBS_DEU_PT1H_T2M","2656","1982-09-14T17:00:00","26.5","0","7",
258 "OBS_DEU_PT1H_T2M","2656","1982-09-15T17:00:00","27.6","0","7",
259 "OBS_DEU_PT1H_T2M","2656","1982-09-16T17:00:00","27.5","0","7",
260 "OBS_DEU_PT1H_T2M","2656","1982-09-17T17:00:00","29","0","7",
261 "OBS_DEU_PT1H_T2M","2656","1982-09-18T17:00:00","23.2","0","7",
262 "OBS_DEU_PT1H_T2M","2656","1982-09-19T17:00:00","26.2","0","7",
263 "OBS_DEU_PT1H_T2M","2656","1982-09-20T17:00:00","20","0","7",
264 "OBS_DEU_PT1H_T2M","2656","1982-09-21T17:00:00","22.9","0","7",
265 "OBS_DEU_PT1H_T2M","2656","1982-09-22T17:00:00","17.2","0","7",
266 "OBS_DEU_PT1H_T2M","2656","1982-09-23T17:00:00","15.5","0","7",
267 "OBS_DEU_PT1H_T2M","2656","1982-09-24T17:00:00","19.4","0","7",
268 "OBS_DEU_PT1H_T2M","2656","1982-09-25T17:00:00","21.8","0","7",
269 "OBS_DEU_PT1H_T2M","2656","1982-09-26T17:00:00","15.1","0","7",
270 "OBS_DEU_PT1H_T2M","2656","1982-09-27T17:00:00","19.4","0","7",
271 "OBS_DEU_PT1H_T2M","2656","1982-09-28T17:00:00","21","0","7",
272 "OBS_DEU_PT1H_T2M","2656","1982-09-29T17:00:00","22","0","7",
273 "OBS_DEU_PT1H_T2M","2656","1982-09-30T17:00:00","16.9","0","7",
274 "OBS_DEU_PT1H_T2M","2656","1982-10-01T17:00:00","15.3","0","7",
275 "OBS_DEU_PT1H_T2M","2656","1982-10-02T17:00:00","16.8","0","7",
276 "OBS_DEU_PT1H_T2M","2656","1982-10-03T17:00:00","17.4","0","7",
277 "OBS_DEU_PT1H_T2M","2656","1982-10-04T17:00:00","15.8","0","7",
278 "OBS_DEU_PT1H_T2M","2656","1982-10-05T17:00:00","14.3","0","7",
279 "OBS_DEU_PT1H_T2M","2656","1982-10-06T17:00:00","14","0","7",
280 "OBS_DEU_PT1H_T2M","2656","1982-10-07T17:00:00","11.9","0","7",
281 "OBS_DEU_PT1H_T2M","2656","1982-10-08T17:00:00","12.5","0","7",
282 "OBS_DEU_PT1H_T2M","2656","1982-10-09T17:00:00","12.6","0","7",
283 "OBS_DEU_PT1H_T2M","2656","1982-10-10T17:00:00","12.2","0","7",
284 "OBS_DEU_PT1H_T2M","2656","1982-10-11T17:00:00","11.6","0","7",
285 "OBS_DEU_PT1H_T2M","2656","1982-10-12T17:00:00","11.7","0","7",
286 "OBS_DEU_PT1H_T2M","2656","1982-10-13T17:00:00","13.2","0","7",
287 "OBS_DEU_PT1H_T2M","2656","1982-10-14T17:00:00","11.6","0","7",
288 "OBS_DEU_PT1H_T2M","2656","1982-10-15T17:00:00","11.7","0","7",
289 "OBS_DEU_PT1H_T2M","2656","1982-10-16T17:00:00","10.5","0","7",
290 "OBS_DEU_PT1H_T2M","2656","1982-10-17T17:00:00","12.8","0","7",
291 "OBS_DEU_PT1H_T2M","2656","1982-10-18T17:00:00","13.7","0","7",
292 "OBS_DEU_PT1H_T2M","2656","1982-10-19T17:00:00","14.5","0","7",
293 "OBS_DEU_PT1H_T2M","2656","1982-10-20T17:00:00","15.8","0","7",
294 "OBS_DEU_PT1H_T2M","2656","1982-10-21T17:00:00","13.7","0","7",
295 "OBS_DEU_PT1H_T2M","2656","1982-10-22T17:00:00","11.7","0","7",
296 "OBS_DEU_PT1H_T2M","2656","1982-10-23T17:00:00","11.2","0","7",
297 "OBS_DEU_PT1H_T2M","2656","1982-10-24T17:00:00","11.3","0","7",
298 "OBS_DEU_PT1H_T2M","2656","1982-10-25T17:00:00","9.6","0","7",
299 "OBS_DEU_PT1H_T2M","2656","1982-10-26T17:00:00","12.9","0","7",
300 "OBS_DEU_PT1H_T2M","2656","1982-10-27T17:00:00","14.7","0","7",
301 "OBS_DEU_PT1H_T2M","2656","1982-10-28T17:00:00","15","0","7",
302 "OBS_DEU_PT1H_T2M","2656","1982-10-29T17:00:00","9.8","0","7",
303 "OBS_DEU_PT1H_T2M","2656","1982-10-30T17:00:00","8.6","0","7",
304 "OBS_DEU_PT1H_T2M","2656","1982-10-31T17:00:00","10.4","0","7",
305 "OBS_DEU_PT1H_T2M","2656","1982-11-01T17:00:00","14.3","0","7",
306 "OBS_DEU_PT1H_T2M","2656","1982-11-02T17:00:00","14.1","0","7",
307 "OBS_DEU_PT1H_T2M","2656","1982-11-03T17:00:00","11.2","0","7",
308 "OBS_DEU_PT1H_T2M","2656","1982-11-04T17:00:00","10.6","0","7",
309 "OBS_DEU_PT1H_T2M","2656","1982-11-05T17:00:00","10.8","0","7",
310 "OBS_DEU_PT1H_T2M","2656","1982-11-06T17:00:00","6.8","0","7",
311 "OBS_DEU_PT1H_T2M","2656","1982-11-07T17:00:00","8.2","0","7",
312 "OBS_DEU_PT1H_T2M","2656","1982-11-08T17:00:00","13.5","0","7",
313 "OBS_DEU_PT1H_T2M","2656","1982-11-09T17:00:00","13.6","0","7",
314 "OBS_DEU_PT1H_T2M","2656","1982-11-10T17:00:00","12.4","0","7",
315 "OBS_DEU_PT1H_T2M","2656","1982-11-11T17:00:00","12.7","0","7",
316 "OBS_DEU_PT1H_T2M","2656","1982-11-12T17:00:00","12.3","0","7",
317 "OBS_DEU_PT1H_T2M","2656","1982-11-13T17:00:00","8.1","0","7",
318 "OBS_DEU_PT1H_T2M","2656","1982-11-14T17:00:00","6.4","0","7",
319 "OBS_DEU_PT1H_T2M","2656","1982-11-15T17:00:00","5.3","0","7",
320 "OBS_DEU_PT1H_T2M","2656","1982-11-16T17:00:00","5.1","0","7",
321 "OBS_DEU_PT1H_T2M","2656","1982-11-17T17:00:00","7","0","7",
322 "OBS_DEU_PT1H_T2M","2656","1982-11-18T17:00:00","12.2","0","7",
323 "OBS_DEU_PT1H_T2M","2656","1982-11-19T17:00:00","9.1","0","7",
324 "OBS_DEU_PT1H_T2M","2656","1982-11-20T17:00:00","8.5","0","7",
325 "OBS_DEU_PT1H_T2M","2656","1982-11-21T17:00:00","7","0","7",
326 "OBS_DEU_PT1H_T2M","2656","1982-11-22T17:00:00","8.2","0","7",
327 "OBS_DEU_PT1H_T2M","2656","1982-11-23T17:00:00","13.9","0","7",
328 "OBS_DEU_PT1H_T2M","2656","1982-11-24T17:00:00","9.4","0","7",
329 "OBS_DEU_PT1H_T2M","2656","1982-11-25T17:00:00","10.3","0","7",
330 "OBS_DEU_PT1H_T2M","2656","1982-11-26T17:00:00","8","0","7",
331 "OBS_DEU_PT1H_T2M","2656","1982-11-27T17:00:00","7.3","0","7",
332 "OBS_DEU_PT1H_T2M","2656","1982-11-28T17:00:00","4.9","0","7",
333 "OBS_DEU_PT1H_T2M","2656","1982-11-29T17:00:00","3.1","0","7",
334 "OBS_DEU_PT1H_T2M","2656","1982-11-30T17:00:00","3","0","7",
335 "OBS_DEU_PT1H_T2M","2656","1982-12-01T17:00:00","2.8","0","7",
336 "OBS_DEU_PT1H_T2M","2656","1982-12-02T17:00:00","3.5","0","7",
337 "OBS_DEU_PT1H_T2M","2656","1982-12-03T17:00:00","4.6","0","7",
338 "OBS_DEU_PT1H_T2M","2656","1982-12-04T17:00:00","3.9","0","7",
339 "OBS_DEU_PT1H_T2M","2656","1982-12-05T17:00:00","3","0","7",
340 "OBS_DEU_PT1H_T2M","2656","1982-12-06T17:00:00","6.6","0","7",
341 "OBS_DEU_PT1H_T2M","2656","1982-12-07T17:00:00","6.9","0","7",
342 "OBS_DEU_PT1H_T2M","2656","1982-12-08T17:00:00","9.6","0","7",
343 "OBS_DEU_PT1H_T2M","2656","1982-12-09T17:00:00","8.1","0","7",
344 "OBS_DEU_PT1H_T2M","2656","1982-12-10T17:00:00","6.7","0","7",
345 "OBS_DEU_PT1H_T2M","2656","1982-12-11T17:00:00","6","0","7",
346 "OBS_DEU_PT1H_T2M","2656","1982-12-12T17:00:00","2.4","0","7",
347 "OBS_DEU_PT1H_T2M","2656","1982-12-13T17:00:00","4.3","0","7",
348 "OBS_DEU_PT1H_T2M","2656","1982-12-14T17:00:00","1.6","0","7",
349 "OBS_DEU_PT1H_T2M","2656","1982-12-15T17:00:00","9.7","0","7",
350 "OBS_DEU_PT1H_T2M","2656","1982-12-16T17:00:00","7.5","0","7",
351 "OBS_DEU_PT1H_T2M","2656","1982-12-17T17:00:00","4.3","0","7",
352 "OBS_DEU_PT1H_T2M","2656","1982-12-18T17:00:00","3","0","7",
353 "OBS_DEU_PT1H_T2M","2656","1982-12-19T17:00:00","2","0","7",
354 "OBS_DEU_PT1H_T2M","2656","1982-12-20T17:00:00","5.7","0","7",
355 "OBS_DEU_PT1H_T2M","2656","1982-12-21T17:00:00","6.2","0","7",
356 "OBS_DEU_PT1H_T2M","2656","1982-12-22T17:00:00","4.7","0","7",
357 "OBS_DEU_PT1H_T2M","2656","1982-12-23T17:00:00","1.7","0","7",
358 "OBS_DEU_PT1H_T2M","2656","1982-12-24T17:00:00","1.5","0","7",
359 "OBS_DEU_PT1H_T2M","2656","1982-12-25T17:00:00","3.4","0","7",
360 "OBS_DEU_PT1H_T2M","2656","1982-12-26T17:00:00","5.7","0","7",
361 "OBS_DEU_PT1H_T2M","2656","1982-12-27T17:00:00","8.3","0","7",
362 "OBS_DEU_PT1H_T2M","2656","1982-12-28T17:00:00","6.1","0","7",
363 "OBS_DEU_PT1H_T2M","2656","1982-12-29T17:00:00","2.8","0","7",
364 "OBS_DEU_PT1H_T2M","2656","1982-12-30T17:00:00","3.2","0","7",
365 "OBS_DEU_PT1H_T2M","2656","1982-12-31T17:00:00","-1.6","0","7",
So, und jezt macht wegen der Länge ein paar Anfeindungen :D
KR
Kalli R.
Gast
06.01.2022 19:33 #6933923
hatte leider die falsche Datei eingefügt. Das ist jetzt die richtige.
Die zweite mit den 543 KB
Vom 16.9.1982 -16.9.1983
sorry !
Gings nochmal Chris?
Kalli R. schrieb: > sorry !
> Gings nochmal Chris?
Probiers mal selber:
https://code.visualstudio.com/
ohne Installation: https://vscode.dev/
KR
Kalli R.
Gast
06.01.2022 19:48 #6933936
Chris R. schrieb: > Hol dir vscode, wähle den Text T17:00:00 aus und drück Strg+Shift+L,
> Pos1, Shift+Ende, Strg+C und füge den Inhalt irgendwo ein, wie hier:
>
>Habs hinbekommen !!!!
Super!! Danke !!!!
MM
Michael M.
(michael_metzer)
(Firma: Autotronic)
06.01.2022 19:52 #6933941
Chris R. schrieb: > So, und jezt macht wegen der Länge ein paar Anfeindungen :D
Krass!
In 10 Minuten (von 19:18 Uhr bis 19:28 Uhr) ist die Arbeit schon
erledigt, die eigentlich ewig dauern würde. 👍
Ist das Lokalzeit?
Dann wirst du ein Problem mit der Sommerzeit haben.
Michael M. schrieb: > In 10 Minuten (von 19:18 Uhr bis 19:28 Uhr) ist die Arbeit schon
> erledigt, die eigentlich ewig dauern würde. 👍
Dabei habe ich den Post erst um 19:25 gelesen ;)
Q
quotendepp
Gast
06.01.2022 21:13 #6934004
Kalli R. schrieb: > Händisch dauert das ewig.
1 grep T17 input.csv > output.csv
geht nicht?
AS
Achim S.
Gast
06.01.2022 21:35 #6934021
Tja, jetzt hast du es eh schon gelöst.
Wenn du die Daten ohnehin in Excel hast wäre mein Ansatz gewesen:
- Filter auf die Spalte mit den Zeitstempeln
- alle auswählen, die auf 17:00:00 enden
- die selektierten Werte kopieren und anderswo weiterverwenden...
KR
Kalli R.
Gast
07.01.2022 12:30 #6934570
Hi Achim,
danke für deine Hilfe, aber allein schon an dieser kleinen Aufgabe
scheitere ich schon, da ich die Befehle ,die du beschrieben hast nicht
umsetzen kann. Excel ist eben ein totaler blinder Fleck von mir. Sorry
AS
Achim S.
Gast
07.01.2022 15:08 #6934801
Kalli R. schrieb: > danke für deine Hilfe, aber allein schon an dieser kleinen Aufgabe
> scheitere ich schon, da ich die Befehle ,die du beschrieben hast nicht
> umsetzen kann. Excel ist eben ein totaler blinder Fleck von mir. Sorry
Wenn du probieren willst, das mit den Bordmitteln von Exceln
nachzuvollziehen, dann hier mal der Versuch einer Schritt für Schritt
Anleitung. Die Zahlen im Text beziehen sich auf die Bilder bzw. die
Markierungen in den Bildern.
Das csv in Excel öffnen/importieren. Dabei darauf achten, dass
1 das richtige Trennzeichen ausgewählt wird und dass
2 für Spalten ein "ungefährlicher" Datentyp ausgewählt wird. (Mit dem
Datentyp "Standard" kann es sonst leicht dazu kommen, dass eine
Temperatur 16.8 (Grad) als Datum (1. August) interpretiert wird.)
Links oben auf den Zeilenstart klicken (3A), um die ganz Zeile zu
markieren. Dann im Menue Daten den Befehl Filtern auswählen (3B).
Den Filter für die Zeitstempel-Spalte anwählen (4A), die passende
Filtermaske eingeben (4B) und bestätigen (4C).
Damit werden dir nur nch die gewünschten Daten angezeigt. Die am Block
markieren, mit Ctrl-C kopieren, und z.B. wieder neu als csv-Datei
speichern (und dabei diverse Warnungen wegklicken). Das Ergebnis findest
du im letzten Anhang dieses Beitrags.
EL
eigentlich linuxxer
Gast
07.01.2022 15:39 #6934847
quotendepp schrieb: > Kalli R. schrieb:
>> Händisch dauert das ewig.
> grep T17 input.csv > output.csv
> geht nicht?
grep ist Linux, in Windows: findstr
↑ Nach oben← Zurück zu PC Hard- und Software
Antwort schreiben
