| T O P I C R E V I E W |
| fabif |
Posted - 04/15/2013 : 11:02:07 AM
My ASCII Files are using the format DDD:hh:mm:ss.
I want to split this IRIG Format and copy the DDD in a new column and a new format like dd.mm.yyyy (e.g. 06/12/1998).
Someone an idea?
Thanks in advance!
Origin Ver. and Service Release (Select Help-->About Origin): 8G
Operating System: Windows 7 |
| 5 L A T E S T R E P L I E S (Newest First) |
| YimingChen |
Posted - 05/17/2023 : 09:37:23 AM
As the date is simply the integer part of the time value. You may just take the real modulus of the time divided by 1. See below:
James |
| abhishek.khare |
Posted - 05/17/2023 : 12:58:00 AM
Thank you Chen, much appreciated.
Another question, if I may ask, how to remove day number from
the IRIG time and have only hh:mm:ss.##?
quote:
Originally posted by YimingChen
You can multiply the IRIG time value by 24*60*60.
quote:
Originally posted by abhishek.khare
Hello there,
I have similar question.
How can I convert IRIG time to seconds?
Thank you in advance.
Regards
Abhishek
|
| YimingChen |
Posted - 05/16/2023 : 10:44:06 AM
You can multiply the IRIG time value by 24*60*60.
quote:
Originally posted by abhishek.khare
Hello there,
I have similar question.
How can I convert IRIG time to seconds?
Thank you in advance.
Regards
Abhishek
|
| abhishek.khare |
Posted - 05/16/2023 : 09:20:26 AM
Hello there,
I have similar question.
How can I convert IRIG time to seconds?
Thank you in advance.
Regards
Abhishek |
| greg |
Posted - 04/15/2013 : 12:11:47 PM
IRIG is a relative Time format, meaning there is no Date information and the underlying data stores Day information as the integer part and time of day as the fractional part as in:
3.1415926535898 = 3days, 3 hours, 23 minutes and 53.605270158 seconds
Given columns that are set as Time or Date, you can freely add Time columns to each other and still get 'time' values and you can freely add a Date and a Time column and still get date values. (Just don't add Date columns!)
So if you fill a column with one particular date and have set that as a Date column, then you can just add your IRIG column to your Date column to make all your IRIG values relative to that Date. |
