| T O P I C R E V I E W |
| metroid02 |
Posted - 08/02/2017 : 02:16:23 AM
Origin Ver. and Service Release (Select Help-->About Origin): 2017
Operating System: Windows 10
Hi guys I have a question that has been bugging me for quite some time: I need to filter out some specific time slots, the problem is that the data I am getting puts both the date and the time into the same cell, and sadly these values dont come in regular intervals due to which I cannot simply reduce the rows.
So the format of my data is something along these lines:
08/05/2013 20:00:00
08/05/2013 20:05:00
etc.
[dd.mm.yyyy]
And I need to get my hands on just the data given to me during the 10:00 to 14:00 time interval. Typically the data comes in 5 min intervals, but due to occasional shut downs etc. the stream is not constant.
Does someone have any suggestions as to how to get to that data (doing it manually is impossible as I have >1mio values). |
| 3 L A T E S T R E P L I E S (Newest First) |
| greg |
Posted - 08/14/2017 : 12:32:09 PM
There is no need to add another column since you can filter Date+Time directly with a custom formula:
rmod(X,1)>=10/24 && rmod(x,1)<=14/24
or
frac(X)>=10/24 && frac(x)<=14/24
There is no hope!
(But I may be wrong.) |
| metroid02 |
Posted - 08/02/2017 : 07:28:41 AM
Hi Amanda!
Thank you so much for the fast reply. Your solution worked beautifully!
BR |
| AmandaLu |
Posted - 08/02/2017 : 06:46:33 AM
Hi,
Please make sure the data you imported is Date format. Select Format: Column to open Column Properties dialog. Set
Format = Date
Display = 8/2/2017 HH:mm:ss
Then you can use “frac()” function to extract the time part. Set column format to Time to display time data correctly.
Now you can add a filter to time column to show data between 10:00 and 14:00.
Thanks,
Amanda
OriginLab Technical Service
|
