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
290
questions
-1
votes
0
answers
23
views
Identify files that have changed in my hard drive
Everytime I run a process within an application it causes a failure that can only be fixed when reinstalling the application.
I want to keep track of exactly which files have changed, added or deleted ...
- 11
0
votes
1
answer
29
views
Compare requirement list with received list in excel
I receive a matrix of requirements that validate corresponding Values as below:
And a current matrix with the completed requirements marked with x:
Is it possible to compare the matrices and return ...
0
votes
1
answer
113
views
Removing duplicate rows in a CSV file as compared to another CSV file
I have a CSV file named CSV1 with over 5000 rows and 3 columns - last name, first name and email address. I have another file named CSV2 with about 2700 rows with the same 3 columns. I have to remove ...
2
votes
0
answers
226
views
Compare 2 videos at different frames with ffmpeg
I use this FFmpeg command to compare 2 videos:
ffmpeg -i video1.mp4 -i video2.mp4 -filter_complex "[0:v][1:v]blend=difference,blackframe=1:10" -f null -'
The command compares the same frame ...
- 21
1
vote
1
answer
714
views
MS Word Compare not showing changes
I recently changed from a computer running Windows 10 Pro 64 with Office 2019 Pro to Windows 11 Pro 64 with Office LTSC Pro Plus 2021.
Today, for the first time since that change, I tried using MS ...
- 642
0
votes
0
answers
31
views
Highlight the lowest value from a second column of identical items in first column in Excel
In a file with 3852 rows, in col A, each cell has a code and a corresponding value in column B.
Some cells in col A have the same code (are equal) but the values could be different in col B.
Column A: ...
0
votes
2
answers
90
views
Excel formula to compare a 6 cell row against a reference row and return value that are missing
I need to work out a problem I have with formula logic.
there's a picture with the exact outcome I'm trying to achieve below
i have a long list of rows that contain cells with criteria in them that ...
1
vote
2
answers
97
views
How to compare two columns of a HTML (or XML) file, looking for number differences?
As a English to French translator, I can create a bitext of my work, which is a file with 2 columns, the English on one side and the French on the other. These bitexts can either be in HTML of XML ...
- 11
0
votes
1
answer
57
views
Using excel to find missing daily logs for people
I have an excel file with 2 worksheets.
One has a list of daily logs and looks like this:
Staff Person | Shift Date | Start Time | End Time
John | Oct 31 | 8:00 AM | 4:00 PM
John | Nov 3 | 2:00 PM | ...
- 103
0
votes
1
answer
47
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
191
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
121
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
6k
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
34
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
457
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
3
votes
2
answers
4k
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
- 31
0
votes
0
answers
276
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
30
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 ...
1
vote
1
answer
1k
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 ...
- 319
0
votes
1
answer
589
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
1k
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 ...
- 855
0
votes
1
answer
761
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
3
votes
2
answers
3k
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
...
- 303
0
votes
1
answer
69
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
211
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
1k
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 ...
- 231
1
vote
2
answers
51
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
3
votes
5
answers
2k
views
Can WinMerge be used as a plain text diff tool, without needing to compare existing files?
I want to use WinMerge as a plain text diff tool, without needing to compare existing files.
That is, I'd like to just click ctrl+n, paste two plain texts onto both sides, hit f4 and find differences. ...
- 300
2
votes
1
answer
531
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
9k
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 >>...
- 469
1
vote
0
answers
36
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
194
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
169
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.
- 201
0
votes
1
answer
63
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 ...
- 805
0
votes
1
answer
7k
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
405
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, ...
- 143
1
vote
0
answers
27
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, ...
- 916
0
votes
2
answers
1k
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
181
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
188
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
4k
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
1k
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
1k
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
540
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 ...
- 855
1
vote
0
answers
101
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
111
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
638
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
148
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
6k
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
72
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