#1
|
|||
|
|||
how to compare 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.
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 and same file names and paths but differs in playback length. I want to compare two such files and suggest how to either using Microsoft office 2013 itself or using any other tool or software. Also suggest how to calculate total sum of time column which is in format HH:MM:SS Regards, Rupesh. |
#2
|
|||
|
|||
To sum the time is easy...open in Excel and just do a normal sum. The result should be in the same format.
As for the comparing, I'm not really sure I understand. If the tracks have the same filename and path, why would they be different? Would each track exist in both CSVs? |
#3
|
|||
|
|||
Quote:
I have transcoded mp3 files. Some of the source files were corrupted and so they were not transcoded properly and so there may be differences between two files. |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
How to compare two columns and match data | Neydo222 | Excel | 2 | 09-12-2015 02:49 AM |
Compare columns + calculate difference | Inatic | Excel | 1 | 01-27-2013 08:00 AM |
Compare 4 columns & find dissimilar | kmorrin | Excel | 4 | 06-29-2011 04:38 PM |
How to compare 2 columns with other two columns in EXECL 2007? | Learner7 | Excel | 5 | 06-12-2010 09:54 AM |
Compare data in different columns in an Excel sheet | kgfendi | Excel | 5 | 05-16-2009 05:42 PM |