comparing two csv files mainly two columns containing time - Techist - Tech Forum

Go Back   Techist - Tech Forum > Computer Software > Microsoft Windows and Software > Tips, Tricks & Tutorials
Click Here to Login
Reply
 
Thread Tools Display Modes
 
Old 10-24-2017, 01:07 PM   #1 (permalink)
Newb Techie
 
Join Date: Jul 2017
Location: India
Posts: 14
Default comparing two csv files mainly two columns containing time

Hi I am Rupesh from India and I have some csv files and I want to compare these files and so searching for software. I have installed opensuse leap 42.3 on my PC with openoffice.



All the files which I want to compare consists of properties of audio files they are filename, playback length, audio codec, bitrate, file path.



Suppose I want to compare two files the two files consists of same columns.



I want to compare two such files considering first column ie., FileName. Can you suggest how to create a new csv file which consists of rows which are unique I mean the FileName field must not contain in the first file or in the second file.



Suppose the two csv files consists of say 1000 rows with columns FileName, PlayBackLength,Path,AudioCodec. Can you suggest how to create a new csv file which consists of rows which are not equal in PlayBackLength I mean they differ in that column only and has similar values in other columns.



Also suggest how to calculate total sum of time column which is in format HH:MM:SS



Can you try to suggest how to use csvdiff tool for the above purposes. Is there any other tool or software to achieve the above purposes.



Regards,

Rupesh.
rupeshforu3 is offline   Reply With Quote
Reply

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
How to create a database for the contents of folder containing 11000 mp3 files. rupeshforu3 Tips, Tricks & Tutorials 0 08-31-2017 10:09 AM
Bash scripting csv files. Sheepykins Linux and Open Source 2 10-28-2013 12:35 PM
Split CSV Files Osiris Tips, Tricks & Tutorials 0 11-30-2008 07:14 PM
VB - MSHFlexgrid clicking specific Columns DKasler Programming 1 05-09-2005 04:46 PM
Explanation of Columns in Temp Net Files puzzledizme Viruses, Spyware and Malware 1 06-12-2004 08:32 PM



Copyright 2002- Social Knowledge, LLC All Rights Reserved.

All times are GMT -5. The time now is 05:13 AM.


Powered by vBulletin® Version 3.8.8 Beta 1
Copyright ©2000 - 2017, vBulletin Solutions, Inc.