Hourly data

[liawsiqin@gmail]

Hi All

Would appreciate if i could get help on this subject. In the file below i have data every 5 mins. However, I wish to separate the data such that i have hourly data, i.e. take out every row whose time ends with a 00, like 7:00 and 8:00 etc. As it is in the format of time, i can't retain just the last 2 digits and separate from there...could anyone help please?

[6StringJazzer]

The solution depends on how you will use the data after you get it to look the way you want, and if this is a one-time process or if you will do this over and over.

Attached is a very quick solution which adds an extra column that extracts the minutes portion from the time. Then you can filter for all rows having minutes of 0.

If you actually need to remove those, you can do the opposite filter, then delete everything showing.

If you need a more flexible and automated solution, such as if you have to do this over and over again for more sets of data, then a different approach might work better.

[liawsiqin@gmail]

this would work well....thankss!!