Forum: PC Hard- und Software Temperatur an einem Ort um 17:Uhr ein ganzes Jahr


Temperatur an einem Ort um 17:Uhr ein ganzes Jahr
von Kalli R. (Gast)

Angehängte Dateien:
Lesenswert?
• ▲
▼ 
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

Beitrag melden Bearbeiten Thread verschieben Thread sperren Anmeldepflicht aktivieren Anpinnen Thread löschen Thread mit anderem zusammenführen Markierten Text zitieren Antwort Antwort mit Zitat
Re: Temperatur an einem Ort um 17:Uhr ein ganzes Jahr
von Chris R. (hownottobeseen)

Lesenswert?
• ▲
▼ 
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

: Bearbeitet durch User
Beitrag melden Bearbeiten Löschen Markierten Text zitieren Antwort Antwort mit Zitat
Re: Temperatur an einem Ort um 17:Uhr ein ganzes Jahr
von Kalli R. (Gast)

Angehängte Dateien:
Lesenswert?
• ▲
▼ 
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?

Beitrag melden Bearbeiten Löschen Markierten Text zitieren Antwort Antwort mit Zitat
Re: Temperatur an einem Ort um 17:Uhr ein ganzes Jahr
von Chris R. (hownottobeseen)

Lesenswert?
• ▲
▼ 
Kalli R. schrieb:
> sorry !
> Gings nochmal Chris?

Probiers mal selber:

https://code.visualstudio.com/

ohne Installation: https://vscode.dev/

Beitrag melden Bearbeiten Löschen Markierten Text zitieren Antwort Antwort mit Zitat
Re: Temperatur an einem Ort um 17:Uhr ein ganzes Jahr
von Kalli R. (Gast)

Lesenswert?
• ▲
▼ 
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 !!!!

Beitrag melden Bearbeiten Löschen Markierten Text zitieren Antwort Antwort mit Zitat
Re: Temperatur an einem Ort um 17:Uhr ein ganzes Jahr
von Michael M. (Firma: Autotronic) (michael_metzer)

Lesenswert?
• ▲
▼ 
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. 👍

Beitrag melden Bearbeiten Löschen Markierten Text zitieren Antwort Antwort mit Zitat
Re: Temperatur an einem Ort um 17:Uhr ein ganzes Jahr
von Dirk B. (dirkb2)

Lesenswert?
• ▲
▼ 
Ist das Lokalzeit?
Dann wirst du ein Problem mit der Sommerzeit haben.

Beitrag melden Bearbeiten Löschen Markierten Text zitieren Antwort Antwort mit Zitat
Re: Temperatur an einem Ort um 17:Uhr ein ganzes Jahr
von Chris R. (hownottobeseen)

Lesenswert?
• ▲
▼ 
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 ;)

Beitrag melden Bearbeiten Löschen Markierten Text zitieren Antwort Antwort mit Zitat
Re: Temperatur an einem Ort um 17:Uhr ein ganzes Jahr
von quotendepp (Gast)

Lesenswert?
• ▲
▼ 
Kalli R. schrieb:
> Händisch dauert das ewig.

1
grep T17 input.csv > output.csv

 geht nicht?

Beitrag melden Bearbeiten Löschen Markierten Text zitieren Antwort Antwort mit Zitat
Re: Temperatur an einem Ort um 17:Uhr ein ganzes Jahr
von Achim S. (Gast)

Angehängte Dateien:
Lesenswert?
• ▲
▼ 
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...

Beitrag melden Bearbeiten Löschen Markierten Text zitieren Antwort Antwort mit Zitat
Re: Temperatur an einem Ort um 17:Uhr ein ganzes Jahr
von Kalli R. (Gast)

Lesenswert?
• ▲
▼ 
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

Beitrag melden Bearbeiten Löschen Markierten Text zitieren Antwort Antwort mit Zitat
Re: Temperatur an einem Ort um 17:Uhr ein ganzes Jahr
von Achim S. (Gast)

Angehängte Dateien:
Lesenswert?
• ▲
▼ 
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.

Beitrag melden Bearbeiten Löschen Markierten Text zitieren Antwort Antwort mit Zitat
Re: Temperatur an einem Ort um 17:Uhr ein ganzes Jahr
von eigentlich linuxxer (Gast)

Lesenswert?
• ▲
▼ 
quotendepp schrieb:
> Kalli R. schrieb:
>> Händisch dauert das ewig.
> grep T17 input.csv > output.csv
>  geht nicht?

grep ist Linux, in Windows: findstr

Beitrag melden Bearbeiten Löschen Markierten Text zitieren Antwort Antwort mit Zitat
Thread beobachten | Seitenaufteilung abschalten
Bitte melde dich an um einen Beitrag zu schreiben. Anmeldung ist kostenlos und dauert nur eine Minute.
Bestehender Account
Schon ein Account bei Google/GoogleMail? Keine Anmeldung erforderlich!
Mit Google-Account einloggen
Noch kein Account? Hier anmelden.