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

Click Here to Login
View Single Post
Old 10-24-2017, 12:07 PM   #1 (permalink)
rupeshforu3
Newb Techie
 
Join Date: Jul 2017
Location: India
Posts: 23
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
 


Copyright 2002- Social Knowledge, LLC All Rights Reserved.

All times are GMT -5. The time now is 10:10 PM.


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