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:
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.
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
Magnificent goods from you, man. I have understand your stuff prior to and you are simply extremely wonderful.
Just wish to say your article is as surprising. The clearness on your publish is
simply cool and i could assume you’re knowledgeable in this
subject. Fine with your permission let me to grasp
your RSS feed to stay up to date with imminent post.
Thank you one million and please keep up the gratifying work.
My spouse and I stumbled over here coming from a different page and thought I may as well check things out. I like what I see so now i’m following you. Look forward to looking over your web page for a second time.
I have changed my spam filter, because I have not seen any comments since installing the former filter. Post your comment, now.
Admin:
Gareth
I just want to say I am just new to weblog and really savored this blog site. More than likely I’m planning to bookmark your blog post . You actually have terrific posts. Thanks a lot for revealing your blog site.
You have brought up a very excellent points , thankyou for the post.
I just found your website on second page of serach engine, your website is very interesting and have good content. I possess a handful of website myself and I think you should take a look here: http://www.latestseotechniques.com You will find its a very nice forum that can give you access to all free seo techniques to get top rank on search engines. Keep up the quality posts.
I simply want to say I am newbie to blogging and site-building and definitely enjoyed your web page. Almost certainly I’m going to bookmark your website . You amazingly come with impressive writings. Appreciate it for revealing your website.
I simply want to say I am just beginner to blogging and site-building and really liked your web page. Very likely I’m want to bookmark your blog post . You amazingly come with remarkable article content. Many thanks for sharing with us your website.
I together with my buddies have been following the great information and facts from your website while the sudden I had a terrible feeling I had not expressed respect to the web blog owner for them. All the men became as a result happy to read them and now have very much been making the most of these things. I appreciate you for indeed being really accommodating and for obtaining this kind of superior guides millions of individuals are really wanting to understand about. Our sincere regret for not saying thanks to you sooner.