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.
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
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:
How to use the batch file link above
- First, click on, copy and paste the text of the text file above into an empty text-editor window such as Notepad.
- 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.
- After that, you need to use this link to install the Binary Filters on your computer.
- Close any Command Prompt windows that you had opened prior to the installation in step 3.
- Now, open a fresh Command Prompt window (aka CMD or COMMAND) to activate the new path to those binary filters.
- Use the CD command to Change the active Directory to the folder with your CSV files.
- Type the command “InSeconds FileName.CSV”, changing FileName to the name of your CSV file.
- Type “EXIT” when you are done using the Command Prompt window.
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.
- 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