Finding the time stamp in a time wave

Share icon

Hello,

I am relatively new to Igor use. I am trying to process a large amount of data stored in a file in csv format with a time stamp. So, I am able to load the data using loadwave command into two different waves, one containing the time stamp, and the other is the value of the quantity I am measuring at that time. Now, I want to locate the point closest to my time of interest in the time wave. Could you help me finding the syntax for it? For example:

The time wave looks like: 10:23:34 am, 10:23:38 am, 10:23:42 am. If I want to find the point corresponding to the time 10:23:38 am, what syntax or command do I need to use.

Thank you,
Vikram
Time of day is stored as seconds since midnight.

[ Date/time is stored as seconds since midnight on 1904-01-01. For details, execute:
 DisplayHelpTopic "Date/Time Waves"
]

Here is an example that may help:
// Examples:
//      Demo(10, 23, 38)
//      Demo(10, 23, 40)
Function Demo(hours, minutes, seconds)
    Variable hours, minutes, seconds        // The time of day to search for

    Variable timeOfDayToSearchFor = hours*3600 + minutes*60 + seconds   // Convert to seconds since midnight

    Variable t0 = 10*3600 + 23*60 + 34      // 10:23:34 AM as seconds since midnight
    Variable t1 = 10*3600 + 23*60 + 38      // 10:23:38 AM
    Variable t2 = 10*3600 + 23*60 + 42      // 10:23:42 AM
    Make/O timeOfDayWave = {t0, t1, t2}
   
    FindLevel/P/Q timeOfDayWave, timeOfDayToSearchFor       // Stores fractional point number in V_LevelX
    Printf "Point number is %g\r", V_LevelX
End

May 30, 2018 at 12:43 pm - Permalink