How To Fix Logic Analyzer CSV File Times

AMCE52_FTP015_1_20nsHome Page

Are you having trouble dealing with the  “Time” column in the CSV file that you exported from an Agilent logic analyzer?  Even with gigabytes of data, the batch file below corrects all the times in a few seconds.  Pun not intended.  The corrected file will have all those original times in seconds, as just a number, with the engineering units removed.  The “Times” header will change to “Seconds”.   The data in the other columns is not changed.

Agilent Technologies was spun off from the Hewlett Packard Company in 1999.  The division that makes logic analyzers was spun off from Agilent Technologies and became Keysight Technologies in 2014.

Files with a CSV extension are comma-separated value database files.

The  “Time” column in those CSV files is originally formatted with engineering units in seconds, milliseconds, microseconds and nanoseconds.  Some examples of those times are

-8.388608 ms

-999.446 us

-374 ns

0 s

626 ns

999.344 us

830.453038 ms

9.876543210 s

Spreadsheet applications cannot deal with these to do time math, sort  by time, plot graphs, etc.  Here is the latest fix, updated on 2015/6/12:

InSeconds

How to use the batch file link above

  1. First, click on, copy and paste the text of the text file above into an empty  text-editor window such as Notepad.
  2. Save that text by the name “InSeconds.bat” into the folder containing your CSV files.  You could optionally save it into the Binary Filters’ SR folder.
  3. After that, you need to use this link to install the Binary Filters on your computer.
  4. Close any Command Prompt windows that you had opened prior to the installation in step 3.
  5. Now, open a fresh Command Prompt window (aka CMD or COMMAND) to activate the new path to those binary filters.
  6. Use the CD command to Change the active Directory to the folder with your CSV files.
  7. Type the command “InSeconds FileName.CSV”, changing FileName to the name of your CSV file.
  8. Type “EXIT” when you are done using the Command Prompt window.

The Result

Your directory will now have a new file named “InSeconds.csv“.  Rename it before running the batch file again.

InSeconds.csv can now be sorted by time as a spreadsheet or as text, plus time math became possible.  All times will include a decimal-point followed by 9 digits.  Spreadsheet programs will recognize all times as floating-point numbers.

Known Limitations

  • The “Time” must be the first column of data.
  • Time engineering units must use all lower-case.
  • Non-zero picoseconds are not handled.
  • The input file may not be named tmp.csv.

– Gareth B. Dolby

Top

Home Page

29 thoughts on “How To Fix Logic Analyzer CSV File Times”

  1. hi!,I love your writing very a lot! percentage we be in contact extra about your article on AOL? I need a specialist on this area to solve my problem. Maybe that is you! Taking a look forward to see you.

  2. There are some interesting points in time in this article but I don?t know if I see all of them center to heart. There is some validity but I will take hold opinion until I look into it further. Good article , thanks and we want more! Added to FeedBurner as well

  3. The very crux of your writing whilst sounding reasonable in the beginning, did not really sit properly with me after some time. Somewhere within the sentences you managed to make me a believer unfortunately only for a short while. I nevertheless have got a problem with your leaps in logic and one would do nicely to help fill in those breaks. In the event that you can accomplish that, I could undoubtedly be amazed.

  4. Wonderful blog! I found it while surfing around on Yahoo News. Do you have any suggestions on how to get listed in Yahoo News? I’ve been trying for a while but I never seem to get there! Thank you

  5. Thank you for the sensible critique. Me and my neighbor were just preparing to do some research on this. We got a grab a book from our local library but I think I learned more from this post. I’m very glad to see such excellent info being shared freely out there.

Leave a Reply

Your email address will not be published. Required fields are marked *