Date time format in delimited text files
Tue, 05/04/2021 - 09:41 am
Working with a data file from a mil-std-1553 databus monitor application, Alta View. The files are saved as binary files, .cdp extension, but can also be exported to .csv files. Sample of some data from a .csv file is below.
My main challenge time and date formatting. The timestamp is formatted using the year in brackets, julian date in parentheses, followed by system time.
The files can be set to output the data words in hex or decimal, but date/time format doesn't seem to have any other options.
Going back to my request from a few years ago;
I'm not sure how much things have changed since Igor 6. The date-time format from those files was a lot different as well.
The format is [year](julian day)hh:mm:ss.ss.??? Not sure what the "extra" decimals are on the ends of the time
TimeStamp TimeHigh TimeLow(20nsLSB) IMGap(100nsLSB) CMD1 DATA01
(236)19:35:11.981.685.000 0x0073BBFE 0xDB6BBEDA 0x00000107 0xDCA0 0xF7E3
Some sequential timestamp data: