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
272
questions
0
votes
1answer
80 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 ...
0
votes
1answer
39 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 ...
0
votes
1answer
58 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 ...
0
votes
2answers
32 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
...
0
votes
0answers
8 views
Macro to compare columns in two sheets and enter YES
I have name and contact number in Columns A and B respectively in Sheet 1, about a lakh entries. And I have about 50K mobile numbers out of the lakh in Column A in Sheet 2. I need to look for these ...
0
votes
1answer
25 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.
0
votes
1answer
45 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#...
1
vote
0answers
49 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 ...
1
vote
2answers
34 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.
1
vote
1answer
51 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
1answer
3k 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 >>...
0
votes
0answers
22 views
Robocopy file modification even though MD5SUM matches
I recently joined a company where the admin setup DFS and pooched it by "helping DFS" by manually copying over files to speed up the process. Now on the Secondary site there is a huge backlog, and dfs ...
1
vote
0answers
19 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 ...
0
votes
1answer
34 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....
0
votes
2answers
49 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.
0
votes
1answer
48 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 ...
0
votes
1answer
3k 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
1answer
60 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, ...
1
vote
0answers
14 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, ...
0
votes
2answers
693 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
2answers
122 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
votes
1answer
72 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 ...
3
votes
1answer
1k 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 ...
1
vote
0answers
702 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 ...
1
vote
0answers
739 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 ...
0
votes
0answers
193 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 ...
1
vote
0answers
39 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\...
2
votes
1answer
75 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 ...
0
votes
1answer
577 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 ...
0
votes
1answer
44 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
2answers
3k 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
vote
1answer
64 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-...
0
votes
1answer
46 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 ...
1
vote
2answers
5k 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 ...
1
vote
0answers
965 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 ...
-2
votes
1answer
131 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 ...
0
votes
1answer
753 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
2answers
569 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 ...
1
vote
2answers
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 (...
1
vote
0answers
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 ...
1
vote
3answers
109 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'...
0
votes
1answer
615 views
Use fc.exe in batch file to separate new lines from old lines
I have two text files mount.txt and mount2.txt and I've been trying to separate new lines (lines that were not in mount.txt but are in mount2.txt) from old lines (lines that were in mount.txt but are ...
0
votes
1answer
1k views
How to compare two columns of two different files
I have two file.The first one contains something like:
a.com,5,some,text
b.com,10,some,text
c.com,5,some,text
d.com,12,some,text
e.com,5,some,text
c.com,5,some,text
The second contains something ...
-1
votes
3answers
5k views
Excel VBA - Search for multiple Values in two Excel Sheets
I have two Excel sheets and I need to copy values from one to the other.
Sheet 1: Contains ID´s in one column and Data in another, which I want to have in Sheet 2 later on.
Sheet 2: Contains the ...
0
votes
1answer
25 views
Count values depending on Equality Compare
I have a tables that looks like the following:
I have multiple Item rows, and for each there are many Value columns, and a single Result. What I would like to do in my TOTAL is, for each Value column,...
0
votes
1answer
103 views
Find similar documents between two piles of documents [closed]
I am looking for ways to find similar documents between two group of text documents. I know ways to compare two files. But I am looking for ways to do that between two group of files.
Let's say ...
3
votes
0answers
676 views
Compare 2 video files for 'cut' differences
I have 2 video files with the same content, but coming from a different source. They have a slight difference in 'cut', meaning one can be missing a shot compared to the other.
I have a subtitle file ...
1
vote
0answers
349 views
Error: Command 'download_from_google_storage --no_resume --platform=linux* --no_auth --bucket chromium-clang-format
When I try fetch v8 or gclient sync I get this error:
Error: Command 'download_from_google_storage --no_resume --platform=linux* --no_auth --bucket chromium-clang-format -s v8/buildtools/linux64/...
0
votes
1answer
157 views
Break down the following bash script?
I need help breaking down the following bash script, to understand what the author was trying to do. The script is meant to search a log file for data and then compare it to an email log file. ...
1
vote
1answer
3k views
How to compare files in 2 HDDs, find exact copies and different files and sync only what I need?
Problem: I've got 2 external HDDs, which contains ONLY music files in many folders/sub-folders with some strict hierarchy (Artist/Band name - Albums name folders - song files), but different types (...
