Questions tagged [comparison]
File comparison is the process of comparing the contents of files, finding their common contents and their differences, usually using an automated tool
281
questions
0
votes
0
answers
9
views
Using fpcalc to compare two audio files
I wish to compare two audio files in order to determine wether they are encodings of the same audio or not.
The fpcalc utitlity, which is built on the chromaprint library, can be used to fingerprint ...
- 391
0
votes
1
answer
15
views
how do I compare dates separated by semicolon in same cell in excel
This is my data in column A. I want to compare dates with each other separated by semicolon to see if they all match or not and put the answer in another column saying match or no match. How do I do ...
- 3
0
votes
1
answer
24
views
Excel: How do I compare 4 columns with repetitions?
I have 4 columns. A,B,X,Y.
How do I compare all 4?
I want to create column Z where if A == X and the corresponding value B == Y, the result is 1. It is zero otherwise, how do I do that? Thanks
A
B
X
...
- 3
0
votes
0
answers
16
views
Cross-compare several files with a diff tool
Have anyone encountered the challenge of comparing several files with each other on a Mac/unix machine?
Consider a list of files 100.txt, 101.txt, 102.txt etc. in the same folder.
How can I cross-...
- 101
2
votes
2
answers
311
views
How to compare two hard drives (or folder) to find missing files in one of them?
I'm on macOS and, for context, I have one main hard drive that should include all my files (and yes, it's backed up with redundancy). And I have many other smaller hard drives that I have used over ...
- 71
0
votes
1
answer
26
views
Compare two excel files to change elements in cells
I have two excel files, A and B.
A is a dataframe with a header.
B has two columns, the first one has the original name and the second one has new name
A:
sam1 sam2 sam3 sam4 ....
p1 0 1 2 ...
- 3
0
votes
1
answer
227
views
Excel VBA - Dealing with Overlapping Times
I have a really big table in Excel that has multiple rows where each row contains a comparison between two employees that had worked over the same time. See examples of some sample rows in the image ...
- 11
1
vote
2
answers
364
views
How do I find common lines in two files
Let's say I have:
text.txt
with
1
2
3
4
5
and another
text2.txt
with
9
4
2
1
7
And I want to extract the duplicates:
2
1
4
Note: I'm using windows, I want it to be as easy as possible
- 11
0
votes
0
answers
77
views
Comparing Files to a list of MD5 Hashes and getting a List as Result (where i can delete, copy, cut etc. the results)
I am searching for a solution for the following situation. I have a list of Hashes in a Text File and i want to find every File in a certain folder and subfolders that matches the Hashes from the Text ...
- 1
0
votes
1
answer
16
views
One Cell number to compare in multiple rows
I have ID in Col A and Remarks in Col B. I need to Return status in Col C.
If Remarks against any specific ID is all Approved, it should show in status as "Approved".
If All remarks against ...
0
votes
1
answer
185
views
How to compare two videos and get timestamp(s) of differing frame(s)?
I've got rips of two copies of the same physical DVD. There's a difference between the two disc images - one of the videos files has a small binary diffence. I suspect one of the discs has physical ...
- 193
0
votes
1
answer
395
views
Excel formula to return value based on header and two columns
I'm trying to write an Excel formula that will place an "X" in a cell if the value in the header row occurs anywhere in column A while the values in Column B are unchanged. I envision the ...
1
vote
1
answer
260
views
comparing binary files at different offsets, reporting offsets of first difference
[About a month ago I asked a similar question, requesting a specific CLI software tool that would perform the required task ; it was quickly blocked on the ground that asking for specific software ...
- 777
0
votes
1
answer
270
views
Comparing ISO image files in Windows 10 or MacOS
I have a number of CDs and DVDs (some RW and some not). Some of these disks contain simple files (such as .txt, .doc, etc) and others contain Dell system drivers, various Windows OS's and so on. I am ...
- 1
0
votes
2
answers
532
views
Comparing two folders and copy differences in another folder
I want to compare Dir1 with Dir2 including subfolders for content ( the directory may contain binary data)
If there are differences, I want to create a DiffDir which has the changed or added files
...
- 173
0
votes
1
answer
35
views
Comparing Time (only) in two columns and returning value from the third column
I need to call the corresponding value of time from column F in column B.
Tried using Vlookup and match/index functions. But they are not working for time. If you know a quick method please share.
- 1
0
votes
1
answer
47
views
Compare 2 text files and create a 3rd text file where rows are formatted with common strings (adjacent string completion) [closed]
I have 2 text files.
text1.txt :
First is structured in this way
<title>Developing a wireless </title> ##www.google.com##
<title>Webdriver Actionchains </title> ##www.alfa.com#...
- 67
2
votes
0
answers
297
views
How can I interactively diff large binary files?
I'm trying to compare hex-dumps of some 500GB disk images. I can easily view parts of the files by piping hd into less. I'd like something similar to interactively diff them without having to read the ...
- 221
1
vote
2
answers
40
views
Seeing if a workbook contains data from another, and then adding the data if it doesn't?
Basically what title says, I have two separate workbooks with thousands of entries. One is an updated version of the other. I'm trying to find what's new in one workbook and add it to the older one.
- 11
1
vote
1
answer
153
views
ExcelFuzzyLookUp: Compare Cells In The Same Row
I'm trying to compare two cells that are in the same row and same table. I've been trying to use Fuzzy Lookup to provide a measure of similarity but what happens is that the cells move to match what I'...
4
votes
1
answer
5k
views
Windows Batch Script to Compare Two Text Files
I have this script:
for /f "delims=" %%a in (data_A.txt) DO (
set "flag="
for /f "delims=" %%b in (data_B.txt) do (
if "%%a"=="%%b" CALL :flagit
)
if not defined flag >>...
- 399
1
vote
0
answers
24
views
Visual Studio comparing workspaces
First, let me explain the situation:
I'm a software developer currently in home office.
Normally we're using a TFS to sync our sources, but from home I don't have a connection to the TFS.
So I'm ...
- 111
0
votes
1
answer
42
views
Comparison Operator in Powershell
I have a script that is currently working. There are two groups that need to be omitted from the CSV that is exported. As it currently sits it works. see below:
Import-Csv -Path .\importactiveusers....
- 27
0
votes
2
answers
67
views
Compare 2 Lists of E-mail Addresses
How can I go about performing a comparison between 2 lists of e-mail addresses? Specifically, I am looking to find what e-mail addresses are not present in one list vs the other.
- 191
0
votes
1
answer
52
views
awk comparison on Ubuntu
I'm trying to write a script that check the disk usage of remote clients. There is a filter in script for meaningful output:
...
ssh server "sudo df -Ph 2>/dev/null \
| tail -n +2 \
| grep -v ...
- 755
0
votes
1
answer
5k
views
Compare Two Files and Remove the Duplicates
What is the easiest way to compare 2 files and deleting the duplicates found on both files. I'm aware you can do this easily on a linux box with certain commands, but how would I go about achieving ...
1
vote
1
answer
134
views
Microsoft Word: how to compare and edit 2 documents, without creating a 3rd one
I do proof reading on documents written by non-native English speakers.
With text editors you get to compare 2 versions of the same document and you
can edit either directly.
In Microsoft Word, ...
- 133
1
vote
0
answers
22
views
Merge two incomplete backup volumes together on a third drive?
I have 2 drives that use to be backed up to each other (a 2TB drive to a 3TB drive) but they fell out of sync a long time ago. Files on the drives may not be located in the folders they use to share, ...
- 876
0
votes
2
answers
849
views
Excel: Column comparison with dates and values
I currently have 4 columns that contain data on Bitcoin Prices and S&P 500 closing day values, as well as their respective dates:
Since the S&P 500 is closed on non-trading days and the ...
-3
votes
2
answers
146
views
Why is there a loss in processor power emulating 32bit programs on a 64bit system?
May be a stupid question but I cannot find a clear answer.
Host CPU=Emulated CPU
Pentium Pro 200 MHz = 286 6 MHz
Pentium II 350 MHz = 386SX 25 MHz
Pentium III 1.0 GHz = 486 66 MHz
Pentium ...
- 1
-1
votes
1
answer
134
views
Excel - Need to compare two times in order
I am using excel to compare two date columns that i need to compare. One is an Expiry time (SLA Expiry Time) and the other one is when it was actually updated (Initial SLA Contact Time).
It is to ...
- 101
3
votes
1
answer
2k
views
Compare two binary files of different sizes
I am trying to compare two binary files in order to identify one of them.
The first file I have contains the data I am interested in and can use to identify the second. The second file is from a 3rd ...
- 131
2
votes
0
answers
971
views
mac tmutil compare works or fails depending on WHERE bundle is mounted
Using Time Machine to a Time Capsule - backups work smoothly. The problem is trying to use 'tmutil compare' to see the differences between 2 backups. MacOS Mojave 10.14.5 (same problem on previous OS ...
- 21
1
vote
0
answers
952
views
Microsoft Excel Fuzzy Lookup add-on - set too big?
The data I'm comparing is a set of cataloged items (90k items) with an old list of items we thought were missing (about 11k). I need to see if any of the "missing" items actually show up in the ...
- 11
0
votes
0
answers
333
views
Compare two whole HDD's contents, sector-level
While analysing two 4TB HDDs, which were in some kind of RAID 1 configuration, and thus have the same contents in terms of files / folders (they have been reformatted but R-Studio lists the same file ...
- 777
1
vote
0
answers
59
views
Redgate SQL Data Compare - Command LIne Output File
I am comparing 2 databases via command line. When I execute the following command:
SQLDataCompare /project:"C:\CompareFiles\compare_AW1_AW2.sdc" /Include:table:[Users] /Out:"C:\Users\mthurman\...
- 11
2
votes
1
answer
84
views
Compare and partly merge multiple projects without common ancestor
I'm looking for a way to compare/diff 3+ different, strongly related projects, none of which is the others' common ancestor and copy around ("merge") single chunks,
and specifically test files.
I do ...
- 23
0
votes
1
answer
598
views
How to compare multiple PDF files?
My professor just uploaded an updated set of all the slides of the whole semester (17 PDFs), referring to them as the now definite examination material.
Problem is, I have made lots of notes on the ...
- 103
0
votes
1
answer
51
views
Match 2 sets of numbers in 2 cells
I have 2 cells with similar data extracted from 2 different websites. Data in D6 is supposedly shorter version of H6. I want to put "Match" or "No Match" in E6. For "Match" either 2 sets of numbers ...
0
votes
2
answers
4k
views
Excel check if combination of data exists in a certain range
See question 1337631
Check if a specific range of values in one dataset exists in another dataset
This solution works great, but what if you want to check WITHIN the same range?
Want to use this for ...
- 1
1
vote
1
answer
69
views
Compare excel worksheets
Here is the problem I have been trying to resolve all morning - I have two Excel worksheet files:
Subset: This file has a subset of employees with various details including training status such as in-...
- 11
0
votes
1
answer
56
views
Determine Multiple values exist in column for same values in other column
I am hoping someone can help me with a formula for the following:
Excel hard data
My goal is to have an addition column return a yes or a no.
Yes if there are different values in column B for the same ...
- 3
1
vote
2
answers
6k
views
Compare three or more Word documents (*.docx)
I've seen multiple questions and answers for how to compare two Word documents, and I've seen some questions and answers for how to compare three or more raw text files, but I'm struggling to find a ...
- 311
1
vote
0
answers
1k
views
Compare two folders on the basis of file names only
First , let me explain my situation , I have been scraping images from a website to a local folder, I used OpenCV to apply pre-processing on said images and produced the processed images with exactly ...
- 111
-2
votes
1
answer
135
views
How do the "games-oriented" NVIDIA-GPU-based cards behave w.r.t. CUDA computation?
NVIDIA makes GPUs, which are used both for graphics and for graphics-unrelated computing. It also publishes compute-related specs of its GPUs.
Now, when it comes to cards:
there are some cards that ...
- 7,312
0
votes
1
answer
904
views
HLS vs HTTP format codes in youtube-dl
I am using youtube-dl on windows 10 64 bit. I am new to this program. I checked the available formats for a video from dailymotion like this:
youtube-dl -F "http://www.dailymotion.com/video/". In the ...
1
vote
2
answers
727
views
Compare binary files with different meta data
In Windows, I wish to compare old binary files with newly built ones in order to determine which files has been updated. However, when I build the files I give them new meta data details (like version ...
- 33
1
vote
2
answers
2k
views
Check if a specific range of values in one dataset exists in another dataset
I have two datasets, 1 and 2, each containing a number of columns with values. My end goal is to find all of the rows in dataset 1 that are different from and can't be found in dataset 2.
Dataset 1 (...
- 15
1
vote
0
answers
2k
views
Is there a way to compare two web pages or tabs in Chrome?
I have a website that offers me a "preview" mode, and a "live" mode of a document. I can open each in their own tab in Chrome. I'd like to know if there is a way to compare the two in Chrome, perhaps ...
- 111
1
vote
3
answers
113
views
Cross compare data between 2 workbooks
I'm trying to cross compare 2 data in 2 different workbook. Then, I need to find the missing data between the 2 and make a separate new, updated list. However, I only need to update the data if there'...
- 13